Press "Enter" to skip to content

Including a SQL Query in an Expression in SSRS

Slava Murygin shares a tip:

Why: Most of the time, when you want a flexibility of your SQL query you can use parameterization. However there might be a situation when you’d need to build a dynamic query. In my case I used SQL query within an expression to feed it to multiple data sources targeting different servers with the exact same query.

Read on to see what Slava has fought with in the past.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.