logo
small logo
  • Products
  • Buy
  • Support
  • Articles
  • Customer panel Support
    • en
    • pt
    • es
    • de
    • pl
    • JP
    • ZH
  • Home
  • /
  • Articles
  • /
  • How to make a report like Drill-Down
  • How to use WebReport with ASP .NET Web Core application

    January 17, 2018

    Recently FastReport introduced a new library under the .NET - FastReport Core platform. This is

    read more
  • How to make report inheritance in FastReport.NET

    January 29, 2021

    When you are tasked with creating a large number of reports within one corporate style,

    read more
  • FastCube - High-Speed OLAP Cube Engine and Pivot Grid

    February 29, 2020

    It is difficult to imagine data analysis without OLAP (On-Line Analytical Processing) technology. Although there

    read more
  • How to programmatically set the default email client settings for sending emails from FastReport.NET

    February 12, 2021

    Like many other report generators, FastReport .NET allows you to send a report via email

    read more
  • Creating and outputting ITF-14 barcodes in .NET applications

    February 25, 2021

    ITF-14 (Interleaved Two of Five) is a two-band numeric code, otherwise known as a high-density

    read more

How to make a report like Drill-Down

September 4, 2019

Reports with grouping are necessary for data analysis. But when there are a lot of data and there is no need to display them all, a regular report with grouping becomes cumbersome and redundant. You want to find a universal solution for such cases. And there is one.

A report with a drop-down list is essentially a report with grouping data, but with the ability to hide or display data in a group by mouse click. It is not only very convenient, but also beautiful. After all, the report becomes an interactive object. The user is pleased when he can participate in the display of information.

Consider an example of how to make such a report. First of all, as in the Master-Detail report, we need a data source with linked tables. Suppose we have two tables: customer and orders.

 

One customer can do many orders - one-to-many relationship. Let's add it. Click the Actions button and select New Relation from the drop-down list ...

 

Parent table is main one, then choose ‘custome’r. Child table is respectively ‘orders’. In ‘customer’ there is a primary key CustNo. Choose it among the columns. In ‘orders’ there is a foreign key CustNo. Also choose it.

As a result, we get the connection:

 

Now let's start creating the report template. Add a band "group header". On it we will place the fields from the link: “orders.customer.Company”, “orders.customer.Addr1”, “orders.customer.Phone”, “orders.customer.Contact”.

In addition to these fields, let's add a checkbox control to this band. In its CheckedSymbol property, select Plus, and in UncheckedSymbol - Minus.

Add the fields from the ‘orders’ table: OrderNo, SaleDate, PaymentMethod, AmountPaid to the “Data” band. Also, add a header band for the data and field headers:

 

Double-click on the group title “Headline”. Select the field to group:

 

Now select the checkbox that we added earlier. Give it a Hyperlink property:

Select the "Group Header" band and create a BeforePrint event handler for it:

     

1
2
3
4
5
6
7
8
9
10
11
 private void GroupHeader1_BeforePrint(object sender, EventArgs e)
 {
 string groupName = (String)Report.GetColumnValue("orders.customer.Company");
 // get the group name
 bool groupVisible = expandedGroups.Contains(groupName);
 // Check group visibility
 DataHeader1.Visible = groupVisible;
 Data1.Visible = groupVisible;// Set the visibility of data in accordance with the visibility of the group
 GroupFooter1.Visible = groupVisible;// Set the visibility of the basement of the group in accordance with the visibility of the group
 CheckBox1.Checked = !groupVisible;// Set the state of the flag depending on the visibility of the group
 }

 Also add to the class a list of expanded groups:

1
private List<string> expandedGroups = new List<string>();

 Let's return to our checkbox. For it, create a Click event handler:

1
2
3
4
5
6
7
8
9
private void CheckBox1_Click(object sender, EventArgs e)
{
string groupName = (sender as CheckBoxObject).Hyperlink.Value; // We get the name of the group from the hyperlink
if (expandedGroups.Contains(groupName)) // If the list of visible groups contains the selected group
expandedGroups.Remove(groupName); // Then remove the selected from the list of visible groups.
else
expandedGroups.Add(groupName); // Otherwise add the group to the list of visible
Report.Refresh(); // Update Report
}

 Run the report in preview mode:

Now click on any plus sign:

When you click on the minus sign group collapses. Agree, this is very convenient.

about product download buy
avatar
Dmitriy Fedyashov
Technical Writer
Fast Reports Team: Dmitriy Fedyashov - Technical Writer at Fast Reports
.NET FastReport

Add comment
logo
  • 800-985-8986 (English, US)
  • +4930568373928 (German)
  • +55 19 98147-8148 (Portuguese)
  • info@fast-report.com
  • 901 N Pitt Str #325 Alexandria VA 22314
  • Buy
  • Download
  • Documentation
  • Testimonials
  • How to uninstall
  • Ticket system
  • FAQ
  • Tutorial Video
  • Forum
  • Articles
  • Our News
  • Press about us
  • Resellers
  • Extended licensing
  • Contact us

© 1998-2022 by Fast Reports Inc.

  • Privacy Policy