If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

list of values+stored procedures

Started by vkishore760, 12 Aug 2009 05:18:49 AM

Previous topic - Next topic

vkishore760

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.

Sunchaser

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.