?
Solved

SQL reporting services - export to Excel

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

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 …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Suggested Courses
Course of the Month12 days, 13 hours left to enroll

777 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