ktrinad Posted August 31, 2006 Share Posted August 31, 2006 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?? Thanks, Vivek 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} Regards Giulio Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now