Jump to content
Changes to the Jaspersoft community edition download ×

query values in a variable


Recommended Posts

By: vivek srinivasan - viveksrinivasan

query values in a variable

2003-10-09 09:54

Hi all,

I have a query like

select * from emp where trandatestart>='2003-08-05' and tandateend<='2003-08-10'


I want to put the trandatestart and trandateend in the report page header.Is there a way where i can do this. My trandatestart and trandate end changes frequently.Can i put those values in a variable and then dispaly it in the report??








By: Giulio Toffoli - gt78

RE: query values in a variable

2003-10-10 04:18

You should but this in two parameters, not in variables.


In this way you can pass the value for your trandatestart and tandateend dinamically when you fill the report.


Having this two values as parameters, in your header you can put two textfields with expressions like:

$P{tandatestart} and $P{trandateend}





Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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...