Solved

SQL reporting services - export to Excel

Posted on 2006-11-06
5
910 Views
Last Modified: 2008-02-01
The export to excel is not working in the SQL reporting services. all other exports are working.
If I do a remote to the reporting server and access the report likee http://localhost/reports.... the export is working but if I do http://sqlrptprod08/reports from my local machine the export to excel is not working.
0
Comment
Question by:Viggee
5 Comments
 
LVL 16

Expert Comment

by:Hillwaaa
ID: 17885569
Hi Viggee,

Are you using sql reporting services 2000 or 2005?
When the export doesn't work - what happens?

Cheers,
Hillwaaa
0
 
LVL 18

Expert Comment

by:chrismc
ID: 17887927
Hi Viggee,
Presumably the report works normally otherwise.
Have you tried it on different workstations

The initial release of RS2000, without service packs could only export to Excel 2003. SP1 changed this to allow export to Excel 2000.

Can you explain in more detail, what is happening when you try to export.

Cheers
Chris
0
 
LVL 5

Author Comment

by:Viggee
ID: 17902777
I have fixed this issue, in the reporting services configuation manager, the execution account was not specified, when I specified it the excel exports started working.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 18090330
PAQed with points refunded (250)

Computer101
EE Admin
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
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…

821 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