Allow multiple items to be picked from prompt and have them show comma-seperated

[mikegreen]

Here is my end goal -
Have a list of 10 items in a prompt page, the user selects 5 and executes the report.

The user has a drill thru link to another report and will need to pass the same 5 values.

How can I pass all 5 selections? It seems I can only add a drill on a single row/group/etc at a time.  Is there a way to pass the parameter value into a query subject comma-seperated? So I can pass it back out to the drill-target report and parse it there?

Thanks!

Mike

[JoeBass]

If you create a data item that just holds the parameter values (calculation is just ?ParmName?), you can pass those to a drill through. 

As far as the comma-separated list, its been an enhancement request since at least October of 2004.

[mikegreen]

Thanks...However, I tried that, and if I do set a query item to my parameter, my prompt will only allow a single selection. I need to select multiples.

Workaround?

Thoughts?

-mike

[JoeBass]

I understand now.  I did ask Cognos directly (call 2266199 if it helps at all) about storing multiple values in a data item, or getting a delimited list which is - at the last I'm aware of - hasn't been addressed.

Would it be possible to loop through the list boxes with Javascript as the report is submitted to determine what has been selected and build these strings?

[mikegreen]

Thanks for the call ref. I might ping them and see if they have an enhancement # or if Cognos 8 addresses it.

I think my other option is to make HTML links to the other reports, and pass all the parameters via the URL... Then, parse them out comma seperated (they're all codes, so no whacky characters in them) on the next report. Fun!

Cheers,

Mike