How to pass multiple values of a Parameter through URL to another report?

[anirudha]

Hello,

I want to pass multiple values of a Parameter through URL to a differenet report.
Does anybody know how to do this?

Thanks in advance,
Anirudha.

[MFGF]

Hi,

This is fully documented in the Cognos 8 Administration and Security Guide - Appendix H: Performing Tasks in Cognos 8 Using URLs.

Regards,

MF.

[anirudha]

MF,

I have already gone through that documentation. The thing is I get prompt values from a Multi-select prompt to filter that report. On report I have a HTML item which contains URL for a different report. Because of report stucure I can not set up a standard drill though on it. I need to pass 'Multiselect' prompt values through the URL itself. Right now I am just pass one of the multiple values of that parameter.

For example:

<a href="<Report Path>&p_Comany='||(?CompanyNum?)||'&p_Zip='||(?ZipCode?)||'&run.prompt=false&backURL=%2fCognos8%2fcgi-bin%2fcognos.cgi%3fb_action%3dxts.run%26m%3dportal%2fcc.xts%26m_folder%3diA818EF456A15423D865205BE4132FFE0"><Target Report Title></a>


When I run report I get <Target Report Title> as a Hyperlink and when I click it runs the report whos path is given in href="".
On parent report, I select multiple company names(check box-value prompt).
With current code just reads first company name and does pass it to Target Report.

I hope the example will make some sence.

Thanks for the reply.
Anirudha.

Hi,

This is fully documented in the Cognos 8 Administration and Security Guide - Appendix H: Performing Tasks in Cognos 8 Using URLs.

Regards,

MF.

[MFGF]

Hi,

Page 370 of the guide shows an example of passing through multiple values for the Country1 parameter.  You will see from the example that each value needs to be passed through independently in the URL.  If your originating report has a parameter containing multiple values, you will need to strip these out and pass them independently.

Regards,

MF.

[anirudha]

HI,

The method given there works when I know what parameters USER is going to select. In my case user is going to select them from Value prompt, I can not hotcode the values in URL.Those values should be dynamically picked up.

Thanks,
Anirudha.

Hi,

Page 370 of the guide shows an example of passing through multiple values for the Country1 parameter.Ã,  You will see from the example that each value needs to be passed through independently in the URL.Ã,  If your originating report has a parameter containing multiple values, you will need to strip these out and pass them independently.

Regards,

MF.