March 31, 2008 at 12:56 am
Hey everyone,
I've written a report in ssrs that calls a sproc that returns 412 rows. When I run the sproc from SQL it returns the data in 1 second.
The data that is returned I need to group, and for each group, I create a total for that group based on a sub category.
So an example - this is whats returned from the database:
name value category
david 10 Cat1
david 10 Cat1
david 10 Cat1
david 10 Cat2
bob 20 Cat1
bob 20 Cat1
bob 20 Cat2
This is what I need returned in the report:
+David
Total Cat1 30
Total Cat2 10
+bob
Total Cat1 40
Total Cat2 20
Then if you drill down you'll see the values of david and bob.
Now I have this working. But it takes about 1 minute to run in ssrs.
1 minute is too long so i've had to scrap grouping and totalling in ssrs, and do the logic within sql. The result set is returned in a very basic structure and appears like so:
name value category
david 10 Cat1
david 10 Cat1
david 10 Cat1
david 10 Cat2
Total Cat1 30
Total Cat2 10
bob 20 Cat1
bob 20 Cat1
bob 20 Cat2
Total Cat1 40
Total Cat2 20
This is okay but not exactly what i wanted. Blank lines between the last total and the next name is what i reallly want.
But my question:
Is there any way to speed up ssrs grouping? This really isn't a complex report, so how does ssrs run so slowly?? Could i not run the report page by page in some way? Any suggestions to speed up the report would be great.
Thanks
March 31, 2008 at 8:45 pm
hi....
may be u can do grouping first in SP....and then do it in the SSRS....may be it can be a little faster than what u doing now.... :):)
i hope...this reply can helping u...
April 16, 2008 at 9:32 am
it wasn't the grouping that was slow...
I was using quite a few expressions in the textbox properties. I removed alot of the code and it all seems fine now.
no problems with grouping 🙂
April 16, 2008 at 8:33 pm
that's good.....you can doing experience as often as you want...so you can understand.....just try and error :D:D:D
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply