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. |