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
-
- Create a Crystal report .
- Create a formula in the page header to declare a global variable.
whileprintingrecords;
booleanvar i:=false; - Create another formula in detail section which evaluates for each record
whileprintingrecords;
booleanvar i;
if (condition) then
i:=true; - 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 Business View Manager , How To
Product
Crystal Reports 2008 V0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2