August 14, 2014 at 3:38 pm
Hello I have a report I designed that is using cascading parameters that selects Date, Concept, and then it breaks down the Customers based on the concept you chose and when I select ALL Customers for the concept it goes back and searches for the customers and takes FOREVER.
The database has over 2 million rows of data on SQL 2008 R2
Any Help would be greatly apprenticed.
August 15, 2014 at 4:42 am
Hard to answer your question with no code to see or anything, but I suspect your ALL is causing you issues in your code if you use an IN clause. What we do is not use the SSRS ALL and use our own 'ALL'. Thus in our code if a user selects 'ALL' we replace the IN clause with '%' and thus the IN clause is negated and runs much faster. It does not have to seach every row for values in the IN list. There are SSRS Google articles on this subject that you can serach on.
Here is one example of what I am talking about:
http://dataqueen.unlimitedviz.com/2011/06/how-to-default-to-all-in-an-ssrs-multi-select-parameter/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply