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.