Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Keep the report open without any record returned!
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00352954
Message ID:
00353353
Views:
14
Hello Barbara,
After I read your reply and Dave's, I would like to go with a messagebox that stating no records are found and forget about the empty report. I started working with VFP not long ago and telling the truth that I don't have much experience especially with REPORTS.
The report that I am working on is my first one. It's duty is to report the products individually, also the quatity(good/bad). That report bases on views which has "fitter" for the Product_Name, Quality.
Please, be patient with me. I don't know where to put the coding(from Dave's reply) or where is the _tally that you said on yours. Can you tell me more about this. I appreciate your help very very much.
Diane.


>>Do you really want the user to see an empty report? Or just to have them notified that there ARE no records? I always use a cursor containing just the records for the report (instead of a filtered table) and I can check _tally after the SELECT runs. If _tally = 0, then I put up a messagebox stating that no records were found. If _tally > 0 then the report runs.

>>If for some reason you REALLY want an empty report visible (clients sometimes demand strange things....), you'll probably have to add an empty record to your report cursor. This will mean you have to make it a read/write cursor before appending a record.

> My question is how to get into the report when there is no record to be returned. When I preview the report, it flashs very fast then closes without any performance.
> Is there any way that I can display a message which notices that there is no record there, or keep the report open even all fields are blank?
> Any susgession would be appreciated!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform