RDLC - Export Directly to Word, Excel or PDF from Code

• Download source - 239.7 KB

Introduction

Sometimes, we have a requirement to directly export data in WORD, EXCEL or PDF format. In this tip, we will create a sample report and export it directly to Word, Excel or PDF format without using report viewer toobar.

Using the Code

After you add a new DataSet and create a table inside this DataSet that contains all your columns name and datatype, then I create DataTable method that returns a new DataTable with all my data like this one:

private DataTable Data()
        {
            var dataTable = new DataTable("Data");

            dataTable.Columns.Add("Id", typeof(int));
            dataTable.Columns.Add("Name", typeof(string));
            dataTable.Columns.Add("Gender", typeof(string));
            dataTable.Columns.Add("Age", typeof(int));

            dataTable.Rows.Add(1000, "Ahmed", "Male", 22);
            dataTable.Rows.Add(1001, "Mohammed", "Male", 25);
            dataTable.Rows.Add(1002, "Hassan", "Male", 41);
            dataTable.Rows.Add(1003, "Abdullah", "Male", 19);
            dataTable.Rows.Add(1004, "Maryam", "Female", 21);

            return dataTable;
        }

After that, I create a void method that initials my report:

void InitialReport()
        {
            try
            {
                var ds = Data();

                // this is my Local DataSet :
                var myDataSet = new ReportingDataSet();
                
                // merge data with "Data()" method and MyDataSet Table :
                myDataSet.Tables["Data"].Merge(ds);

                ReportDataSource rdsR = new ReportDataSource("Data", myDataSet.Tables["Data"]);

                this.ReportViewer.LocalReport.DataSources.Clear();
                this.ReportViewer.LocalReport.DataSources.Add(rdsR);
                this.ReportViewer.LocalReport.Refresh();
                
                //set zoom mode to PageWidth :
                this.ReportViewer.ZoomMode = ZoomMode.PageWidth;
                this.ReportViewer.RefreshReport();
            }
            catch (Exception x)
            {
                MessageBox.Show(x.Message);
            }
        }

Now, I create a delegate method and void method to Export report to Word, Excel or PDF format, this method gets all RederingExtension from Report sheet, but I need just (Excel, Word, PDF rendering extension). Before that, I add tags value to the 3 buttons and the 3 buttons are Sets Visible to False by default and I use another button Named Export to show or hide the 3 buttons:

        private void export_btn_Click(object sender, EventArgs e)
        {
            excel_btn.Visible = word_btn.Visible = pdf_btn.Visible = !excel_btn.Visible;
        }

        private delegate void ExportTo(object sender);

        private void ExportToFile(object sender)
        {
            try
            {
                var x = ReportViewer.LocalReport.ListRenderingExtensions();
                RenderingExtension render_ = null;

                var obj = (sender as Button);

                switch (obj.Tag.ToString())
                {
                    case "word":
                        render_ = x[5];
                        break;
                    case "excel":
                        render_ = x[1];
                        break;
                    case "pdf":
                        render_ = x[3];
                        break;
                }
                if (render_ != null)
                {
                    var DialogResult = ReportViewer.ExportDialog(render_);
                    if (DialogResult == DialogResult.OK)
                        MessageBox.Show("Done!");
                }
            }
            catch (Exception x)
            {
                MessageBox.Show(x.Message);
            }
        }

Then, I create an Event method for my 3 export buttons:

        private void Exporting(object sender, EventArgs e)
        {
            ReportViewer.Invoke(new ExportTo(ExportToFile), new object[] { sender });
        }

Execution:

Export to PDF - Word - Excel:

END !