besweet

I had a report that needs to display the user-inputed parameters (includes: Data parameters). However, the user can fill nothing in these data parameters. I had used the textfield for display the user-inputed parameters. When the date parameters are filled values, the report can show it out. However, I found that if I fill notthing into the data parameters, the report will display the current date in here. I would like to ask how to modify it to display the "hyphen" rather than displaying the current date. The data parameter setting is: SDate (java.util.Date, use as a prompt).

I had tested the query in Toad, it can find data via this query.When I run the report, it had show the following error message.

Hello everyone. I'm a newbie to iReport. I am trying to write the conditional query into the report. I had created the following parameters: $P{queryControl} <String> ${date} <Date> ${deptName} <String> The parameter called $P{queryControl}, the prompt is turned off as I am setting the value at runtime checking the value of the $P{sex}. Also, the ${date}, ${deptName} turn on the prompt. Set the default value of the parameter as: $P{sex}.equals("F") ? "Select * from employees e, department d where e.staff_no = d.staff_no and department_name = '"+${deptName}+"' and join_date >= ${date}" : "Select * from employees e, department d where e.staff_no = d.staff_no and department_name = '"+${deptName}+"' and join_date <= ${date}" However, I found that it's not work when I run the report. When I not use ${date} in where-clause, the report can be opened. Any solution? Thanks in advance.