Post reply

Reporting services export to Excel

  • November 1, 2011 at 6:25 am

    #247030

    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

  • November 1, 2011 at 6:30 am

    #1401565

    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!

  • November 1, 2011 at 6:37 am

    #1401570

    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.

  • November 1, 2011 at 6:40 am

    #1401573

    Did he upgrade from excel 2k3 to 2k7 or 10?

    I can't think of nothing else!

  • November 1, 2011 at 6:48 am

    #1401579

    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.

  • November 1, 2011 at 8:16 am

    #1401638

    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.

  • November 2, 2011 at 5:33 am

    #1402068

    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.

  • November 2, 2011 at 5:34 am

    #1402071

    Do you have a link that details that info? I'm sure a lot of people might need that info in the near future.

  • November 2, 2011 at 5:40 am

    #1402074

    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.

  • November 2, 2011 at 5:46 am

    #1402077

    TX

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply