Drillthrough (Jump to Report) Navigation


This type of action is usually employed when there is a need to design master (parent) and detail (child) reports . An action, which takes users to a detail report, is created on the master report.

To create a Drillthrough navigation (action) you need to set Jump to report expression on either the Action dialog box or on the Navigation tab of the item's Properties dialog box. The Jump to report expression needs to evaluate to a name of a report.

You can also specify parameters to pass to a report by clicking the Parameters button next to the Jump to report expression. The Parameters dialog box allows you to enter a constant name of a parameter and an expression that will assign a value to the parameter.

The following is an example of RDL for the Drillthrough action:

 <Action>   <Drillthrough>    <ReportName>Product Detail</ReportName>    <Parameters>     <Parameter Name= "ProductNumber ">      <Value>=Fields!Name.Value</Value>     </Parameter>    </Parameters>   </Drillthrough>  </Action> 

Note

The Back to Parent Report button on the Report Viewer's toolbar provides a convenient way to navigate back to a parent report. This button is especially handy in Preview mode.


An example of a Drillthrough is included as a sample for this book and consists of master (Actions -- Drillthrough.PlusInteractiveSort -- Sales Order.rdl) and detail (Actions -- Hyperlink -- Product Detail.rdl) reports.



Microsoft SQL Server 2005 Reporting Services
Microsoft SQL Server 2005 Reporting Services
ISBN: 0672327996
EAN: 2147483647
Year: 2004
Pages: 254

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net