drillthrough shows only first dataset

[Namh]

Hi,

I'm using a drillthrough-function in a report. In a prompt page I have a multiple search prompt to filter the data. when I run now my report and use the drillthrough funktion, I get the refered report but only with the first dataset.

for example:
I choose 3 accountnumbers in my prompt search...
report is running fine with all 3 numbers...
but when I use the drillthrough I get a new report with the first accountnumber only.

any halp would be appriciated.

thank you,

Namh

 

[misscognos]

i'm not very clear on your question.. please explain in a little more detail if the following doesn't answer it:

in a single value that is passed from the target report to the source report, there can only be one value...

so, if you have in your source report a filter that looks like this:
[query item] in (?a?)

you can only pass one value into parameter a.
you cannot pass a list of values in one parameter..
so if you would like to pass ('something', 'something2', 'something3') only something 1 will get passed to the source report.

on the other hand, you can pass multiple prompt parameters in a drill through. notice the difference..

what i'm saying you can do is pass many values in a single parameter. but you can pass many parameters.