RDL和RDLC使用ReportViewer显示报表时筛选导出项

最新推荐文章于 2018-11-08 16:09:01 发布

even0220

最新推荐文章于 2018-11-08 16:09:01 发布

阅读量4.4k

点赞数

分类专栏： Report 微软报表 RDL RDLC 文章标签：报表 extension microsoft excel object image

本文链接：https://blog.csdn.net/even0220/article/details/6960540

版权

RDLC 同时被 3 个专栏收录

7 篇文章 1 订阅

订阅专栏

Report

3 篇文章 1 订阅

订阅专栏

微软报表

1 篇文章 0 订阅

订阅专栏

RDL和RDLC在筛选导出项时有区别！

RDLC:需要在ReportViewer的PreRender方法中处理即可。

HTML:

 <rsweb:ReportViewer ID="rpvReportDL" runat="server" Width="973px" 
    Height="470px" onprerender="reportViewer_PreRender">
    </rsweb:ReportViewer>

CODE:

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

RDL：修改配置文件

File: Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\RSReportDesigner.config

别忘记重启 Reporting Services

Enabled:

<Extension Name="EXCEL" 
Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>

Disabled:

<Extension Name="EXCEL" 
Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" 
Visible="false"/>