You can run any report on any cursor. When you use 'report form' command, report just takes current alias as the reporting cursor, if you do not include any other tables/views in its data environment.
>Sorry to be such a bother...
>But if i use the SQLEXEC and get the result in the cursor. How would I then run the report using the cursor as the source???
>
>Thanks again
>Fida
>
>
>>Hi!
>>
>>If you still want to use data enviroment, than create view. You can include view in data environment as a usual table.
>>
>>>thanks for the reply
>>>can you give me an example of this please?
>>>My problem is the report is setup and in the data environment of the report
>>>how do i say its this particular cursor?
>>>
>>>Thanks
>>>Fida
>>>
>>>
>>>>Hi!
>>>>
>>>>Use SQLConnect and SQLExec functions. SQLExec returns cursor with name you specify in third parameter, than you ca show report based on that cursor.
>>>>
>>>>>Hi All
>>>>>
>>>>>Can anyone please help with this :
>>>>>
>>>>>I use this statement e.g
>>>>>
>>>>>select assets.asnum, assets.sub, assets.price, assets.group_, group.desc_
>>>>>from baud!assets inner join baud!group ;
>>>>>on assets.group_ = group.gcode ;
>>>>>order by group.desc_ ;
>>>>>into cursor aspurch.
>>>>>
>>>>>How do i use this output as a source for a report???
>>>>>Or do i do this differently
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.