Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Reporting services export to Excel


Reporting services export to Excel

Author
Message
imranx101
imranx101
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 70
Hi all

When an user export a report to excel or to any applicaiton after running a SSRS report from internet explorer , it wont export and just creats an empty tab on internet explorer.

But for other users it works fine. The above user has got new computer and before she could export it on older computer. Is there any setting I need to do on Internet explorer or anything? Right now it just creates blank tab after clicking export button.

Please help

Thanks
Ninja's_RGR'us
Ninja's_RGR'us
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20943 Visits: 9671
Have you checked what's happening server side?


Query stuck?
Rendering stuck?

Anything in any of the logs?

Exec log, windows & sql logs?


Can you export the same report with the same parameters on another machine?



Anything else points to clone the old machine and rebuild the new one from that, which I'm sure you want to avoid!
imranx101
imranx101
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 70
Thanks for reply

All other users can export the report easily. This user has only problem. I am how and which logs I need to look at. The report running fine and users been using from long time , its just export to excel.

This user's PC was upgraded from XP to Windows 7. Its same PC but formatted and upgraded by IT department. PC works fine and so does the internet explorer. I am thinking is there any setting need to be done? I can't go back to IT dept and tell them to check as they dont have a clue what SSRS is so they will not look into this problem.

Its something I need to do myself.

Thanks.
Ninja's_RGR'us
Ninja's_RGR'us
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20943 Visits: 9671
Did he upgrade from excel 2k3 to 2k7 or 10?


I can't think of nothing else!
imranx101
imranx101
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 70
Possibly. But it wont export to any format. Not to PDF even or anything else. So I am assuming its problem in internet explorer. Why it opens a blank tab when export button is being clicked?
Is there any case this user might not have permissions to download or something? But same time I believe she can download other stuff.

Strange I know but please if you can help me will be much appreciated.
Ninja's_RGR'us
Ninja's_RGR'us
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20943 Visits: 9671
Try adding the site to safe zone and then putting the security to the lowest level.

That's the only thing that could block this in IE that I know of.
imranx101
imranx101
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 70
Hi

The problem was in IE it self, New tab wasn't working. I fixed it by running a fix for it. I guess its bug from Microsoft.


Thanks.
Ninja's_RGR'us
Ninja's_RGR'us
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20943 Visits: 9671
Do you have a link that details that info? I'm sure a lot of people might need that info in the near future.
imranx101
imranx101
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 70
http://social.technet.microsoft.com/Forums/en/ieitprocurrentver/thread/cf38b0ae-34f6-4f0b-9b45-7a6e41ef014a

Above is the link. When I was clicking on export in SSRS report, it opens new tab and exports to excel or whatever. As new tab wasn't working it was just giving me blank tab.
Ninja's_RGR'us
Ninja's_RGR'us
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20943 Visits: 9671
TX
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search