Running total is blank

[APB1981]

Hi Guys,

My running total in a footer is blank if I select the 'New page after'. (only on the last page)

I had a formula in the running total saying 'not onlastrecord'
but even when I removed this it still did not display.

Spec:

CR 8.5
MS SQL 2000
Win XP Sp2


Any Ideas would be appreciated.



APB

 

[lbass]

If you have an evaluation that uses the "next" record, the running total would likely be blank. I think you should explain exactly how the running total is set up.

I don't see why a new page after would have any impact unless this is a manual running total using variables and you have a reset formula in a repeating group header.

-LB

 

[APB1981]

No - Its just a regular running total.

Distinct count

evaluate based on a formula:
{Table.date} < printdate

Reset on group

****

On the footer of this group i have set:
New page after.



APB

 

[lbass]

I wonder whether you have a null in there. I just set up a similar running total in 8.5, with no problem. You might check your data. Place the running total in the detail section next to the date and the field you are counting, and note whether you have any nulls.

Or you could go to file->report options and check "convert nulls to default" and see if the running total appears.

-LB

 

[APB1981]

no nulls.

Something very strange is occuring here. It works for the first group (220 pages) but skips the next group.

I have two groups:

Dept. & Manager

I have minimised the dept. header and placed both Dept. and manager titles in the second header. This may have something to do with it. I will test the same report in XI (probably just a small bug in 8.5)....

Yes it worked fine in XI - that solves that one.

Thanks Ibass for your assistance.

APB