I have imported the stored procedure in Framework Manager as a query subject and added a prompt in the values column so the input parameters of the SP are linked to this prompt.
In report studio I can run this stored procedure and the default prompts show up.
I want however a user-friendly prompt page where the user can make the selection from a drop-down list.
How can I achieve this.
Hi,
If I correctly understand, when you run the report with this stored procedure, you only see the "default" prompt object that Cognos creates automatically (because you asked him for a parameter/prompt in the FWM).
So, just try create a prompt page, put a Value-Prompt on it and in the message-box concerning the parameter, choose to use an existing parameter -> normally, you'll see in the list your parameter that you defined in Framework manager for the procedure.
Hope it will help...
@+
vinc.