Print Page - How to Pass Parameters to avoid the prompts in the report.

Title: How to Pass Parameters to avoid the prompts in the report.
Post by: cesquilin on 02 Jan 2008 02:21:51 PM

Hi,

I am trying to run a Cognos Report(8.3) from an external portal, but I need to pass some parameters to avoid the prompts in the report. Those parameters are dynamically. I any one of you has done this before please, give me some inputs. Thanks in advance for your help and time.

Best Regards,

cesquilin :-\

Title: Re: How to Pass Parameters to avoid the prompts in the report.
Post by: sir_jeroen on 02 Jan 2008 03:39:37 PM

Have you added the option: run.prompt=false to your url?

Source: Cognos Proven Practices -> Reporting -> Scripting techniques

http://support.cognos.com/supported/tti/public/docs/cognos_pp_reporting_using_urls_in_cognos_8.pdf?lid=cognos_pp_reporting_using_urls_in_cognos_8

Good luck,

RA

Title: Re: How to Pass Parameters to avoid the prompts in the report.
Post by: cesquilin on 08 Jan 2008 01:41:18 PM

Hi again,

Thanks for your reply; But, how I deal with the security? Meaning the call to the report is from an external application that will integrate with Cognos to serve the reports; for this reason it is important to authenticate the user before execute the reports. The user needs to be allowed to use Cognos. Also this must provide a single sign-on. To complete the requirements this userid parameter need to be assign to the #$account.defaultName# parameter to apply row level security in the FM package. Thanks in advance for any input provideâ€¦

Regards,
cesquilin

Title: Re: How to Pass Parameters to avoid the prompts in the report.
Post by: sir_jeroen on 13 Feb 2008 07:27:21 AM

You could use CAMPassword and CAMUsername as URL parameters (Look in the source page of the login page).

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: cesquilin on 02 Jan 2008 02:21:51 PM