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.
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!
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.
Good point but you can also bring in a “larger than needed” initial dataset and filter it inside the report for the various data tables, charts and whatnot as well. Instead of a separate dataset for each reporting structure.
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?
Ravi, this is where he has the documents and samples --- > bertwagner.com/presentations/, I recommend you to go to groupby.org/conference-session-abstracts/high-performance-sql-server-reporting-services-lessons-learned/ for additional information about this video.
Its 2020 and we are still watching SSRS!!!
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.
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!
And apparently "Andre"s around the world agree.
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.
Good point but you can also bring in a “larger than needed” initial dataset and filter it inside the report for the various data tables, charts and whatnot as well. Instead of a separate dataset for each reporting structure.
I wish I had found this video weeks ago, really need to update your search tags.
Very handy Bert ! Thanks for sharing !
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.
What a useful video. Thank you Bert
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?
Is there a way to enable the cors at reporting server. I am getting sameorigin error.
WOW ... this is a very valuable video. Thanks for setting this up and for sharing ...
Thanks for the video and am unable to open the link in description please check
Ravi, this is where he has the documents and samples --- > bertwagner.com/presentations/, I recommend you to go to groupby.org/conference-session-abstracts/high-performance-sql-server-reporting-services-lessons-learned/ for additional information about this video.
Thanks so much Bert, I really appreciate the video, samples and your expertise on this topic.