Do you mean limit the detail band to 12 records .. or do you mean that one detail record will stretch several lines and you want to limit how much it stretches on one page?
For the first option .. create a variable that counts the lines on the report. Then set up a data group with an expression similar to the following:
INT((nLine - 1) /12)
Also, make sure the data group is marked as "Start on new page".
If what you are asking is the second option I described .. then you're going to have to build a cursor and manipulate the data before hand .. in essence .. breaking up the data into one record for each "12-line" chunk of data.
Cathy
>Cathy,
>
>This is good stuff, I think you have me pointed in the right direction. Assuming I followed the above instructions correctly, i.e. RECNO() for a group, report variable nLines to count number of lines in detail band, SEtVar code in 'OnExit', "continued" text in Page footer and nLines > 0.
>
>I was wondering how to limit the number of lines in the detail to 12, could I put the "continued" text in Group footer or even the detail band itself?
>Any advice would be greatly appreciated.
>Thanks,