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!
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.