logo
small logo
  • Products
  • Buy
  • Support
  • Articles
  • Customer panel Support
    • en
    • pt
    • es
    • de
    • pl
    • JP
    • ZH
  • Home
  • /
  • Articles
  • /
  • Make Drill-Down report in FastReport VCL (Delphi/Lazarus)
  • How to create a ZPL file in Delphi / C ++ Builder / Lazarus

    December 22, 2020

    What is a ZPL file? ZPL stands for Zebra Programming Language. It allows team to create

    read more
  • Web reports in Lazarus on Linux

    December 15, 2020

    Until recently, the task of generating reports through the Web from an application written in

    read more
  • Turn database data into a document in Delphi / Lazarus / C++ Builder

    February 3, 2021

    How to make a mush of data into an informative report? Oracle DB, MySQL, Microsoft SQL

    read more
  • Installing FastReport in Lazarus

    March 17, 2021

    As part of the Academic's educational programme, we have decided to produce some support articles

    read more
  • Working with graphs and charts in FastReport VCL

    March 22, 2021

    We continue to publish support articles for students as part of the Academy's educational programme.

    read more

Make Drill-Down report in FastReport VCL (Delphi/Lazarus)

February 9, 2021

"Drill Down" or "deepening into data" is a concept with many sides, which can refer to actions in tables or in something else that encapsulates information. And plain and simple, it's a drop-down list!

One of the most important operations is Drill-Down, for example, in OLAP with cubes, and, in principle, many places. After all, it greatly simplifies the analysis of information. A "careful dive" into the layers of data. Let's "take a closer look at the data"! This is normally done by clicking on the data we want to drill down into.

You can do a drop-down list in FastReport VCL and this is the feature we will talk about in this article.

About Drill-down properties in FastReport VCL and its connection:

The group header itself has a DrillDown property ("DrillDown" item on the menu). When DrillDown is enabled, it will be possible to make the group interactive.

In simple terms, the group will begin to respond to a mouse click in the preview window. Clicking on a header will allow you to expand (show all content) or collapse (hide content), leaving only the header and, if desired, the basement or childband. This can be configured with the ShowFooterIfDrillDown and ShowChildIfDrillDown properties.

FastReport VCL

The screenshot below shows an example of a group with a single expanded header:

FastReport VCL

You can specify whether all groups should be output collapsed or expanded when the report is run. By default the groups are collapsed and this is controlled by the ExpandDrillDown property. If groups are to be expanded, set this property to True.

The preview also has the function to open and close group information from the context menu.

FastReport VCL

It should be noted that when using the DrillDown mechanism, the report is rebuilt each time. If the report is based on the data of a 'heavy' query, such a query will be run each time DrillDown is triggered. In this case, it is desirable to save the results of query execution in a temporary table. Also, generated reports that are saved in fp3 format and subsequently loaded in the preview window or in the FR Viewer will not work.

In the code, the TfrxGroupHeader properties for creating drill-down reports are set as follows:

DrillDown
1
2
3
4
5
6
var gh: TfrxGroupHeader;
 gh := TfrxGroupHeader(frxReport1.FindObject(‘GroupHeader1’));
 gh.DrillDown := True;
 gh.ExpandDrillDown := True;
 gh.ShowChildIfDrillDown := False;
 gh.ShowFooterIfDrillDown := True; 

I find reports that use the DrillDown type and its properties useful and easy to use. And I'm not the only one! Any office worker will be grateful to you for this dilution of their hopeless life with such interaction! The only thing is, don't quit and try to "stomp" into a report with multi-levels! This is expected to weigh down both the document and the workload. 

about product download buy
avatar
Michael Philippenko
VP
Fast Reports Team: Michae Philippenko - VP at Fast Reports
VCL Lazarus FastReport 6 Delphi

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