Page Footer – Wrong Data Sometimes 1

[Bennie47250]

Using Crystal Version 7.0
Access Database

We have several sales regions and in each we have several sales territories.

One of the sales reports is sales for all territories, when it runs, it is a little over 400 pages. Each territory report is ether 2 to 3 pages in length.

In the page footer we are printing the region number. When the last territory of a region prints, on the last page, the incorrect region is printing, all other pages are correct.

For example in Region 1 the last territory is 280, on page 1 and 2 the correct region is printing, but on the 3rd and last page, it is printing region 2. Then it prints correctly until the change of the region again.

The report is grouping by the territory and I have turned off the “ Keep Group Together” option as we were experiencing issues with values doubling up.

Any suggestions on how to keep the incorrect region number from printing?

Thanks
Bennie

 

[lbass]

Do you have new page after set on the territory group footer?

You are using a very old version of CR. I couldn't recreate this issue in XI. I wonder this might be an issue fixed in a service pack or something.

You could try using a variable for the page footer (if they allow variables in v.7:

//{@accum} to be placed in the detail section:
whileprintingrecords;
numbervar regno := {table.region};

Add a reset in the page header:

whileprintingrecords;
numbervar regno := 0;

Then in the page footer use:
whileprintingrecords;
numbervar regno;

-LB

 

[Bennie47250]

I did not have new page after select for my group footer. Added this and it corrected the issue.

Thanks