Hi all,
I have a list report which uses a query with a datasource of stored procedure.
I have a prompt combo box with values which is given as a parameter of the stored procedure.
The prompt combo box is Required because it is a parameter of the stored procedure.
(http://stancho.com/cognos/prompt_not_selected.PNG)
It is working correct but if I set a filter of the combo box my Finish button (on the prompt page) is ALWAYS DISABLED!
(The filter of the query is very simple)
(http://stancho.com/cognos/prompt_selected.PNG)
Thanks and Regards,
Stancho
That is usually seen when there is an unresolved, required parameter that has not been assigned a value.
With SP's, you don't need a filter in the query because the parameter from the prompt is passed into the SP and the SP returns the filtered data set on it's own, whereas if you were using tables then the parameters would NEED to be made a part of the WHERE clause of the query (by way of using filters) so the table returns the appropriately filtered data set