High-Performance SQL Server Reporting Services: Lessons Learned with Bert Wagner

SQL Server Reporting Services (SSRS) is an easy-to-use tool for automating reports and creating highly visual dashboards. Although SSRS is easy to learn there are many tips and tricks that can improve your report building experience, not to mention make your reports run blazing fast!

This rapid-fire session goes over my learnings from the past six years of developing high performance SSRS reports, including topics like multivalue parameter efficiencies, how to best utilize subreports, and performing SQL CRUD operations with SSRS.

Each rapid-fire topic includes sample data and an SSRS reporting example that users will be able to try out for themselves.

[johnpace]

Its 2020 and we are still watching SSRS!!!

[SBDavin]

21:45 Using an SSRS multivalue report parameter with a stored procedure will require tricky SQL programming in the sproc.
Often, it's best just to use an SQL query with an 'IN' statement, unless you have to.

[andre_maurice_davis]

That was easily the best presentation of SSRS report building techniques I've seen to date. Very clear, to the point, and the demos were walked through in a way that I could understand. Thank you!

[continental_drift]

I wish I had found this video weeks ago, really need to update your search tags.

[Ferruccio_Guicciardi]

Very handy Bert ! Thanks for sharing !

[funniq]

WOW ... this is a very valuable video. Thanks for setting this up and for sharing ...

[BlaneStroud]

One good reason to have SSRS do the filtering would be for caching. If you have a long report, that's going to be long no matter what, you can cache the report (assuming you don't need live results, of course). If you let SSRS do the filtering, rather than filtering in a WHERE clause, then you can cache the entire report and have it run instantly, no matter what parameter choices you make. Whereas, if you use a WHERE clause for filtering, a change in parameter values will cause SSRS to drop the cache of the report and cache the new version. It's a very edge case, and I've only had to do it once, but it's the only example where I can think of a performance gain from SSRS filtering.

[Bulollas]

Thanks so much Bert, I really appreciate the video, samples and your expertise on this topic.

[ravitutika]

Thanks for the video and am unable to open the link in description please check

[virenderthakur]

Is there a way to enable the cors at reporting server. I am getting sameorigin error.

[dorianhidalgo]

Hi, in your blog your mention that we can disable rendering of sub report, but I don't understand how to do that, Can you explain me. Thanks.

[suc]

Hi Bert, I could directly apply your CRUD operations part, excellent work. Nevertheless there is a nasty issue .
The CRUD report loads itself while doing CRUD so the back button stops working (or you have to click multiple times to go back to the previous report). SSRS does not make easy to open reports in a new window so how do you deal with navigation when your CRUD report opens from another report and you want to go back?