Hi,
My report in report studio is having the following two filter parameters.
[Transaction date] between ?From Date? AND ?To Date?
[Shop order No] IN (?Shop Order No?)
How can I make any one of the two parameters mandatory.
Vince
Can you please explain in detail what you really want.
The behaviour of the parameter screen should be like if the user has entered values for transaction dates then shop order number filter criteria should not be mandatory or if the user enters value for Shop order number then Transaction date filter criteria should not be mandatory.
At any point in time any one of the two filter criteria must be mandatory.
How can this be achieved?
Regards
Vince
Is there a solution to this request.
Vince
I would imagine that to do that you'd need to do something in Javascript. I don't know of anythinfg in native Cognos that would do that for you. You can obviously combine the two parameters in your filter using something along the lines of:
(?parameter1? is not missing and [Shop Order] = ?parameter1?) or (?parameter2? is not missing and [Transaction Date] = ?parameter2?)