>How would one go about telling the report designer that the source of the data to be used in the report is a temporary cursor from an SQL SELECT?
>
What I do is copy result cursor in deign/test environment/mode as free table on disc.
select ... from ..into rptcur readwrite
copy to rptcur
***
Then ADD that temporary free table sitting now on my disc to rpt data environment so I can use it for design (drag drop fields etc)
Once report is finished you simply REMOVE free table from rpt data environment AND comment out copy to line
from the whole thing. Report will use cursor instead.
Of course report has to run in current datasession.
HTH
Sergio