While ... Do

[Roni1]

Does anybody have an example on how to use the "While ... Do" operator?

I have a count of 100, and for each record I need to capture it in a variable, and then move to the next record and capture it to another variable, and keep on doing that until I get to the record number 100.

 

[lupins46]

I don't understand what you are trying to do, but Do While works within a record not across records.

You can use the RecordNumber special field to test which record you are on and you can use an array to collect multiple values together.

 

[OLTU]

try to create a formula like;

shared numbervar namerecord:=namerecord+sum({table})

if these 100 records are in subreport then you have to create this formula
in subreport.


rgds,MHP

 

[Madawc]

You could also do a running total, with a formual to determine whether it adds or not.

Madawc Williams (East Anglia, UK)