March 1, 2011 at 10:19 pm
Hi
I've written a simple report (SQL 2008 R2 installed) which returns 10 fields and about 4000 rows of data. It has 4 parameters but I don't think they are relevant.
The report renders fine when it is a 4000 row list. The problem is when I turn it into a drill down report by grouping up one field and hiding the remainder of the details. The drilldowns work fine until you try to expand one with over 2000 (or so) rows.
Not only does it not open, but it crashes SSRS and I get the "nice" message letting me know a problem has been experienced and would I like to tell Microsoft about it.
Does anyone have any ideas what might be happening?
June 17, 2011 at 5:40 am
I have been experiencing this issue too with i.e. and I guess it will be the same for Firefox... Not that you should be delivering SSRS to a multi browser environment. My theory is that SSRS and the AJAX component (whatever it uses) can't manage repainting the page if there are a large number of items. I have tried removing sorting, performing sorting on the server, etc.
Once the number of items in a sub group get too large, i.e. either hangs or takes a very long time to return data.
There are only two possible options:-
Filter the sub group to show records that you are interested in. For example, whilst the group total may equal 20000, you may only ever get < 300 sub items that need to get displayed. This is highly risky because the underlying data may see an increase in volumes and you are back to square one.
The only other option is to develop a drillthrough report to show the underlying data and avoid drilling down altogether.
It seems incredulous that this type of functionality has ever been released. It has caused a lot of embarrassment when having demoed this functionality on sample data, we are then faced with very large data volumes.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply