April 19, 2010 at 3:56 am
Hi all
I have a client looking at using SSRS 2008 to build a few big reports that have 45 plus tablix and charts in a single report, with this all rendered to a single MS Word document, for further "by hand" editing. The completed report is easily in excess of 35 pages, with some controls on their own pages, while others share a page.
My questions:
Can SSRS 2008 handle this many controls on a single report, or should I go the Report/Sub-Report route? Should I rather look at another technology to do this? Initially the client wants to roll this out with 2008 Express (data stored is small enough to get away with it).
I'm not scared of reading up on the net, so if someone has a link to a page that deals with large reports like this please do paste as well.
April 26, 2010 at 7:29 am
Hello,
i would recommend using the subreport's approach, be it more for your peace of mind than for performance issues.
As the basic engine within Sql Expr. Ed is the same as the 'big brothers' you should have no problem. Please keep in mind that, within SSRS 2008 Express Ed, the ONLY way to get data in that is not stored ON THE SAME SQL EXPR ED. database physical server, is by using linked-server constructs!
Kind regards,
Erik
May 9, 2010 at 11:56 pm
Thanks Erik
Client is thankfully only going to want data from their instance, and so we don't need to link. Are there not issues with Sub-reports not rendering to exported formats?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply