Adding a new line conditionally

[mg712]

I would like to add a new line after the record count gets to a known number. Once it does I want to reset the record count and start again. I'm sure how the formula should be set up to do this or where it should go. Thanks in advance for any help.

 

[Ngolem]

so you want to add a line say after every 100 records

Add the line that you want to the detail section of your report but in the conditional suppress place the following formula

WhilePrintingRecords;
RecordCount/100 = 0;

just change the divisor accordingly...no need for a reset

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[lbass]

Insert a new detail section and draw your line there. Then use the following as the suppression formula for the section the line is in:

remainder(recordnumber,100) <> 0 //change the &quot;100&quot; to whatever recordnumber you want the line to repeat on.

-LB

 

[Ngolem]

oops! yes My formula should be

WhilePrintingRecords;
RecordCount/100 <> 0;


Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!