Chapter 6
Drill Through From a List Report to Another List Report
Section 2
Passing Multiple Parameters in Drill-through: From a Chart to a List
Normal 0 false false false EN-IN X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-fareast-language:EN-US;} When we call another report using drill-through, we can pass more than one data item or prompt value to work as context in the target report. Let's see how to pass multiple values from a chart report to a list report. - Create a stacked chart report showing sales over countries to work as source (we will use the existing report created in video 5.1 for this) - Create a list report showing order data (for this, we will modify the existing report created in 6.1.1) - Create a drill link from the chart to the list and pass the country and product data