SAP Knowledge Base Article - Public

1378202 - How to Dynamically generate page footers in Crystal Reports designer

Symptom

Unable to generate page footers dynamically

Cause

Because of design limitations, Crystal Reports does not allow to create the page footers dynamically

Resolution

 The following steps will not create the page footers dynamically but they will override as page footers are already created. For e.g. if you want to create 10 page footers refer the following steps:

  1. Create required number of page footers say 10.
  2. Create a parameter (static), which accepts the number of page footers you want
  3. Create a formula as follows:
  • Create a formula with a Boolean array with the size equal to number of page footer
  • Initialize the array with all false
  • Accept the parameter with number as an input
  • Add 'FOR' loop starting from the parameter value till the end of array
  • In the 'FOR' loop set the current index of array to true
  • Go to each section expert and in suppress condition declare the array and suppress  the footer only if the index of array corresponding to page footer is true
  • Repeat the 4th step for number of page footers you want

    5)  Run the report with the parameter.

 

Keywords

Page footers,CR 2008,CR XI R2,Dynamically generate page footers,Page footer on demand , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

Crystal Reports 2008 V1