SAP Knowledge Base Article - Public

1284169 - Conditional suppression of page footer based on records in detail section

Symptom

Conditional suppression of page footer based on records in detail section.

Reproducing the Issue

1.Create a Crystal report using a table.

2.Place a field in details Section.

3.Try to suppress the Page Footer if the number of records in Details section is 24.

Resolution

                                                                                                                                   

  1.  
    1. Create a Crystal report .
    2. Create a formula in the page header to declare a global variable.
      whileprintingrecords;
      booleanvar i:=false;
    3.  

    4. Create another formula in detail section which evaluates for each record
      whileprintingrecords;
      booleanvar i;
      if (condition) then
      i:=true;
    5.  

    6. Right click on the page footer section and in the section expert write the suppress condition as:
      whileprintingrecords;
      booleanvar i;
      not(i)

Keywords

KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2