LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » SQL Server Scripts, Code Samples and SSMS Custom Reports » SQL Server Management Studio Custom Reports » ssrs excel rendering creates a huge size excel report

ssrs excel rendering creates a huge size excel report

Options

Previous Topic · Next Topic

dibyant

Posted: Tuesday, May 05, 2009 9:34:21 PM

Rank: Fledgling

Joined: 1/21/2008
Posts: 11
Points: -67
Where do you live?: usa

Hi Scott,
i m facing a big issue when i generate my report which has 40k rows and around 15 columns mostly strings i come up with a strange
result that i get excel report of 30MB which takes couple of minutes to open which is a big issue with Clients.
But when i manually open and re-save this gets compressed and become 14 mb reports which is pretty good and open quickly.
Since i have a lots of reports and i cant open and resave all of them.
I am using subscription to generate report and render into excel.

Any help how we can compressed the report or correct that so that we can reduce the size(the reason behind that is excel uses single byte for strings as defaults and compress whenever needs But ssrs uses UNICODE Double byte as a default, except that i have no knowledge and i dont even know but got some information from msdn).
Scott any help regarding this will be highly appreciated

Thanks

Scott Whigham

Posted: Tuesday, May 12, 2009 11:50:38 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 466
Points: 1,020
Where do you live?: Dallas, TX

Offhand, I can't think of what you would do. I could dig down into the details and figure it out but it would take me 1/2 day probably Frown

And I am trying to finish a five month long project now (that I thought would take 3 months!). I'm sorry but I can't help quickly here Frown

dibyant

Posted: Sunday, May 17, 2009 1:26:42 AM

Rank: Fledgling

Joined: 1/21/2008
Posts: 11
Points: -67
Where do you live?: usa

Scott, please take time but this is one of the issue what we are all suffering in our company.
Any help regarding will be very very very appreciated,(i started with your videos) and had great support in past and please if you can help me in this
this will be really great GIFT for me.

Many thanks in advance

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.