>I am doing a report in which I want to list only the first 15 records in each grouping, not the whole file.
>
>I put in a counter and asked it to print when the counter is < 16, but it's printing the first 15 then leaving blank lines for all the rest (100's of blank pages). I have the no print when empty checked, but that doesn't do it.
>
>Is there a way to get it to quit after 15 and go to the next category?
>
>Thanks,
>Rebecca

Rebecca


Try something like:

Select top 15 .... where ... group by ... into cursor csrFifteens

and use the cursor as the currently selected table to feed to the report?

Terry