Solved

SQL reporting services - export to Excel

Posted on 2006-11-06
5
899 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Reporting 5 148
I need help adding images to my Crystal XI report 2 78
bank transaction downloader ? 1 69
Tool to convert Crystal Report (rpt) to Jasper Report 2 209
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

863 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now