New to Telerik Reporting? Download free 30-day trial

How to Add a Drillthrough/Navigate To Report Action

A report can contain links to other reports. The report that opens when you click the link in the main report is known as a drillthrough report. Drillthrough reports must be published to the same report server as the main report, but they can be in different folders. You can add a drillthrough link to any item that has an Action property.

We recommend the usage of TypeReportSource ('Type name' option) or UriReportSource ('Url or file' option) in the Load Report Dialog on configuring the target report. InstanceReportSource ('Object instance' option) is only supported for WinForms and WPF Report Viewers in Embedded mode.

Adding a drillthrough action using the Report Designer

  1. In Design view, right-click a report item to which you want to add a link and then click Properties.

  2. In the item's Properties dialog box, click Action.

  3. Select Navigate to Report. Additional section appears which allows you to select a ReportSource.

  4. In the Choose a Report Source dialog, select how you would navigate to the report, For this example we would use Type Report Source , click that option and select the report that you would like to navigate to. If you have to specify parameters for the drillthrough report, follow the next step.

  5. Click Edit Parameters button - Edit Parameters dialog appears. Click New. In the Parameter Name column select the name of the report parameter in the drillthrough report. In the Parameter Value , type or select the value to pass to the parameter in the drillthrough report.

  6. To test the link, run the report and click the report item with the applied Action. For TextBoxes, it is helpful to change the color and effect of the text to indicate that the text is a link. For example, change the color to blue and the effect to underline by setting the corresponding Font properties of the TextBox.

Adding a drillthrough action programatically

    Telerik.Reporting.TypeReportSource reportSource = new Telerik.Reporting.TypeReportSource();
    reportSource.TypeName = "ReportLibrary1.Report1, ReportLibrary1, Version=, Culture=neutral, PublicKeyToken=null";
    reportSource.Parameters.Add(new Telerik.Reporting.Parameter("OrderNumber", "SO43659"));

    Telerik.Reporting.NavigateToReportAction reportAction1 = new Telerik.Reporting.NavigateToReportAction();
    reportAction1.ReportSource = reportSource;
    textBox1.Action = reportAction1;

{{source=CodeSnippets\VB\API\Telerik\Reporting\ActionSnippets.vb region=AddNewNavigateToReportSnippet}}

    Dim reportSource As New Telerik.Reporting.TypeReportSource()
    reportSource.TypeName = "ReportLibrary1.Report1, ReportLibrary1, Version=, Culture=neutral, PublicKeyToken=null"
    reportSource.Parameters.Add(New Telerik.Reporting.Parameter("OrderNumber", "SO43659"))

    Dim reportAction1 As New Telerik.Reporting.NavigateToReportAction()
    reportAction1.ReportSource = reportSource
    textBox1.Action = reportAction1

See Also

In this article