Crystalkeen logo; we offer Crystal reports viewers and schedulers
Crystalkeen header image 3
Crystalkeen header image 5

Crystal Reports Tools: Improve Performance While Saving Time and Money




CR Schedulers
CR Viewers
DataBase Tools
Mail UFLs


About us

Contact Us

on Steroids

Crystal Reports: Drill Down Reports at One Level

Drill Down Reports are among the powerful features available in Crystal Reports. If you have a simple report with one group, one series of subtotals, and some detail information, you can change it into a drill down report by setting "Hide" on Group Header 1 and the detail section.

One thing that makes the drill down work better is to put the Group Name, or some other suitable caption into the group footer. That caption and the subtotals are what appear at the top level. When you drill down with a double click you get the Group Header, Details and Group Footer.

Drill down reports can be viewed and printed at the summary level, or a specific drill down, or any combination of these. They are a useful analysis tools for users at all levels.

Now, here's a twist.

A Chelseatech client wanted a report developed that had three groups (product group, product and customer) with a drill down to the lower level groups. The challenge was that the lowest level actually combined two fields: region and customer. They didnít want a drill down or summary by region, but at the customer level they wanted customers sorted by region and then customer.

So we used a formula to combine the two fields (Region + Customer) and grouped by that. We customized to group name to display the customer name and placed the region field in the group 3 header.

We then set the conditional suppress on the Group 3 header to

DrillDownGroupLevel <>2 and {Table.Region} = Previous({Table.region})

The top two levels displayed as expected. When the third drill down processed, we got the header section with the region description to appear. This was exactly what the customer wanted.


This article is copyright 1999 - 2005 Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.


Except where an author's name is given at the start of the article, all of these articles were written by Mo Naughton or Bruce Ferguson and edited by Mark Lamendola. Mo is a Crystal Reports consultant, trainer, and developer for Chelsea Technologies, Inc. Bruce Ferguson is a Crystal Reports consultant, trainer, and developer for CrystalKiwi, Inc. Mark Lamendola is a writer and editor with over 15 years experience in professional and trade publications.




  • Questions? Please write to We do want your business.
  • Do you have your own tips for Crystal Reports administrators and designers? Write to and we'll post your tips with a link to your Website (or with some other attribution if you choose).
  • Crystal Reports is a subsidiary of Business Objects, which is owned by SAP.