SAP Knowledge Base Article - Public

1297657 - Manual running of total issue, when the option "Repeat group header on each page" is set to true.

Symptom

How to manually run total issue, when the option "Repeat group header on each page" is set to true.

Reproducing the Issue

  1.  Create a Crystal Report .
  2. Initialize a Variable in Group Header check the option "repeat group header on each page"
    Formula:
  3.   WhilePrintingRecords;
      Global stringVar a;
       a:="" 
    Evaluate Variable to append the database values:(Detail Section)
        WhilePrintingRecords;
        Global stringVar a;
      If InStr (a, right({ZFIGL_C10_ZFIGL_C10_Q001_DW1100_GL_PC_AB.
    [ZPRFT_CTR]-Group Header[2ZPRFT_CTR]},13))=0 then
        a:=a+trim(right({ZFIGL_C10_ZFIGL_C10_Q001_DW1100_GL_PC_AB.[ZPRFT_CTR]-[2ZPRFT_CTR]},13)) + space(3) .
  4. Display formula of the variable in Group Footer.
        WhilePrintingRecords;
        Global stringVar a;
         a

Resolution

1) Insert a fake group by creating a formula @fakegroup:
Formula:
whilereadingrecords;
true
2) Insert a group on @fakegroup formula.
3) In Report Menu > Group expert > move the "fakegroup" between group header 1 and group header 2 and place all the objects in the fake group header.
4) In fake group option select  the option "Repeat group header for each page".

Keywords

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

Product

SAP Crystal Reports XI R2