Help!
I have written a standard report which has 8 columns across each row. The columns contain running totals. They are in the group footer then totaled at the bottom. When the report is run, each row of each column is correct on the first page. Once you move to the second page, each column in the first row of the second page is off. See below for example. Note that every row AFTER the first row on the second page is also correct. It’s just the initial row.
For instance:
Last row on first page:
1,880 -40 +0 1,840
First row on second page:
1,936 -40 +0 1,896
What SHOULD be in the first row of the second page:
2,544 -56 +0 2,488
Has anyone ever seen anything like this before? 
IP Logged