Symptom
- How can a drill-down page be customized according to the current level in Crystal Reports?
- How to suppress fields depending on the Drill-Down level we are in Crystal Reports?
- For example, a report contains one or more groups. Each group can be drilled down for more detail. How can you apply conditional formatting to the drill-down page based on the current level?
Environment
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- SAP Crystal Reports 2020
Resolution
- To apply conditional formatting to the drill-down page, use the function: DrillDownGroupLevel
- The DrillDownGroupLevel function evaluates the level that is currently viewed.
For example:
On a report with multiple groups. When viewing a report in Preview mode, the function: DrillDownGroupLevel, returns the value: 0
When you drill-down on the first group, the function returns the value: 1
When you drill-down on the second group level, the function returns the value: 2
- Based on the values returned by the DrillDownGroupLevel function, create a formula to conditionally format the drill-down page or level.
For example: If we have a report with the Group Header #1 conditionally suppressed if the current view is the first drill-down level.
- Create a conditional suppression formula for the Group Header #1 like:
//This conditional suppression formula formats the section by
//suppressing Group Header 1 when the current view is the first drill-down level.
DrillDownGroupLevel = 1
- When viewing the report and drilling down on the first group level, the Group Header will be suppressed.
- For more information on the funcion: DrillDownGroupLevel, and conditional formatting, refer to the Crystal Reports Online Help by pressing the F1 key.
Keywords
DRILL-DOWN DRILL DOWN CONDITIONAL FORMULA CUSTOMIZE EACH GROUP LEVEL PAGES Crystal Reports How to use DrillDownGroupLevel function Conditionally format group level Formula function , c2011373 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
Product
SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020