Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 619
  • Last Modified:

Reporting Services Export to .xls file size too large

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
jjthesavage
Asked:
jjthesavage
  • 4
  • 3
1 Solution
 
simon_kirkCommented:
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
 
jjthesavageAuthor Commented:
is there a FOR SURE way to roll back changes SP2 makes incase it interferes with my current setup?
0
 
simon_kirkCommented:
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
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
jjthesavageAuthor Commented:
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
 
simon_kirkCommented:
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
 
jjthesavageAuthor Commented:
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
 
simon_kirkCommented:
Glad to here it installed and fixed the problem without causing other problems.

http://www.experts-exchange.com/help.jsp#hs5
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now