Special Field- Record Number count incorrect

[Former Member]

Hi,

Looks like the record number special field is displaying the record count incorrectly. There are no records returned by the query nor there are any records in the detail section of the report. But the record number in the report footer shows 1. Is there any way to fix this?

Thanks in advance,

Sirisha

[Former Member · Accepted solution]

One way to "fix" it would be to do a count on a field in the details section and then compare that count to NULL or zero and if so then display zero otherwise display the recordnumber.

1. Create a running total on a field in the details section that doesnt reset.

2. Create a formula with:

if isnull({#RTotal0}) or {#RTotal0} = 0 then 0 else recordnumber

3. Display the formula instead of the recordnumber in the report footer.

[Former Member · Accepted solution]

Thanks a lot!! It worked