I am using this 3 way formula below to get record/s from details section and display in group footer for each group in a report. It is working pretty well BUT NOT WITH A GROUP REPORT CONTAINING OR EXTENDING WITH more than 1 page.
Formula 1: In Group Header (Initialise)
Whileprintingrecords;
stringvar strtitle := "";
Formula 2: In details Section, (create a condition)
Whileprintingrecords;
stringvar strtitle;
numbervar var;
if ({@CurrentMonthNew}) = "CLOSED" and ({@PreviousMonthNew}) <> "CLOSED"
THEN
strtitle := strtitle + ChrW(13) + cstr((var := var+1;),0) + ". " + {spMSR;1.name} + " ceased its operation on " + cstr({@LastDate})
else if ({@CurrentMonthNew}) <> "CLOSED" and ({@PreviousMonthNew}) = "Not yet operational"
THEN
strtitle := strtitle + ChrW(13) + cstr((var := var+1;),0) + ". " + {spMSR;1.name} + " started its operation on " + cstr({@FirstDate})
Formula 3: In Group Footer, display the final output
whileprintingrecords;
stringvar strtitle;
Why is not working with a two or more page report and how to solve this problem? Any help will be highly appreciated.
UPDATED:
I have tried to uncheck the "Repeart Group Report on Each Page" and it worked, but the group header was lost. How can we have both?
Modify formula in your group header:
Whileprintingrecords;
If Not InRepeatedGroupHeader Then stringvar strtitle := "";