Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Printing a Report without Data
Message
From
01/05/1998 17:07:10
 
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00096371
Message ID:
00096424
Views:
19
>>>I am using a Select Statement for a report, Sometime there is no data to select so I have an empty cursor. I would still like the report to print even though their isn't any data in the cursor, all I get now is a blank page, I would like to have all my footers layout print. Is this possible, or do I just not get it (don't respond to that) :)
>>>Thanks
>>>Jon
>>
>>Hi, Jon
>>
>>Select ... Into Cursor curRpt Nofilter
>>Use (dbf()) in 0 again alias curNewrpt
>>Select curNewrpt
>>If _TALLY=0
>> Insert Into curNewrpt Values()  && add empty record into the cursor
>>Endif
>>Report Form ....
>>
>
>Thanks Ed,
>I'll give this a whirl, I don't know how you do it:) I've never use the dbf() function before, everytime I have a question you force me to learn more... I suppose thats the purpose, huh?

It's UT purpose:). USE (DBF()) is using here to change read-only cursor to read-write cursor.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform