Help on Report

[Jose Lerebours]

Try this:

In your -v process, set the sort to the combined string of DATE + 
CONTROL #, may want to set the date as YYYY-MM-DD to make sure you get a 
proper order since at this point the date will be a string, not a DATE 
field.

Select ONLY one combination so that your processing only runs for as 
many instances as you expect to print - In other words, within your -v 
process, perform lookup - and loop through the data but only SELECT if 
the record pointed is of a different string DATE+CONTROL not yet selected.

To know which string has already been selected, you can (a) store in 
array, (b) store in temporary file, (c) store in a long string - of 
course, your choice should be based on how many unique strings you 
expect to process (I am all about arrays).

Once you've selected the records you want to process, your processing 
table should have an identical loop where you perform lookup (not lookup 
- ) and read the data needed to print (count, start ctrl, end ctrl).

Because you selected the few records that make up a "unique key" by 
combining the DATE + CONTROL, you may not need to use the @wbrk 
triggers.  In your output form, set dummy variables to be populated by 
processing before "PRINT" if you choose to use that or "END" ...


On 7/13/20 2:12 PM, scooter6--- via Filepro-list wrote:
> 01234        00010      01234-00010          06/01/20
> 01234        00011      01234-00011           06/01/20