| |
GeekInterview.com > Interview Questions > Data Warehousing > Cognos
| Print | |
Question: How to pass multiple values from picklist prompt to sub report filter
Answer: The sub-report only includes the first value.
"When the sub-report query runs, it checks for the first row in the Customer Name column and shows only information for that customer. If you want a sub-report to show information for another row in the column, place the main report in a form frame that shows only one row at a time. When you insert the sub-report into the form frame as well, it changes as you click through the rows in the main report. For example, the main and sub-report above are both in a form frame that shows only one row of the Customer Name column at a time. Each time you scroll to another customer name, the sub-report shows only information for that customer." |
| September 09, 2007 13:11:55 |
#1 |
| Nadim |
Member Since: Visitor Total Comments: N/A |
RE: How to pass multiple values from picklist prompt t...
|
| By using the 'IN' operator in creation of a prompt we can create a sub report. When the prompt executes, you can select multiple values and the results from the sub-report will reflect those selected items. |
| |
Back To Question | |
