Restart Record Number on New Page

[eric333]

I have a report where I have included the 'Record Number' special field in the Details section of the report. The recipient has asked that the record number be reset at the start of each page. Does anyone know how to accomplish this?

 

[boardgamer]

Are you looking for the report to display the number of records on that page?

If so try this

create a formula and place in page footer

global numbervar LastRecordCount;
global numbervar PageRecordCount;

if PageNumber=1 then
(
PageRecordCount:=RecordNumber;
LastRecordCount:=PagerecordCount;
)
else
(
PageRecordCount:=RecordNumber-LastRecordCount;
LastRecordCount:=recordnumber;
);

PageRecordCount;

 

[eric333]

Thanks for the tip, but I am not looking to display the number of records on a page. I am looking to display a line number on each line of each page, and have that number reset on each new page.

 

[MCuthill]

eric333:

In the Page Header:
@VariableReset_Counter:
whileprintingrecords;
Shared NumberVar Counter:=0;

In the Details Line:
@VariableSet_Counter:
whileprintingrecords;
Shared NumberVar Counter;
Counter:=Counter+1;
Counter;

Hope this helps! Cheers!

Mike
--------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure, in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."
Author R.A. Salvatore via "Drizz't"

 

[eric333]

That worked perfectly. Thanks Mike!