Make any one of the two parameters mandatory.

[vincydza@gmail.com]

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

[sunny bachan prasad]

Can you please explain in detail what you really want.

[vincydza@gmail.com]

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

[vincydza@gmail.com]

Is there a solution to this request.

Vince

[BigChris]

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?)