ActiveReports 14
ActiveReports 14 User Guide / Samples and Walkthroughs / Walkthroughs / Page Report/RDL Report Walkthroughs / Preview / Drilldown Reports
In This Topic
    Drilldown Reports
    In This Topic

    This walkthrough expands upon the report created in the Master Detail Reports walkthrough. If you have not created the Master Detail report (CustomerOrders.rdlx) already, please do so before continuing.

    This walkthrough illustrates how to create a drilldown report using the Hidden and ToggleItem properties.

    The walkthrough is split up into the following activities:

    Note: This walkthrough uses the Customer table from the Reels database. The Reels.mdb file can be downloaded from GitHub: ..\Samples14\Data\Reels.mdb.

    When you complete this walkthrough you get a layout that looks similar to the following at run time.

    Design-Time Layout

    Run-Time Layout

    To open the report in Visual Studio

    1. Open the Master Detail Report project in Visual Studio.
    2. In the Visual Studio Solution Explorer, double-click CustomerOrders.rdlx.

    To hide table rows and set a toggle item

    1. In the designer, click inside the table to display the column and row handles along the top and left sides of the table.
    2. Select the second group header row containing the static labels (Title, QuantityPrice and Total) by clicking the row handle to the left of it.
    3. Hold the CTRL key and select the Detail row containing field expressions to add to the selection.
    4. In the Properties window, expand the Visibility property and set its properties as follows.
      Property Name Property Value
      Visibility Hidden True
      Visibility Toggle Item TextBox10 (the textbox containing the expression =First(Fields!LastName.Value))

    To view the report

    • Click the preview tab to view the report at design time.
    1. Click the Preview tab of the report designer.
    2. Click the + icon next to a customer to display order details for that customer.
    3. Click the - icon to hide the details.

    OR