How to allow Export to Excel only in RDLC ?? (NO Word/PDF)

Reply

jalali

Member

24 Points

71 Posts

How to allow Export to Excel only in RDLC ?? (NO Word/PDF)

Dec 10, 2018 09:04 AM|jalali|LINK

Hi Friends,

I want my RDLC report report to Allow export only Excel Reports. I found this code on internet. Unfortunately. It hides only PDF not the WORD can anyone help me?

 <asp:Panel ID="pnlReport" runat="server" Visible="false" >
                       <rsweb:ReportViewer  Font-Names="DIN Next LT Arabic Light" ID="EventsReportByPeriod" runat="server"  Height="1190px" Width="100%" Visible="true" onload="ReportViewer_OnLoad" ShowPrintButton="False" ShowPromptAreaButton="False" ZoomMode="FullPage" ></rsweb:ReportViewer>
                 </asp:Panel>

 protected void ReportViewer_OnLoad(object sender, EventArgs e)
        {


            string[] exportOption = new string[] { "Word", "PDF" };


            foreach (var item in exportOption)
            {
                RenderingExtension extension = EventsReportByPeriod.LocalReport.ListRenderingExtensions().ToList().Find(x => x.Name.Equals(item, StringComparison.CurrentCultureIgnoreCase));
                if (extension != null)
                {
                    System.Reflection.FieldInfo fieldInfo = extension.GetType().GetField("m_isVisible", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic);
                    fieldInfo.SetValue(extension, false);
                }
            }
        }

Reply

Brando ZWZ

Star

9801 Points

3120 Posts

Re: How to allow Export to Excel only in RDLC ?? (NO Word/PDF)

Dec 11, 2018 05:20 AM|Brando ZWZ|LINK

Hi jalali

According to your description , I have made a sample here.You can achieve your requirement by editing OnPreRender Event .Here is the code ,I hope it will help you.

Test.aspx:

<head runat="server">
    <title></title>

   
</head>
<body>
     
    <form id="form1" runat="server">
        <asp:Panel ID="pnlReport" runat="server"  >
             <asp:ScriptManager runat="server"></asp:ScriptManager>         
                       <rsweb:ReportViewer Font-Names="DIN Next LT Arabic Light" ID="EventsReportByPeriod" runat="server"  Height="1190px" Width="100%" OnPreRender="EventsReportByPeriod_PreRender" ShowPrintButton="False" ShowPromptAreaButton="False" InteractivityPostBackMode="AlwaysSynchronous"  ZoomMode="FullPage" BackColor="" ClientIDMode="AutoID" HighlightBackgroundColor="" InternalBorderColor="204, 204, 204" InternalBorderStyle="Solid" InternalBorderWidth="1px" LinkActiveColor="" LinkActiveHoverColor="" LinkDisabledColor="" PrimaryButtonBackgroundColor="" PrimaryButtonForegroundColor="" PrimaryButtonHoverBackgroundColor="" PrimaryButtonHoverForegroundColor="" SecondaryButtonBackgroundColor="" SecondaryButtonForegroundColor="" SecondaryButtonHoverBackgroundColor="" SecondaryButtonHoverForegroundColor="" SplitterBackColor="" ToolbarDividerColor="" ToolbarForegroundColor="" ToolbarForegroundDisabledColor="" ToolbarHoverBackgroundColor="" ToolbarHoverForegroundColor="" ToolBarItemBorderColor="" ToolBarItemBorderStyle="Solid" ToolBarItemBorderWidth="1px" ToolBarItemHoverBackColor="" ToolBarItemPressedBorderColor="51, 102, 153" ToolBarItemPressedBorderStyle="Solid" ToolBarItemPressedBorderWidth="1px" ToolBarItemPressedHoverBackColor="153, 187, 226" >
                           
                           <LocalReport ReportPath="Report1.rdlc">
                               <DataSources>
                                   <rsweb:ReportDataSource DataSourceId="ObjectDataSource1" Name="DataSet1" />
                               </DataSources>
                           </LocalReport>
                           
                       </rsweb:ReportViewer>
                     
                 <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetData" TypeName="Demo.MyDatabase2DataSetTableAdapters.CityTableAdapter"></asp:ObjectDataSource>
                     
           
                 </asp:Panel>

     
    </form>
</body>

Code-behind:

public partial class WebForm7 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }
      

        protected void EventsReportByPeriod_PreRender(object sender, EventArgs e)
        {
  foreach (RenderingExtension extension in EventsReportByPeriod.LocalReport.ListRenderingExtensions())
            {
                if (extension.Name == "IMAGE" || extension.Name == "WORDOPENXML" || extension.Name == "PDF")
                {
                    FieldInfo fi = extension.GetType().GetField("m_isVisible", BindingFlags.Instance | BindingFlags.NonPublic);
                    fi.SetValue(extension, false);
                }
            }

        }
    }

Result:

Best Regards,

Brando

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

Reply

jalali

Member

24 Points

71 Posts

Re: How to allow Export to Excel only in RDLC ?? (NO Word/PDF)

Dec 11, 2018 01:24 PM|jalali|LINK

Work like a charm!! Thanks!!

How to allow Export to Excel only in RDLC ?? (NO Word/PDF) [Answered]RSS

2 replies

Shortcuts

How to allow Export to Excel only in RDLC ?? (NO Word/PDF)

Re: How to allow Export to Excel only in RDLC ?? (NO Word/PDF)

Re: How to allow Export to Excel only in RDLC ?? (NO Word/PDF)