Conditional Statements in Jasper Reports

[2002 JI Open Discussion]

By: Muralidhar bp - pmurli

Conditional Statements in Jasper Reports

2003-01-17 03:42

Hello,

 

I have to use conditional statements in XML query, for example

 

IF (CONDITION)

query 1

 

ELSE

query 2

 

Please help me

 

Thanx

Murli

 

 

 

 

By: Chuck Deal - cdeal

RE: Conditional Statements in Jasper Reports

2003-01-17 05:27

If your number of choices are small you can use the tertiary format

 

(expression ? true-part : false-part)

 

For more extensive conditionals, you might want to look at scriptlets.

 

 

 

 

By: Teodor Danciu - teodord

RE: Conditional Statements in Jasper Reports

2003-01-17 05:44

 

Hi,

 

You can supply the entire SQL query at runtime

using a parameter like this:

 

<queryString>$P!{MyDynamicQuery}</queryString>

 

Then, the question is: where you make the IF test

and choose the right query

(the right MyDynamicQuery parameter value).

You could do this outside JasperReports, before

even passing the parameters to the engine.

But if there are only two possible queries, you

could use the <defaultValueExpression> of the

query parameter based on other parameters that

you actually supply.

 

Unlimited variations of this scenario are possible.

 

I hope this helps.

Teodor