Hi Cognos Gurus,
I have a quick question in the Multiple prompts report.
I have created 3 different prompts on a single prompt page and i wanted to give it as an OR condition between those 3 prompt conditions.
For ex:
First prompt condition is to select a Employee Number- i have created Select and Search prompt for this one
Second prompt is to select a Department Number- i have created Select and Search prompt for this one as well.
Third prompt is the combination of Employee Name and Employee State- i have created Select and Search for Employee Name and created Value prompt for Employee State.
My question is if the user selects any one of the conditions the report should run, so basically it has to be an OR condition i am supposing.
My problem is that until and unless i provide all 3 prompt conditions the reports is not running.
So need some help on this. Thanks in advance
Are the prompts set as Required or Optional ? Do you have any default selections defined for the prompts ?
The prompts are required.There are no default selections for defined prompts.
I want the report to run for whichever prompt i select, i mean it is supposed to show the Finish Button ven if i select 1 prompt out of the 3 exisiting prompts.
If a prompt is required and has no default selection then the user must provide a response or you must provide a default. You can't have it both required and optional.
Try adding a dummy default value and then adapting your filter to account for those situations.
( [Emp Number] = ?SelectEmpNumber? and ?SelectEmpNumber? <> -1 )
or
( [Dept Number] = ?SelectDptNumber? and ?SelectDptNumber? <> -1 )
etc.....
you can give the prompt a default value in cognos connection.