RWrigley,
The information you provided is helpful. I was able to suppress the prompt page; the only trouble I'm having now is getting it to recognize the gridview field, Order_ID as containing the prompt value. If I hard-code the Order ID like p_Order_ID=165 the report will successfully run, but I'm looking for a way for it to take the Order ID associated with the selected line on the Gridview as the prompt value and create the report from that. Whenever I do something like p_Order_ID=Order_ID I get an error saying "Invalid format for numeric prompt 'Order_ID'." i.e. Its not resolving to the value of Order_ID in the gridview. Any ideas on how to make it do this?
Thanks,
taduh
Main Topics
Browse All Topics





by: RWrigleyPosted on 2009-05-01 at 16:23:14ID: 24284083
You can specify the prompt values on the URL to the report. This document describes all the fun things you can do with URL's with Cognos:
supported/ tti/public /docs/ cogn os_pp_repo rting_usin g_urls_in_ cognos_8.p df? lid=cog nos_pp_rep orting_usi ng_urls_in _cognos_8
/cgibin/ n&m=portal /launch.xt s&&ui.tool =CognosVie wer&ui.obj ect= Sales and Retailers']/folder[@name=' New oduct revenue - prompt']&ui.action=run&p_P roduct name=Bear
http://support.cognos.com/
This is from the section you're interested in:
Passing Prompt Answers
To ignore the prompt page, the parameter run.prompt must be set to false. Otherwise, the
prompt page will appear with your prompt answer as the highlighted selection.
http://server-name/Cognos8
cognos.cgi?b_action=xts.ru
/content/package[@name='GO
Reports']/report[@name='pr
Edge&run.prompt=false