Parameter Date Report

[pentaho]

Hi,

My MS SQL Query in iReport.........

select Title, dateadd(second, Create_Date,'01-01-1970') Create_Date FROM Service_Request
where 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_Date

abc                                          2009-01-20 05:08:07.000
xyz                                            2009-01-20 05:15:41.000
dd                                            2009-01-20 05:31:38.000

I 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

 

[pentaho]

Hi,

 

If any one has implemented how to get the records between two dates, ..........

simple sql queryIireport)

this is parameterised report

select 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) and

steps involved in the jasperserver(Date parameter creation)...........

 

 

Thanks

[pentaho]

Hi,

 

I got the solution.......

 

[lukas1596]

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.