Are You Sure You’re Using the Right Query?

Posted by & filed under , , .

I found a nice little feature in SQL Server Reporting Services (SSRS) today.  Through the expression "=dataset!<dataset name>.commandtext" the query executed by the dataset can be returned to the report.  There is also a rewrittencommandtext function but it appears to only be populated when Report Models are being used.  This feature been around for a while, but the lacking intellisense kept it hidden from me.

Check out the SSRS Team Blog post on this feature for some creativity in adding this to your reports.