SQL reporting services - export to Excel

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.
LVL 5
ViggeeAsked:
Who is Participating?
 
Computer101Connect With a Mentor Commented:
PAQed with points refunded (250)

Computer101
EE Admin
0
 
HillwaaaCommented:
Hi Viggee,

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

Cheers,
Hillwaaa
0
 
chrismcCommented:
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
 
ViggeeAuthor Commented:
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
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.

All Courses

From novice to tech pro — start learning today.