pentaho Posted January 20, 2009 Share Posted January 20, 2009 Hi,My MS SQL Query in iReport.........select Title, dateadd(second, Create_Date,'01-01-1970') Create_Date FROM Service_Requestwhere CONVERT(datetime, dateadd(second, Create_Date,'01-01-1970')) >=$P{StartDate}i'm using datadd function to convert integer value to datetime data type........The date is stored in a longint format or in a simple way my query will be like this..select Title, Create_Date FROM Service_Request where Create_Date >=$P{StartDate}output..........Titles Create_Dateabc 2009-01-20 05:08:07.000xyz 2009-01-20 05:15:41.000dd 2009-01-20 05:31:38.000I have created one parameter $P{StartDate} in ireport of date type and i''m getting output in iReport....I'm not getting output in JasperServer.............Create_Date value is 01-20-2009 through calendar , (parameter passing in jasper server)I have added a date control variable in jasper server( it shows Empty report)..............tell me any thing wrong in my query or wrong in parameter passing in jasper server.........Thanks Link to comment Share on other sites More sharing options...
pentaho Posted January 20, 2009 Author Share Posted January 20, 2009 Hi, If any one has implemented how to get the records between two dates, ..........simple sql queryIireport)this is parameterised reportselect a,b,c from table1 where date1 >= $P{StartDate} and date2 <= $P{EndDate} Values entered through calendar(iReport)$P{StartDate} , $P{EndDate} please send me the query(iReport) andsteps involved in the jasperserver(Date parameter creation)........... Thanks Link to comment Share on other sites More sharing options...
pentaho Posted January 20, 2009 Author Share Posted January 20, 2009 Hi, I got the solution....... Link to comment Share on other sites More sharing options...
lukas1596 Posted January 20, 2009 Share Posted January 20, 2009 make sure to try everything you can before spending someonelse's time.and when you get the solution, its nice to post it, other users can get the same problem. 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