I did a search in foxfires forums. It works as I stated previously. Once you edit the sql for a report, that sql will always be executed for the report. you need to press f7 in the sql window to return the sql to generated mode.
pf
>I do not want to edit the filters. I want to edit the sql, but when I try and edit the sql, it prompts me for my filter value and then puts this value in the where clause. When I now save the changed sql the filters value is hard coded. How can I save the sql without having the filter condition hard coded.
>
>Stuart
(On an infant's shirt): Already smarter than Bush