Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to call RR from VFP
Message
From
12/08/1999 14:26:28
 
 
To
12/08/1999 13:04:51
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
00252875
Message ID:
00253136
Views:
36
>>
>>I hate to say this, but, you are going to have to learn enough about R&R to do what you want. The basic answer to your question is YES you can prompt or collect paramaters in your VFP ap and pass them to R&R. But, you can't do it without knowing how.
>>
>>Now that you know that it can be done, get from your buddy the R&R Developers guide which explains how to interface with R&R from your program to learn how to do it.
>>
>>BOb
>
>Hi Bob,
>I guess I have to dive into it against my better judgement.
>i put the rrcontrol on a form, figured out how to set the reportname property but the manual fails me form that point on.
>if the report is run from the wndows explorer r&r prompts for the user_input field (e.g. State) and the user inputs CT and it prints only connecticut records.
>How do I set in my form a parameters property so only Connecticut will be printed?? (No it's not in the manual)
>
>Peter

It depends on what version of R&R and method you are using in the report to get the value. My current experience is with Fox 2.6 so I have to use the parameter DBF. You can populate the .DBF parameter field with the value you want from your ap prior to running the report. Or, you can just allow R&R to prompt by putting a Question Mark in the parameter field.

Also, for queries there is a field to pass a query parameter also. I think this would be even easier with the .DLL. Do you get FoxAdvisor... a recent issue had some how to's for using the R&R activeX control to print reports.

BOb
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform