Filtering on SQL report

[Hatcher12]

Hello all,

I was wondering if there is any performance increase/decrease with using detail filters on the source data (ex. [SQL1].[dept_name] in ?department?) vs data items tab (ex. [dept_name] in ?department?). Thank you!

[dougp]

If you look at the generated SQL, it will be the same either way.

I find that every time I use a data item for a filter, it comes back to bite me.  Often I want to copy filters from one query to another or from one report to another.  The data item is not always there, but the reference from the source is.