nyttle Posted November 1, 2006 Share Posted November 1, 2006 Hi,I want to filter data for a specific period. I defined two date parameters like $P{FromDate} and $P{ToDate}; but , when I run the report, I get all records without any filtering. this is my sql in the report- select * from customer where trunc(createdate) between to_date($P{FromDate},'dd-mm-yyyy') and to_Date($P{ToDate},'dd-mm-yyyy').I also tried like this select * from customer where trunc(createdate)>= to_date($P{FromDate},'dd-mm-yyyy') and trunc(createdate)<=to_Date($P{ToDate},'dd-mm-yyyy'). I am using Oracle database and using Oracle datasource connection in the report.This sql runs perfectly in toad and returns the filtered resultset. If I hardcode a value for the date instead of using parameter the report returns the filtered data. If any one can help, please.Thanks,Nyttle Link to comment Share on other sites More sharing options...
swood Posted November 1, 2006 Share Posted November 1, 2006 There is a attribute on the parameter definition in JRXML with a name like promptFor... If you set it, iReport will prompt you to fill the parameter in before the report is run. ShermanJasperSoft Link to comment Share on other sites More sharing options...
danielscherczer Posted June 18, 2015 Share Posted June 18, 2015 Yeah i had this problem but couldnt find a way around it 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