Disable the Excel export option when I generate a report via the ReportViewer

Question

How can I disable the Excel export option when I generate a report, via the ReportViewer, in my winforms application?

ADDITION: In particular, I want to hide the toolbar button that refers to Excel output/export task, and not .the one that handles to the pdf export option.

Here is another question that I found helpful: http://stackoverflow.com/questions/1499885/reportviewer-hide-pdf-export — Garry English, Jan 22 '13 at 02:03

score 4 · Answer 1 · answered Jun 21 '13 at 21:36

This will accomplish what the poster asked (uses a little LINQ for selecting objects of certain types from collections):

    private void DisableReportViewerExportExcel()
    {
        var toolStrip = this.ReportViewer.Controls.Find("toolStrip1", true)[0] as ToolStrip;

        if (toolStrip != null)
            foreach (var dropDownButton in toolStrip.Items.OfType<ToolStripDropDownButton>())
                dropDownButton.DropDownOpened += new EventHandler(dropDownButton_DropDownOpened);
    }

    void dropDownButton_DropDownOpened(object sender, EventArgs e)
    {
        if (sender is ToolStripDropDownButton)
        {
            var ddList = sender as ToolStripDropDownButton;
            foreach (var item in ddList.DropDownItems.OfType<ToolStripDropDownItem>())
                if (item.Text.Contains("Excel"))
                    item.Enabled = false;
        }
    }

Works well in win forms. Thank you. – Mohsen May 08 '18 at 03:12 — Mohsen, May 08 '18 at 03:12

score 2 · Accepted Answer · answered Apr 27 '10 at 23:28

While on the face of it this seems easy, the export options are difficult to get hold of. You can get the toolstrip of the reportviewer by simply doing this:

Dim myToolStrip As ToolStrip = DirectCast(ReportViewer1.Controls.Find("toolStrip1", True)(0), ToolStrip)

...and you can iterate through the .Items collection to do what you like with the buttons, however the DropDownItems collection for the export button always appears empty.

So the easy solution is to get rid of the default export button and add your own with just the functionality you need. So in your form constructor:

//Hide the default export button
ReportViewer1.ShowExportButton = False

//Define a new button
Dim newExportButton As New ToolStripButton("Export PDF", Nothing, AddressOf Me.ExportPDF, "newExport")

//And add it to the toolstrip
DirectCast(ReportViewer1.Controls.Find("toolStrip1", True)(0), ToolStrip).Items.Add(newExportButton)

Then all you need to do is to take care of the actual exporting:

Private Sub ExportPDF()

    Dim warnings As Microsoft.Reporting.WinForms.Warning()
    Dim streamids As String()
    Dim mimeType As String = ""
    Dim encoding As String = ""
    Dim extension As String = ""

    Dim bytes As Byte() = ReportViewer1.LocalReport.Render("PDF", Nothing, mimeType, encoding, extension, streamids, warnings)

    Dim fs As New IO.FileStream("C:\export.pdf", IO.FileMode.Create)
    fs.Write(bytes, 0, bytes.Length)
    fs.Close()
    fs.Dispose()

End Sub

I don't know if it works, I'll try it soon, but you deserve to be voted as the answer to my question. Thanks for the effort. — , Apr 29 '10 at 13:00
No probs. Let me know if you have trouble with it, as it works fine for me here. — Ira Rainey, Apr 30 '10 at 07:57

score 1 · Answer 3 · edited Nov 28 '11 at 00:37

//Call This function from Page_Load Event
private void CustomizeRV(System.Web.UI.Control reportControl)
{
    foreach (System.Web.UI.Control childControl in reportControl.Controls)
    {
        if (childControl.GetType() == typeof(System.Web.UI.WebControls.DropDownList)) 
        { 
            System.Web.UI.WebControls.DropDownList ddList = (System.Web.UI.WebControls.DropDownList)childControl;
            ddList.PreRender += new EventHandler(ddList_PreRender); 
        }
        if (childControl.Controls.Count > 0) 
        { 
            CustomizeRV(childControl); 
        } 
    }
}

//Dropdown prerender event
//You can hide any option from ReportViewer( Excel,PDF,Image )   
void ddList_PreRender(object sender, EventArgs e)
{
    if (sender.GetType() == typeof(System.Web.UI.WebControls.DropDownList))
    {
        System.Web.UI.WebControls.DropDownList ddList = (System.Web.UI.WebControls.DropDownList)sender; 
        System.Web.UI.WebControls.ListItemCollection listItems = ddList.Items;

        if ((listItems != null) && (listItems.Count > 0) && (listItems.FindByText("Excel") != null))
        {
            foreach (System.Web.UI.WebControls.ListItem list in listItems)
            {
                if (list.Text.Equals("Excel"))
                {
                    list.Enabled = false;
                }
            }
        }
    }
}

the question was for windows forms report viewer, not web – redtetrahedron Jun 21 '13 at 21:17 — redtetrahedron, Jun 21 '13 at 21:17

score -2 · Answer 4 · answered Apr 19 '10 at 19:28

-2

Please try this:

Dim instance As ReportViewer

instance.ShowExportButton = false

HTH

answered Apr 19 '10 at 19:28

Raja

3,608
3
28
39

Thanks for the response. However, this code will disable both Excel AND 'pdf' export. I want to be able to export only pdf files. I want to hide the button that refers to Excel export, and not the one using the pdf option... – Apr 19 '10 at 19:45
Yes. this code will disable both Excel and Pdf export. But user can select a pdf creator from the print window when he/she clicks on print button. – Mohsen May 07 '18 at 08:02

Disable the Excel export option when I generate a report via the ReportViewer

4 Answers4