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.