Passing dates to the report - urgent please reply

I have to and from date input parameters in the form. When the query is filtered by the dates, it should get displayed in the report as 'MM/DD/YYYY' format and when we don't pass anything as input parameters through the form, it should get all the records and in place of to and from dates, it should display 'ALL'.

I am using this java script functions in the Birt report as follows:

if (params["PRM_FRM_DT"].value == null)
{ this.content = "ALL" }
else
{this.content = params["PRM_FRM_DT"].value}

and using to_char for the dates in the form.

I have tried making these parameters of type date or string in the report but still it doesn't get any data when I search by dates in the form, otherwise it works fine. Can you please help me with this.

Find more posts tagged with

Comments

mwilliams

Can you recreate your issue with the sample database, so I can see what you're seeing?

sweth

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="91544" data-time="1323813465" data-date="13 December 2011 - 02:57 PM">
Can you recreate your issue with the sample database, so I can see what you're seeing? </blockquote>
 
We were able to resolve the previous issue but there is one more which is causing the data not to display. We have multiple input parameters (like user name, county, to date, from date, etc.). When any of the parameters are entered individually, the data is returned. When "to date" and "from date" are entered together, no data is displayed in BIRT. We know the data set is working correctly because we gave "to date" and "from date" default parameters and the "preview results" feature displayed the correct data. The data type of the "to date" and "from date" parameters is DATA. When we preview in PDF format, the data is no longer displaying. 
 
We are not supposed to create sample databases.

mwilliams

You don't have to create a sample database. "The sample database", is the Classic Models database that comes with BIRT for creating reports with a common database, so that you can share the design and the recipient can run the report because they too already have this data.