none
SSRS 2012 Print button not appearing on ASP.NET app

    Question

  • Recently upgraded an ASP.NET app to SSRS 2012. Unfortunately, just happened to do this the same weekend as IE11 was pushed out, so have been dealing with a host of other issues as well... trying to determine if this is an SSRS issue or an IE11 issue.

    In short, the Print button has disappeared on reports served by the IIS server in my ASP.NET application.

    If I run the asp.net project within VS2013, the print button is there. I can click and print as I was prompted to install the Active/X control to allow printing.

    However, once I push the project to the IIS Server, and go to http://mywebsite and attempt to run the report there, the print button is not present. I do not have the ability to click the print button to install the active/x control.

    I should point out, even though I installed the active/X control on my devbox, the print button still will not appear in the browser there either, if I generate the report off the IIS server. I can run the report from the asp.net application via VS2013, the print button is there, open the same report right next to it in a "regular" browser window via the web site, and no print button.

    Here is the same report, generated from VS2013 (top) and via SSRS via IIS 7:

    The report generated from either is correct, so SSRS appears to be functioning correctly in that respect.

    Checked for issues as outlined In post http://msdn.microsoft.com/en-us/library/ms155874.aspx . All my settings are correct in both browser, and on server.

    Not sure what else to check or to look for. Anyone run across a similar issue? Thanks,Mike



    Saturday, December 14, 2013 1:41 AM

Answers

  • Fixed my own problem.

    I had to install the Report Viewer 2012 Redistributable on the SQL Server 2012 machine running reporting services. When I did the installation, it informed me an "older version" of the report viewer control was installed and ask if I wanted to update. No idea why this was necessary. This box was a fresh install of SQL 2012 and routinely applies all updates.

    Once I did this, the print button successfully appears via the IIS-served ASP.NET pages.

    Sunday, December 22, 2013 2:46 PM

All replies

  • Hi Mike,

    According to your description, I understand that Print button disappears when rendering the report in IIS7, while there is no issue in Visual Studio 2013 environment.

    The issue may be caused by the two causes as shown below:

    •When you add ReportViewer control into web page (.aspx), the Reserved.ReportViewerWebControl.axd httpHandler is added to System.Web section of the Web.Config file. In IIS7, it should be added to the  System.WebServer section.
    •IIS7 Handler Mappings doesn’t contain Reserved.ReportViewerWebControl.axd httpHandler, and it’s the reason that is not able to render some ReportViewer elements which is needed by the JavaScript.

    To resolve the issue, we should make proper entries for Http Handler which handles the calls to ReportViewerWebControl.axd. For the details, please see the blog.

    Reference:
    http://bhushan.extreme-advice.com/why-reportviewer-control-not-working-on-iis-7/

    If you need more assistance, please feel free to contact me.

    Regards,
    Heidi Duan

    If you have any feedback on our support, please click here.


    Heidi Duan
    TechNet Community Support

    Monday, December 16, 2013 8:36 AM
    Moderator
  • •When you add ReportViewer control into web page (.aspx), the Reserved.ReportViewerWebControl.axd httpHandler is added to System.Web section of the Web.Config file. In IIS7, it should be added to the  System.WebServer section.
    •IIS7 Handler Mappings doesn’t contain Reserved.ReportViewerWebControl.axd httpHandler, and it’s the reason that is not able to render some ReportViewer elements which is needed by the JavaScript.

    Thank you for your reply. I did verify the entry you referred to is present in my web.config. Just to make sure, I deleted the existing entry I had, and I replaced it following the instructions in the blog posting. Within IIS, I now see:

    And if I view web.config manually, I see:

    Restarted IIS. The problem still persists. I do not see the print button when reports are generated via IIS (nor do I see the 100% box either, for what its worth.)

    Edit: As a followup, found a box which did not update to IE11 and is still running IE10. The problem persists on the IE10 box, so I can rule out it is a problem w/ IE11. The problem appears to be completely isolated to the IIS box serving the pages.




    Monday, December 16, 2013 5:51 PM

  • Anyone? Customer is getting irate because it is a "bug" in my program they are demanding I "fix".... I would gladly "fix" it if I had access to the ReportViewer source code, of course, but, since I don't...
    Tuesday, December 17, 2013 3:39 PM
  • bump. Anyone?
    Saturday, December 21, 2013 4:46 PM
  • Fixed my own problem.

    I had to install the Report Viewer 2012 Redistributable on the SQL Server 2012 machine running reporting services. When I did the installation, it informed me an "older version" of the report viewer control was installed and ask if I wanted to update. No idea why this was necessary. This box was a fresh install of SQL 2012 and routinely applies all updates.

    Once I did this, the print button successfully appears via the IIS-served ASP.NET pages.

    Sunday, December 22, 2013 2:46 PM
  • Hi Mike,

    Thanks for your posting.

    I am glad to hear that you have resovled the issue and share the solution to the forum. It will beneficial for whom have similar issues to resolve.

    Regards,
    Heidi Duan


    Heidi Duan
    TechNet Community Support

    Monday, December 23, 2013 1:20 AM
    Moderator