SAP Knowledge Base Article - Public

2246446 - Page footer cannot be suppressed by formula in CR

Symptom

If Suppress is set to true by formula in Crystal Reports, the content is hidden but an empty spaceholder remains in the report.

Environment

  • Crystal Reports 2008
  • Crystal Reports 2011
  • Crystal Reports 2013

Reproducing the Issue

  1. Create report with multiple pages
  2. Insert some items to the page footer
  3. In section expert, set true in formula for Suppress
    Formula.png
  4. Preview the report
  5. Observe that the contents are invisible however a placeholder or margin remains at the bottom of the footer
    PageFooter.png

Cause

This is the normal behaviour of Crystal Reports. The placeholder is kept for stability reasons.

Resolution

  • If you would like to suppress the Page Footer use the Suppress checkbox in Section Expert
  • Use the Page Footer if you would like to show something at the end of each page, and the Report Footer if you would like to show something only at the bottom of the last page

Keywords

CR Crystal Reports suppress formula margin empty placeholder , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

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