sawandj

hi all, i am stuck in this problem from 2 days.. can any one help me on this.. i have create a report with two parameters $P{start} and $P{end} for start date and end date. when i enter bot the dates it works.. when i do not enter any date or dont fill any 1 of the the.. the report will not work.. displays no "DOCUMENTS HAS EMPTY PAGES" i tried to use this query but still it does not work.. the query is used+ select * from tblTimeSheet where TSSubmitDate >=($P{start} or $P{start} is null) and TSSubmitDate <=($P{end} or $P{end} is null) order by TSSubmitDate; i even tried out the query select * from tblTimeSheet where $P!{date}; where $P{date} is a 3rd token in which i have edited the expression with $P{start} == null || $P{end} == null ? "0=0" : "TSSubmitDate between $P{start} and $P{end} but reports are not properly getting generated.. can any 1 help me on this.. its urgent thanks..

thanks for the reply i really appreciate it... i have tried the method you mentioned.. but when i am entering both startdate and enddate the reports is not getting displayed..if i dont enter any dates it works fine. if i jus give the start date report displays from start date.. thanks..

hi all, i am a neww bee for jasper reports. so please help me on this , its urgent. i am using iReport 3.7.0 . i have create a report with 2 parameters $P{startdate} and $P{enddate}. i am able to generate report if i enter dates in the both the parameter. now the question is . if i leave any of the parameters blank or both the parameters blank the report will not show any data. the query what i have enterd is select * from tblTimeSheet where TSSubmitDate between $P{startdate} and $P{enddate}; so can any 1 tell me what should be the alternate query of it. so please help me on this. its urgent. thanks ...

hi all, i am a neww bee for jasper reports. so please help me on this , its urgent. i have create a report with 2 parameters $P{startdate} and $P{enddate}. i have am able to generate report if i enter dates in the both the parameter. now the question is . if i leave any of the parameters blank or both the parameters blank the report will not show any data. the query what i have enterd is select * from tblTimeSheet where TSSubmitDate between $P{startdate} and $P{enddate}; so can any 1 tell me what should be the alternate query of it. so please help me on this. its urgent. thanks ...

hi all, i am a neww bee for jasper reports. so please help me on this , its urgent. i have create a report with 2 parameters $P{startdate} and $P{enddate}. i have am able to generate report if i enter dates in the both the parameter. now the question is . if i leave any of the parameters blank or both the parameters blank the report will not show any data. the query what i have enterd is select * from tblTimeSheet where TSSubmitDate between $P{startdate} and $P{enddate}; so can any 1 tell me what should be the alternate query of it. so please help me on this. its urgent. thanks ...

i didn’t use any component at first place , because first i tried to create the DB connection but it was not getting connected...

can any 1 help...

hi guys, I am new to jasper etl . I am trying to create a new remote mysql DB conncetion. can any one tell me how to do it.. when i tried to do it, i got this error. Connection failure. You must change the Database Settings. java.lang.ClassNotFoundException: com.mysql.jdbc.driver the seetings what i used was. DB type: GENERAL JDBC JDBC url : dbc:mysql://'ip number':3306/db name Driver jar : mysql-connector-java-5.1.16.jar class name : com.mysql.jdbc.driver user name : root password. ***** when i click on check connection. it get the above error message. help will be really appriciated... thanks and regards..