Report designer - turning off the query generator

Is there a way to stop the report designer from 'fixing' my query?

I tried to modify the where clause with an OR statement and when I ran the report it totally messes it up.

Any ideas?

It sounds like you are using the visual query designer (4 display panes). You can just switch to the generic query designer (2 display panes). More information is available here: http://msdn2.microsoft.com/en-us/library/ms365414.aspx

-- Robert

sql