Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Reporting Services - Print Button not shown in Mozilla

I am using SQL Reporting services, it's working perfectly and shows a print button in IE, but not shown in Mozilla Firefox.

Does anyone have any idea?

I have checked out this solution, but it's not working:

http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/7bdf431d-70db-419d-8e98-ef41cad8e2d8

like image 957
Muhammad Akhtar Avatar asked Jun 04 '09 14:06

Muhammad Akhtar


People also ask

How Can Show Print button in Report viewer in asp net?

report. I set "showPrintButton="True"".


4 Answers

I don't think it uses ActiveX, because in the table onclick event there is a simple:

ReportFramerpvReport.GetReportFrame().contentWindow.print()

Anyway, i replaced this print stuff with my own print function, because this code above wasn't working on FF..

I know it's ugly...but it works! (just replace the ControlName value with your ControlID and be sure to add jQuery lib in your page)

    $(document).ready(function()
    {
        if ($.browser.mozilla)
        {
            try
            {
                var ControlName = 'RptDespesas';
                var innerScript = '<scr' + 'ipt type="text/javascript">document.getElementById("' + ControlName + '_print").Controller = new ReportViewerHoverButton("' + ControlName + '_print", false, "", "", "", "#ECE9D8", "#DDEEF7", "#99BBE2", "1px #ECE9D8 Solid", "1px #336699 Solid", "1px #336699 Solid");</scr' + 'ipt>';
                var innerTbody = '<tbody><tr><td><input type="image" style="border-width: 0px; padding: 2px; height: 16px; width: 16px;" alt="Print" src="/Reserved.ReportViewerWebControl.axd?OpType=Resource&amp;Version=9.0.30729.1&amp;Name=Microsoft.Reporting.WebForms.Icons.Print.gif" title="Print"></td></tr></tbody>';
                var innerTable = '<table title="Print" onmouseout="this.Controller.OnNormal();" onmouseover="this.Controller.OnHover();" onclick="PrintFunc(\'' + ControlName + '\'); return false;" id="' + ControlName + '_print" style="border: 1px solid rgb(236, 233, 216); background-color: rgb(236, 233, 216); cursor: default;">' + innerScript + innerTbody + '</table>'
                var outerScript = '<scr' + 'ipt type="text/javascript">document.getElementById("' + ControlName + '_print").Controller.OnNormal();</scr' + 'ipt>';
                var outerDiv = '<div style="display: inline; font-size: 8pt; height: 30px;" class=" "><table cellspacing="0" cellpadding="0" style="display: inline;"><tbody><tr><td height="28px">' + innerTable + outerScript + '</td></tr></tbody></table></div>';

                $("#" + ControlName + " > div > div").append(outerDiv);

            }
            catch (e) { alert(e); }
        }
    });

    function PrintFunc(ControlName)
    {
        setTimeout('ReportFrame' + ControlName + '.print();', 100);
    }
like image 113
Izzy Rodriguez Avatar answered Oct 22 '22 14:10

Izzy Rodriguez


The above solution was not working for me, so I made the following changes to the above solution after inspecting the rendered html.

ReportViewerGeneral_ctl05 -> id of the pager
VisibleReportContentReportViewerGeneral_ctl09 -> id of the div that contained the result of the report.
pageLoad -> refer this

function pageLoad() {

if ($.browser.mozilla && !$("#ff_print").length) {
            try {
                var ControlName = 'ReportViewerGeneral';
                var innerTbody = '<tbody><tr><td><input type="image" style="border-width: 0px; padding: 2px; height: 16px; width: 16px;" alt="Print" src="/Reserved.ReportViewerWebControl.axd?OpType=Resource&amp;Version=9.0.30729.1&amp;Name=Microsoft.Reporting.WebForms.Icons.Print.gif" title="Print"></td></tr></tbody>';
                var innerTable = '<table title="Print" onclick="PrintFunc(\'' + ControlName + '\'); return false;" id="ff_print" style="border: 1px solid rgb(236, 233, 216); background-color: rgb(236, 233, 216); cursor: default;">' + innerTbody + '</table>'
                var outerDiv = '<div style="display: inline; font-size: 8pt; height: 30px;" class=" "><table cellspacing="0" cellpadding="0" style="display: inline;"><tbody><tr><td height="28px">' + innerTable + '</td></tr></tbody></table></div>';

                $("#ReportViewerGeneral_ctl05 > div").append(outerDiv);

            }
            catch (e) { alert(e); }
        }
}


    function PrintFunc() {
        var strFrameName = ("printer-" + (new Date()).getTime());
        var jFrame = $("<iframe name='" + strFrameName + "'>");
        jFrame
        .css("width", "1px")
        .css("height", "1px")
        .css("position", "absolute")
        .css("left", "-2000px")
        .appendTo($("body:first"));

        var objFrame = window.frames[strFrameName];
        var objDoc = objFrame.document;
        var jStyleDiv = $("<div>").append($("style").clone());

        objDoc.open();
        objDoc.write($("head").html());
        objDoc.write($("#VisibleReportContentReportViewerGeneral_ctl09").html());
        objDoc.close();
        objFrame.print();

        setTimeout(function () { jFrame.remove(); }, (60 * 1000));
    }
like image 24
Sachin Avatar answered Oct 22 '22 14:10

Sachin


If you're offering export functionality via the ReportViewer, the user can still export to PDF and print that. Not as efficient/slick as a one-click print button, but it's an easy work around.

like image 2
Tyler Avatar answered Oct 22 '22 15:10

Tyler


I've made a solution which emulates the entire print button from IE to other browsers.

https://stackoverflow.com/a/37455354/1253835

like image 1
cafekun Avatar answered Oct 22 '22 14:10

cafekun