Transforming a SSRS(RDLC) Report report output to Excel format

Download

Introduction

Objective

   <form id="form1" runat="server">
    <div>
    
        <br />
        &nbsp;<asp:Button ID="Button2" runat="server" onclick="Button2_Click" 
            Text="Export2Excel" />
        <br />
    
        <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" ShowExportControls="false" 
            Font-Size="8pt" Height="400px" Width="100%">
            <LocalReport ReportPath="Report1.rdlc">
                <DataSources>
                    <rsweb:ReportDataSource DataSourceId="ObjectDataSource1" 
                        Name="DataSet1_Employees" />
                </DataSources>
            </LocalReport>
        </rsweb:ReportViewer>
        <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" 
            SelectMethod="GetDataItem" TypeName="RDLC_webApplication1._Default">
        </asp:ObjectDataSource>
    
    </div>
    </form>                                                                          

// Code Behind                                                                     
public partial class _Default : System.Web.UI.Page
    {

        string connn = ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ToString();

        protected void Page_Load(object sender, EventArgs e)
        {
          
            if (!Page.IsPostBack)
            {
                getData();
            }
        }

        protected void getData()
        {

       SqlDataAdapter da = new SqlDataAdapter("select top 20 * from Employees", connn);
            DataSet ds = new DataSet();
            da.Fill(ds);

            ReportDataSource rdc = new ReportDataSource("DataSet1_Employees", ds.Tables[0]);
            ReportViewer1.LocalReport.DataSources.Clear();
            ReportViewer1.LocalReport.DataSources.Add(rdc);
            ReportViewer1.Visible = true;
            ReportViewer1.LocalReport.Refresh();
        }
    }                                                                                //To generate Excel file                                                              protected void Button2_Click(object sender, EventArgs e)
    {

        Response.Clear();
        Microsoft.Reporting.WebForms.Warning[] warnings = null;
        string[] streamids = null;
        String mimeType = null;
        String encoding = null;
        String extension = null;
        Byte[] bytes = null;

        bytes = ReportViewer1.LocalReport.Render("Excel", null, out mimeType, out encoding, out extension, out streamids, out warnings);
        Response.Clear();
        Response.Buffer = true;
        Response.Clear();

        Response.AddHeader("Content-Disposition", "attachment; filename=abc.xls");
        Response.AddHeader("Content-Length", bytes.Length.ToString());
        Response.BinaryWrite(bytes);
        Response.End();
    }  

 When user clicks on Export2Excel ,the following screen asks to open or save the file to physical location.

Conclusion

In this way an Excel file  can be created manually  from SSRS- RDLC Report output. 

If you like this article, subscribe to our RSS Feed. You can also subscribe via email to our Interview Questions, Codes and Forums section.