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:
00353514
Views:
17
Diane,
Where you put the code depends on where you have USEd your view. I'm assuming this is a parameterized view with parameters for the Product_Name and Quality fields? If so, then at some point you assign values to the parameters and ReQuery() the view, correct? This is the point to check the Reccount() value (as Dave suggests).

The _tally method is useful if you have a SELECT.... into cursor RptData where the cursor is used in the report. If this isn't clear, then let me have a little more information:

1) Is this a parameterized view? If not how do you limit the data (if you're using SET FILTER, please think again. This can be very slow with large record sets and most of us try to avoid it).

2) Where do you update the view to get just the data you want on the report

Thanks,
Barbara

>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.
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform