Two query's, one report

[Tiaguinho]

Hi,

I'm be construct a report and this report have a parameter which must switch the query. For example:

$P!{tipo_relatorio}.equals("orcamento") ? "query_1" : "query_2"

But a have no idea as resolve this problem.
My report is a list of two distinct situation, so I need this.

Is this possible?

Thanks for anywhere help.

[mbmorgan]

Here is a link to a very helpful video on how to implement conditional queries:

 

http://community.jaspersoft.com/blog/how-implement-conditional-query-ireport-using-sample-database-sample-included

 

Good Luck!

M.B.Morgan

[hozawa]

Check in using $P!{} . Page 84 in Jaspersoft Studio documentation.

http://community.jaspersoft.com/documentation/jaspersoft-studio-user-guide