Comments by SmoothCriminel (Top 6 by date)

Aha... I got it now. So, like this I don't even need to create any parameters. And on the java side I will create the selection formula and just send it to report. Will that be good option? Or it wont work. Thanks a lot for help.

The issue is with last "and" I believe. What ever input I give for the "DeptName" there is no where clause when I see the generated SQL.

Hi thatraja, thanks for response. Although I am working in java but even then its helpful. Thanks again.
It will be great if you can tell me how the formula will look, lets say I have fields EMPLOYEE.BIRTHDATE (type = date) & EMPLOYEE.WORKDEPT (string). Report has three parameters 1. FromDate (Date), 2. ToDate (Date) and 3. DeptName (String).
Now user will select dates and it can either enter or leave the DeptName field empty. If its empty then all departments should be selected otherwise the one it entered.
I have tried creating this formula:
{EMPLOYEE.BIRTHDATE} >= {?FromDate} and
{EMPLOYEE.BIRTHDATE} <= {?ToDate} and
If (StrCmp({?DeptName},"") = -1) Then
(
// Add statement here
{EMPLOYEE.WORKDEPT} = {?DeptName}
)
I know this is not correct... Can you please create it?
BR
SC

Thanks a lot for detailed response... But I am talking about Java :)

BR
SC