SAP Knowledge Base Article - Public

1214637 - How to customize what to display when drilling-down in Crystal Reports?

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.
      
    1. 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
         
    2. 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