Append parameter values to ReportNet url

[thanask]

Hi

http://localhost/crn/cgi-bin/cognos.cgi?b_action=xts.run

&m=portal/report-viewer.xts
&method=execute
&m_obj=/content/package[@name='URL']/report[@name='City']
&outputFormat=HTML
&outputLocale=en-us
&prompt=true
&m_name=City

If I paste the above url in the address bar of internet explorer, the prompt page appears and when i provide the prompt the report runs..

Is there any thing like '&prompt_value=tokyo' that when added to the above url (as a parameter to the cognos.cgi) runs the report directly for the parameter value 'tokyo'..

or simply how to append parameter values to the report url dynamically..

Thanks
Kumar

 

[devcog]

Hi Kumar,

Please try the following:

http://localhost/crn/cgi-bin/cognos...wer.xts&method=execute&m_obj=/content/package

[@name='<published_pkg_name>']/report[@name='<report_name>']&<prompt_name>=<prompt_value>&backURL=/content/package[@name='<package_name']

It worked for me...
Anonymous access is enabled...fyi

Regards,

 

[thanask]

Hi

I changed the url accordingly and ran the report and it is asking for prompt value. Do I need to change any run options for the report.

Here is the url

http://localhost/crn/cgi-bin/cognos...wer.xts&method=execute&m_obj=/content/package

[@name='URL']/report[@name='City']&Cty=4

Prompt name I used in the filter of the tabular model is 'Cty'..

Please correct me, if I the above url is wrong..

Thanks and Regards
Kumar

 

[Pallina]

Hi Kumar,

you need to add 'p_' in front of your parameter name, so in your case try &p_Cty=4

Regards,
Anna

 

[msnaidu]

hi
can anyone tell me how to set Numeric parameter values in URL??
my URL is like this:

http://localhost/crn/cgi-bin/cognos...wer.xts&method=execute&m_obj=/content/package

[@name="pkgName"]/report[@name="ReportName"]&p_From_D=200301&p_TO_D=200407&p_Client_Level=1&p_Region_Bkey=EMEA

Here Client_Level is Numeric

Regards
Meera