I have a report that allows the user to select multiple values from multiple prompts and displays high level information. I would like to have that report drill through into a detail oriented report that allows the user to see all the detail behind the high level totals of the first report. I was told that I can not create such a drill through because my prompts (parameters) in the first report are set to "IN", which allows users to select multiple values at a time (for instance they can select multiple Customers), and the drill through capability only allows one item to pass at a time (i.e. only one Customer).
Is there a way to pass multiple values at once from one report to another using a drill through?
Any help is much appreciated.
Thanks,
G
Pass Query Item values instead of Parameter values to the detail report via the drill-through.