General information
Category:
Reports & Report designer
Hello Barbara,
Thank you so very very much for your help.
Like you assumed, it's a parameterized view with parameters for Product Name and Quality fields. Let me tell you about what I did after reading your second mail.
I tried to go to DataEnvironment of the report, then Cursor's Properties, and I put the code that Dave suggested in the "Init" Method. The report works fine but seems slower than before. And another thing here is if there is no record to be returned, I got the notice message(what I desire), click "Ok"(on the messagebox) to get out, the report flashs very fast. Do you think that all of those "symptoms" are "normal"? Did I do the coding in the right place, the right way? How about the _tally method? Will it give the same result?
Once, I am looking forward hearing from you. God bless you.
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
********************
>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only