Jump to content
Changes to the Jaspersoft community edition download ×

Using Parameters in the Report Query (FROM-clause)


Recommended Posts

Dear all,


i'm using JasperReports for quite some time now. One thing that bugs me is that i can't use Parameters inside the Report Query before the 'WHERE-clause'... I would like to pass in some let's say Temporary Table Name as Parameter when filling the Report. It seems to me that JasperReports doesn't replace Parameters used in the 'FROM-clause'...


BTW: I've had this Problem in all Jasper Versions i've tried so far. (1.2.0, 1.2.8 and the newest 1.3.3)


Any reason / suggestion / solution to that?


Thanks in advice,


Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Sorry... seems like i've read over the second paragraph in the Tutorial.... i must have missed the exclamation mark.


$P!{PARAMNAME} works fine for replacing entirely parts of the query....


Great Help Lucian!




Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...