Is there a way to prevent the auto-added Select top N stuff from being added to each report?
I have some reports I want to write that use With or Distinct and every time I try to do it the program adds the select top and things bomb. I suppose I could manually create a view and tie a report to it but I fear that someone looks at it in the report viewer and that breaks it moving forward.
