Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Want to skip records
Message
From
29/11/2006 10:52:17
 
 
To
29/11/2006 09:56:02
Rebecca Stottlemire
Kansas State Department of Commerce
Topeka, Kansas, United States
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Network:
Windows 2000 Server
Miscellaneous
Thread ID:
01173254
Message ID:
01173288
Views:
8
>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

Seems like you'll need to do in procedural code:

Hopefully the table is ordered by some key withing group-code key, or you can first SQL select the data INTO his order.
Then in a scan loop, with item-within-group counter 1-15, successively add the required recs to another table/cursor, and use this for the report.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform