Solved

Reporting Services Export to .xls file size too large

Posted on 2006-07-24
7
604 Views
Last Modified: 2008-01-09
OS: Server03
Reporting Services 2000 w/SP1
SQL 2000

Everything seems to be working fine. Reports generate quickly. This is a new install but I am reporting on the same data and using the same rdl files as previously. When I pull a report and export to .xls I get a return of 68MB instead of the 6MB it used to be. I can download as csv and the columns and rows line up. What else is being saved with my file or what is going on?
0
Comment
Question by:jjthesavage
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 14

Accepted Solution

by:
simon_kirk earned 250 total points
ID: 17169702
Try installing SP2.  This has some fixes and modifications that should help with this problem.

http://www.microsoft.com/downloads/details.aspx?FamilyID=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
0
 

Author Comment

by:jjthesavage
ID: 17170380
is there a FOR SURE way to roll back changes SP2 makes incase it interferes with my current setup?
0
 
LVL 14

Expert Comment

by:simon_kirk
ID: 17170703
Virtually impossible to roll back service packs.  It should have no effect to your existing setup, though if you want to play safe, and tbh i would, you could backup the server using something like Norton Ghost and backup your db's to file.

As MS state:

Important: Read this before installing SP2.

Installing SP2 modifies your Report Server databases. The upgraded database will not be compatible with pre-SP2 versions of Reporting Services. Back up the ReportServer and ReportServerTempDB databases using the SQL Server management tools. These backups will be necessary if you decide to reinstall SQL Server 2000 Reporting Services without SP2.

There is no uninstall feature for Service Pack 2. To revert to the version that you were running before installing SP2, you must uninstall Reporting Services and then reinstall it from the original media.

Back up a copy of the database encryption key. For more information, see Managing Encryption Keys.

0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:jjthesavage
ID: 17175682
I was wondering if anyone else can think of any other reason my issue could happen. If not I will go ahead with SP2. I just got finished spending 7 days on the phone with microsoft trying to get reporting services to work on my SSL. So, needless to say I am extremely worried about messing with the config much. Thanks for your time and thank you simon_kirk for your response.

J
0
 
LVL 14

Expert Comment

by:simon_kirk
ID: 17176197
no problem.  always a worry when applying SPs, though i had no problems with either SP1 or SP2 for RS... maybe I just got lucky ;o)
0
 

Author Comment

by:jjthesavage
ID: 17176477
service pack 2 worked. I got my reports to download at a good size. This is finished... how do I give SIMON_KIRK the points?

J
0
 
LVL 14

Expert Comment

by:simon_kirk
ID: 17176706
Glad to here it installed and fixed the problem without causing other problems.

http://www.experts-exchange.com/help.jsp#hs5
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Suggested Courses

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question