Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Network:
Windows 2000 Server
>>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
Thanks, I wondered about that. I just wanted to be lazy and use the whole sorted file. I'll try it.
Rebecca :o))
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement