>hi,
>
>can i put the code at myreport(if yes where).
>select * from ProductsBought where client = "joe";
> order by Description;
> into cursor temp
>report form MyReport
The report has a DataEnvironment, and you can do some things there. I am not sure about the answer to your question. But it is much easier, and safer, NOT to use the DataEnvironment for reports. Just prepare all the data before you run the report.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)