Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Detail w/o Records
Message
From
19/11/1999 05:44:19
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
18/11/1999 14:00:45
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00292608
Message ID:
00292939
Views:
16
>Is there a way to get the Detail of a report to continue printing to the bottom of a page even though there no records left to report on? In other words I have a report that prints a form type document and this form always has to have 15 lines regardless of whether there are 15 records left to report or not. (Each detail line has graphics in it that need to be printed with or without the associated table records.) I know that I could add enough blank records to the table to complete the page, but I'd rather not do it that way.
>
>I'd appreciate any responces you might have!
>
>Thanks In Advance,
>Craig


Craig,
AFAIK w/o supplying 15 records you cannot print 15 detail passes. But you don't need to add blank lines to your table. Instead create a dummy cursor and add max(reccount(yourtable),15) recs to it. Relate it to original table and report (if your table has no index then you can simply relate recno()).
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform