drill through from page 1 to page 2 in the same report

[Chowdary2009]

Hello Every one,

I want to know one thing in report studio. is it possible to give drill thru connection with in a report.

Ex:  I have two report pages, Page1 and page2. in Page1 i have Source Crosstab report and Page2 i have list report. Now i need to give Drill thru connection between Page1 and Page2. Whether it is possible, if possible means could you please tell me the Detailed Steps.


Thanks in Advance.

With Regrads,
Aravind kellampalli

[AMARMS]

Yes, this is possible.  You can create a boolean variable for each page, to hide or show based upon your selected parameters.  Be sure to set it up so that if the parameters for the second page are used that the first page is not shown.  Then create a "dummy" data item in the query for page one that will represent the drill through parameter that keys page two to be visible.  Set this data item's expression as a value that would not likely be used, such as a negative number.  Then in the second page's query, modify the filter of that parameter to include that value for the prompt.

Example: 
dummy data item's expression = -2 in page one's query
filter for page 2 query: [DATA ITEM A] in (?Prompt A?) or ?Prompt A? = -2

In your drill through be sure to set the parameter this data item will activate to pass the data item itself.  This way when you drill through, even though you are not selecting a parameter that would activate the second  page, the -2 value activates the prompt that will make the second report page visible.  Also be sure to set the properties for the data of the cell you are drilling through to be not only the data it represents, but the dummy data as well.

This should work for regular fact cells within the crosstab, however, if you need to drill through from a summary cell within the crosstab, you have to use the "dummy" data item in place of the actual summary.  You can just change the looks and text of the row to look like a summary row, and it should still return the same data so long as you define the contents of the fact cells.

Hope this helps.

[bi4u2]

I struggled a long time until I figured this concept out so I wanted to lay out the exact steps I followed. Hope this helps someone!

Create a 2 page report with a prompt page.
Page 1 - 'Report Page' - associated with 'qReport'
Page 2 - 'Drill Page' - associated with 'qDrill'
Create a Static Choice Value Prompt, insert it into a block and set the block to visible=No (create a required prompt but hide the prompt). The parameter name should be pSelfDrill. The 2 static values are Y (display 'DrillMode') and N (display 'ReportMode'). Make the default value of the prompt 'N'. So when we initially run the report, we are telling the report to render the report page.

Create 2 Boolean Variables:
vReportingMode (Report Expression = ParamValue('pSelfDrill')='N') - Add as a Render Variable to 'Report Page'
vDrillMode (Report Expression = ParamValue('pSelfDrill')='Y') - Add as a Render Variable to 'Drill Page'
Add a dummy query item to 'Report Query', called it 'RptDrillMode' and set the expression to 'Y'.
You do not need to add this item to the face of the report.
On the 'Report Page' create your Drill Through Definition. One of the required parameters to satisfy will be 'pSelfDrill', set this to pass the Data Item Value of 'RptDrillMode'.