Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using a SQL Select cursor as data source??
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00095834
Message ID:
00095846
Views:
25
>> Select X FROM Y INTO CURSOR A
>> Report Form abc.frx PREVIEW
>>
>>Now I want Report abc to use Cursor A as it's data source, can this be done?
>
>Sure, no problem. The only thing is that when you're designing the report, you won't be able to choose the cursor's fields as you can for a permanent table: you need to type them in manually. However, if you run the SELECT before editing the report, it will pick up the field sizes correctly.
>
>Also, don't choose 'Privata Data Session'.


Thanks a lot, I figured it had to be possible. I went back to my report to see if I could find why it wasn't working, turned out that one of the field names somehow got had the reports name infront of it as a qualafier. Once I took that out it works like a charm.

Thanks again.
Preston A. Larimer                          palarimer@usa.net
Olive LLP
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform