[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL reporting services - export to Excel

Posted on 2006-11-06
5
Medium Priority
?
930 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
4 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

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

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 …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

830 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