>>> 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, with a little planning you can pick up data fields, even captions, from a SQL-Select.
1. Run the SELECT to a cursor
2. Open a new report
3. Pick 'Quick Report'
4. Select your choices of layout, titles, alias, etc.
5. Now modify the report by dragging the pre-set fields whereever you want.
If you design your SQL so each field name is the same as the caption you want, half your work is done. You can also set the default font to your preferred font before starting 'Quick Report' which saves re-setting fonts & positions for every field.
HTH