>Thanks Hilmer,
>
>Removing the table from the Data Environment worked a treat.
>
>Cheers,
>
>Jason
OK, great. BTW, with "flexibility" I meant that, for instance, you could change the filter, or the sort order, depending on user options. Actually, I do all my reports through cursors. Here is an example of changing the sort order of a client list:
if ThisForm.OpgGroupBy = 1
lcSortBy = "ClientCode"
else
lcSortBy = "ClientName"
endif
select * from Client order by &lcSortBy into cursor temp
report form client ...
This sort of manipulations also make it necessary to purge the DataEnvironment.
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)