OpenDocument sending multiple values from a column on report

[pelajhia]

Hi, we have set up links in reports to send one value from a row to a report as a parameter value (aka 'drill across'). We have also links where the values users entered for the first report parameters are sent to the second report as parameter values.

We now have a request to set up a link which sends all the values from 1 column on the report as parameter values for another report - Is this possible at all? even outside of opendoc I would be interested in any ideas. Thanks!!

 

[pelajhia]

Just found this on SAP site, going to give it a try...

"I think the key is instead of having IDs listed individually on each row of the column, each row of the column needs to contain the IDs with semi-colons between in the main report. "

 

[pelajhia]

this won't work for a large number of values, so we are going to pass the parameter values to a subquery in the second report, which will output a list of nbrs to feed into the main query of the second report.