General information
Category:
Reports & Report designer
>>Before I generate my report, I do some queries using SQL SELECT, and I save the results into Cursors. How do I use these cursors in my report? I couldn't just "add" a cursor to the Data Environment of the report. I tried to go around this by Writing my queries to tables, adding those tables to the DE, and then rewriting code so the query results are going into CURSORS again. However, the added table in the DE must have an INDEX to be able to set a relation between it and the other report table, and I cann't have an index with a CURSOR. Does this mean I should use tables instead of CURSORS?
>>
>>Mon
>You can use the cursors directly in the report as others have said. The curse is that they no longer show in the field selection dialog of the report designer (I design my report "live"). In FPW you could "see" all the active tables in the dialog, in VFP that is no longer true, but they're still there.
>HTH
found this old answer and your reply. Wondering if you could shed a little more light and experience. Moving my app from VFP 2.6 to VFP 5.0. My clients are complaining that while they are building a report in query maker (third party product), that the fields of their query are no longer shown in the Fields listbox. query maker uses the regular report designer. Is there any way to get the query fields to show in the Expression Builder's, Fields listbox?
thanks - brenda
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