How to design drilldown report in Syncfusion WPF ReportDesigner?

You can create a drilldown report using Syncfusion ReportDesigner, which allows users to show or hide the data interactively using plus and minus symbols on a textbox. The following steps help you to create the drilldown report.

1. Create a new report, add embedded datasource and dataset.
2. Draw a table report item and add the fields to table from the report data explorer by expanding Dataset (Dataset1).
3. In report design view, click the table or matrix to select it. The grouping pane displays the row and column groups of data region item. By clicking the name of a row or column group, you can hide the associated rows or columns.
4. You can change the visibility of a group through property grid or through property dialog.
5. In Hidden option, choose any one of the following options to set the visibility of selected report item.

• Select False to display the report item.
• Select True to hide the report item.
• Select <Expression> to open the Expression dialog box to create an expression that is evaluated at runtime to determine the visibility based on the dynamic values.

6. To specify ToggleItem, open drop-down box and select the name of a textbox to add the toggle.

7. Run the report, it displays the data based on the grouped rows or columns. Click the plus icon to expand the grouped data and minus icon to collapse the data.

Sample

Please download drilldown report here