My main report has a prompt which accepts multiple values. The prompt values appear correctly on the main report header. However I would like these values to appear on the drill thru report header as well. I tried to display the prompt value as a report expression in the drill thru report but when I drill thru the main report, only the first value chosen is displayed. How do I achieve this?
Thank you!
Quote from: cognos2014 on 12 Feb 2016 10:54:54 AM
My main report has a prompt which accepts multiple values. The prompt values appear correctly on the main report header. However I would like these values to appear on the drill thru report header as well. I tried to display the prompt value as a report expression in the drill thru report but when I drill thru the main report, only the first value chosen is displayed. How do I achieve this?
Thank you!
Hi,
Assuming you are not selecting just one of these values to drill through on (ie you are drilling through on a different data item), you can pass the original parameter to your target report. In the drill-through definition of your source report, use "Pass parameter value" as the method, and choose the parameter as the Value. In the target report, you will need a prompt filter that accepts multiple values in the parameter, and you will need to use a Layout Calculation to display the parameter in the page header.
Cheers!
MF.
Hi MF,
Sorry for the late response! My report does exactly what you had suggested but the drill thru displays only one of the multiple values chosen on the prompt page in the main report. That's why not sure what I am doing wrong.
Try to run your target report individually. Are you able to make a multi-select choice? Does it display well?
The drill thru report works fine when I run it by itself along with the multiple choices. As a workaround, I have used the promptcount() function to get the count of values selected and display 'Multiple Choices Selected' when multiple values are selected in the main report. Not ideal but works for now.