Problem With Record Counts Using Variables

[Guest_imported]

Hi,

I have a report grouped by Employee ID. I am counting records while resetting them in each group. I got that to work.

However, when I refresh my report, the record counts become sporatic. Ex: they then number 1-3 followed by 13-15, then 31-33, 9-11, 12,37,38, etc. I am not sure why this is happening. The only way that I can correct it is be removing the formulas and re-inserting them.

My formulas are straight forward:

Group header:
WhileReadingRecords;
local NumberVar RecordCount :=0;

Detail Section:
WhileReadingRecords;
NumberVar RecordCount;
RecordCount := RecordCount+1

I am using version 7 if that has a bearing on anything.

Thanks

 

[Naith]

See thread767-296859

 

[Ngolem]

Change WhileReadingRecords to WhilePrintingRecords Jim Broadbent

 

[synapsevampire]

Remove the local.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com