Hi Vlad

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