Input Parameters

[jmorton]

Hello,

 

I am relatively new to Jaspersoft 5.6. I have created a report and added two parameters and two corresponding input controls to a report to select a date range. When I run the report and input the date range, the report is blank (as opposed to when I hardcode dates into the query). The Dataset and Query Dialog displays the parameters in red. I am thinking that is the issue, but I cannot determine why:

AND SHARE.OPEN_DATE BETWEEN $P{StartDate} AND $P{EndDate}

The parameters appear in the "Parameters" tab in the lower pane and are correctly set to java.util.Date.

The parameters are also set at the report and table level. What might I be missing?

Thanks,

Josh

 

 

[hozawa]

Try outputting SHARE.OPEN_DATE, $P{StartDate}, and $P{EndDate} in a report to see those values.

[joel.carlson]

You might have to link the parameters from the main report to the table. Right click on table in main report and edit datasource. In the parameters tab click add. In the dataset parameter name select your start date paramenter from the table query. Then under value expression select the start date parameter for the main report. Do the same for the end date and you should now get data.

[jmorton]

Thank you Joel! Adding the parameters to the dataset worked perfectly.

Josh

[joel.carlson]

No problem, I had a similar issue.