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

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?
  • 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 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Resolution

  • To apply conditional formatting to the drill-down page, use the DrillDownGroupLevel function in a formula.
      
  • The DrillDownGroupLevel function evaluates the level that is currently viewed.
        
    For example, when you are viewing the report in Preview mode, the drill-down level returns the value of zero (0).
    When you drill down into the first group level, the DrillDownGroupLevel function returns the value of one (1).
       
         
  • Based on the values returned by the DrillDownGroupLevel function, create a formula to conditionally format drill-down page or level.
      
    For example: If we have a report with Group Header 1 (GH1) conditionally suppressed if the current view is the first drill-down level.
      
    1. Create a conditional suppression formula for GH1 similar to the following:
        
      //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. Upon previewing the report and drilling down into the first group level, the Group Header will be suppressed. 
       
          
  • For more information on the DrillDownGroupLevel function 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 BusinessViews Manager , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016