MS Local Report

    最近一个项目中,涉及到很多报表的开发,以前对水晶报表搞得比较熟,但它的庞大与其它诸多功能限制,特别是发布与部置时面临的困难,实在让人无法忍受(应该很少有人买得起正版吧),决定试一下MS Reporting Services,当然在这里只使用Local Report,对微软的Reporting Services进行了一番了解,蜡人张(http://www.cnblogs.com/waxdoll/category/49402.html)老兄这里有很多很好的学习材料,我也是从蜡人兄那里对自定义报表的研究得出以下部分修正的Demo.
    对于微软提供的ReportView控件,大家都知道,不能在其中对报表的边距等进行自定义,其工具条也是根本上无法自定义控制的,每次用户打印时,都必须对页面,边距等进行调整,对用户来说,这可能是一件无法忍受的事情,这或者是为满足Reporting Services报表而这样设计的.
对蜡人张老兄提供的例子做了一些改进,主要修正以下几点:
1,修正无法使用网络打印机进行打印的问题;
2,报表使用钳入式资源加载方式;
3,提取成一用户控件ReportView,更方便于开发人员将其整合到自己的项目中

Demo文件结构:


自定义报表控件ReportView源码分如下:

  1using System;
  2using System.Collections.Generic;
  3using System.ComponentModel;
  4using System.Drawing;
  5using System.Data;
  6using System.Text;
  7using System.Windows.Forms;
  8using System.IO;
  9using Microsoft.Reporting.WinForms;
 10namespace LocalReportDemo.Report
 11{
 12    public partial class ReportViewer : UserControl
 13    {
 14
 15        private EMFStreamPrintDocument printDoc;
 16
 17        /**//// <summary>
 18        /// 主报表名称
 19        /// </summary>
 20        private string m_ReportName = string.Empty;
 21        public string ReportName
 22        {
 23            get
 24            {
 25                return this.m_ReportName;
 26            }
 27            set
 28            {
 29                this.m_ReportName = value;
 30            }
 31        }
 32
 33        /**//// <summary>
 34        /// 主报表数据源
 35        /// </summary>
 36        private object m_MainDataSet = null;
 37        public object MainDataSet
 38        {
 39            get
 40            {
 41                return this.m_MainDataSet;
 42            }
 43            set
 44            {
 45                this.m_MainDataSet = value;
 46
 47            }
 48        }
 49
 50        /**//// <summary>
 51        /// 主报表数据源名称
 52        /// </summary>
 53        private string m_MainDataSourceName = string.Empty;
 54        public string MainDataSourceName
 55        {
 56            get
 57            {
 58                return this.m_MainDataSourceName;
 59            }
 60            set
 61            {
 62                this.m_MainDataSourceName = value;
 63            }
 64        } 
 65
 66        /**//// <summary>
 67        /// 钳入资源中的报表路径
 68        /// </summary>
 69        private string m_ReportEmbeddedResource;
 70        public string MReportEmbeddedResource
 71        {
 72            get
 73            {
 74                return m_ReportEmbeddedResource;
 75            }
 76            set
 77            {
 78                m_ReportEmbeddedResource = value;
 79            }
 80        }
 81
 82        /**//// <summary>
 83        /// 钻取报表数据源
 84        /// </summary>
 85        private object m_DrillDataSet = null;
 86        public object DrillDataSet
 87        {
 88            get
 89            {
 90                return this.m_DrillDataSet;
 91            }
 92            set
 93            {
 94                this.m_DrillDataSet = value;
 95            }
 96        }
 97        /**//// <summary>
 98        /// 钻取报表数据源名称
 99        /// </summary>
100        private string m_DrillDataSourceName = string.Empty;
101        public string DrillDataSourceName
102        {
103            get
104            {
105                return this.m_DrillDataSourceName;
106            }
107            set
108            {
109                this.m_DrillDataSourceName = value;
110            }
111        }
112
113        /**//// <summary>
114        /// 构造器
115        /// </summary>
116        public ReportViewer()
117        {
118            InitializeComponent();
119            this.Dock = System.Windows.Forms.DockStyle.Fill;
120        }
121
122        /**//// <summary>
123        /// 加载窗体事件
124        /// </summary>
125        /// <param name="sender"></param>
126        /// <param name="e"></param>
127        private void rpv1_Load(object sender, EventArgs e)
128        {
129        }
130        /**//// <summary>
131        /// 加载报表
132        /// </summary>
133        public  void BindReport()
134        {
135
136            System.Type type = this.MainDataSet.GetType();
137            if (this.m_MainDataSet == null)
138            {
139                MessageBox.Show("报表数据源不存在或为空!", "提醒对话框", MessageBoxButtons.OK, MessageBoxIcon.Information);
140                return;
141            }
142            if (type == null)
143            {
144                System.Windows.Forms.MessageBox.Show("报表数据源格式不正确!", "提醒对话框", MessageBoxButtons.OK, MessageBoxIcon.Information);
145                return;
146            }
147            else
148            {
149                System.Reflection.PropertyInfo[] picData = type.GetProperties();
150                bool bolExist = false;
151                foreach (System.Reflection.PropertyInfo piData in picData)
152                {
153                    if (piData.Name == "Tables")
154                    {
155                        bolExist = true;
156
157                        if (MainDataSourceName == string.Empty)
158                        {
159                            MessageBox.Show("报表数据源不存在或为空!", "提醒对话框", MessageBoxButtons.OK, MessageBoxIcon.Information);
160                            return;
161                        }
162
163                        this.rpv1.LocalReport.DataSources.Add(
164                            new Microsoft.Reporting.WinForms.ReportDataSource(this.MainDataSourceName,
165                            (piData.GetValue(this.MainDataSet, null) as System.Data.DataTableCollection)[0])
166                            );
167                        this.rpv1.LocalReport.ReportEmbeddedResource = this.MReportEmbeddedResource;
168                        this.rpv1.RefreshReport();
169                        this.lblTotal.Text = @"/" + (this.rpv1.LocalReport.GetTotalPages()+1).ToString();
170                        this.tbxPage.Text = "1";
171                        break;
172                    }
173                }
174
175                if (!bolExist)
176                {
177                    System.Windows.Forms.MessageBox.Show("报表数据源格式不正确!", "提醒对话框", MessageBoxButtons.OK, MessageBoxIcon.Information);
178                    return;
179                }
180            }
181        }
182
183        工具条事件#region 工具条事件
184
185        private void 打印设置ToolStripMenuItem_Click(object sender, EventArgs e)
186        {
187            frmPageSettings frm = new frmPageSettings(this.ReportName);
188            frm.ShowDialog();
189        }
190
191        private void 打印预ToolStripMenuItem_Click(object sender, EventArgs e)
192        {
193            if (this.printDoc == null)
194            {
195                this.printDoc = new EMFStreamPrintDocument(this.rpv1.LocalReport, this.ReportName);
196                if (this.printDoc.ErrorMessage != string.Empty)
197                {
198                    System.Windows.Forms.MessageBox.Show("系统异常:\r\n    " + this.printDoc.ErrorMessage,"警告对话框",MessageBoxButtons.OK,MessageBoxIcon.Warning);
199                    this.printDoc = null;
200                    return;
201                }
202            }
203
204            this.PreviewDialog.Document = this.printDoc;
205            this.PreviewDialog.ShowDialog();
206            this.printDoc = null;
207        }
208
209        private void 打印ToolStripMenuItem_Click(object sender, EventArgs e)
210        {
211            if (this.printDoc == null)
212            {
213                this.printDoc = new EMFStreamPrintDocument(this.rpv1.LocalReport, this.m_ReportName);
214                if (this.printDoc.ErrorMessage != string.Empty)
215                {
216                    System.Windows.Forms.MessageBox.Show("系统异常:\r\n    " + this.printDoc.ErrorMessage, "警告对话框", MessageBoxButtons.OK, MessageBoxIcon.Warning);
217                    this.printDoc = null;
218                    return;
219                }
220            }
221
222            this.printDoc.Print();
223            this.printDoc = null;
224        }
225
226        private void toolStripButton1_Click(object sender, EventArgs e)
227        {
228            this.rpv1.RefreshReport();
229        }
230
231        private void toolStripButton2_Click(object sender, EventArgs e)
232        {
233            this.rpv1.CancelRendering(0);
234        }
235
236        private void toolStripButton3_Click(object sender, EventArgs e)
237        {
238            if (this.rpv1.LocalReport.IsDrillthroughReport)
239                this.rpv1.PerformBack();
240        }
241
242        private void 导出为EXCELToolStripMenuItem_Click(object sender, EventArgs e)
243        {
244            Microsoft.Reporting.WinForms.Warning[] Warnings;
245            string[] strStreamIds;
246            string strMimeType;
247            string strEncoding;
248            string strFileNameExtension;
249
250            byte[] bytes = this.rpv1.LocalReport.Render("Excel", null, out strMimeType, out strEncoding, out strFileNameExtension, out strStreamIds, out Warnings);
251
252            string strFilePath = @"D:\" + this.GetTimeStamp() + ".xls";
253
254            using (System.IO.FileStream fs = new FileStream(strFilePath, FileMode.Create))
255            {
256                fs.Write(bytes, 0, bytes.Length);
257            }
258
259            if (System.Windows.Forms.MessageBox.Show("数据成功导出:" + strFilePath + "\r\n    打开文件" + strFilePath + "吗?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
260            {
261                System.Diagnostics.Process.Start(strFilePath);
262            }
263        }
264        /**//// <summary>
265        /// 得到系统TimeStamp
266        /// </summary>
267        /// <returns></returns>
268        private string GetTimeStamp()
269        {
270            string strRet = string.Empty;
271            System.DateTime dtNow = System.DateTime.Now;
272            strRet += dtNow.Year.ToString() +
273                        dtNow.Month.ToString("00") +
274                        dtNow.Day.ToString("00") +
275                        dtNow.Hour.ToString("00") +
276                        dtNow.Minute.ToString("00") +
277                        dtNow.Second.ToString("00") +
278                        System.DateTime.Now.Millisecond.ToString("000");
279            return strRet;
280
281        }
282
283        private void toolStripMenuItem2_Click(object sender, EventArgs e)
284        {
285            this.rpv1.ZoomMode = ZoomMode.Percent;
286            this.rpv1.ZoomPercent = 25;
287        }
288
289        private void toolStripMenuItem3_Click(object sender, EventArgs e)
290        {
291            this.rpv1.ZoomMode = ZoomMode.Percent;
292            this.rpv1.ZoomPercent = 50;
293        }
294
295        private void toolStripMenuItem5_Click(object sender, EventArgs e)
296        {
297            this.rpv1.ZoomMode = ZoomMode.Percent;
298            this.rpv1.ZoomPercent = 100;
299        }
300
301        private void toolStripMenuItem6_Click(object sender, EventArgs e)
302        {
303            this.rpv1.ZoomMode = ZoomMode.Percent;
304            this.rpv1.ZoomPercent = 200;
305        }
306
307        private void toolStripMenuItem7_Click(object sender, EventArgs e)
308        {
309            this.rpv1.ZoomMode = ZoomMode.Percent;
310            this.rpv1.ZoomPercent = 400;
311        }
312
313        private void 整页ToolStripMenuItem_Click(object sender, EventArgs e)
314        {
315            this.rpv1.ZoomMode = ZoomMode.FullPage;
316        }
317
318        private void 页宽度ToolStripMenuItem_Click(object sender, EventArgs e)
319        {
320            this.rpv1.ZoomMode = ZoomMode.PageWidth;
321        }
322
323        private void toolStripButton4_Click(object sender, EventArgs e)
324        {
325            if (this.tbxFind.Text.Trim() == string.Empty)
326                return;
327            this.rpv1.Find(this.tbxFind.Text.Trim(), 1);
328        }
329
330        private void toolStripButton5_Click(object sender, EventArgs e)
331        {
332            if (this.tbxFind.Text.Trim() == string.Empty)
333                return;
334            this.rpv1.FindNext();
335        }
336
337        private void toolStripButton9_Click(object sender, EventArgs e)
338        {
339            this.rpv1.CurrentPage = 1;
340            this.tbxPage.Text = "1";
341        }
342
343        private void toolStripButton6_Click(object sender, EventArgs e)
344        {
345            this.rpv1.CurrentPage = this.rpv1.LocalReport.GetTotalPages();
346            this.tbxPage.Text = this.rpv1.LocalReport.GetTotalPages().ToString();
347        }
348        private void toolStripButton8_Click(object sender, EventArgs e)
349        {
350            if (this.rpv1.CurrentPage != 1)
351            {
352                this.rpv1.CurrentPage--;
353                this.tbxPage.Text = Convert.ToString(Convert.ToInt32(this.tbxPage.Text) - 1);
354            }
355        }
356
357        private void toolStripButton7_Click(object sender, EventArgs e)
358        {
359            if (this.rpv1.CurrentPage != this.rpv1.LocalReport.GetTotalPages())
360            {
361                this.rpv1.CurrentPage++;
362                this.tbxPage.Text = Convert.ToString(Convert.ToInt32(this.tbxPage.Text) +1);
363            }
364        }
365
366
367        #endregion 
368
369        /**//// <summary>
370        /// 钻取报表事件
371        /// </summary>
372        /// <param name="sender"></param>
373        /// <param name="e"></param>
374        private void rpv1_Drillthrough(object sender, DrillthroughEventArgs e)
375        {
376            if (DrillDataSet == null)
377            {
378                MessageBox.Show("报表数据源不存在或为空!", "提醒对话框", MessageBoxButtons.OK, MessageBoxIcon.Information);
379                return;
380            }
381            else
382            {
383                if (this.DrillDataSourceName == string.Empty)
384                {
385                    System.Windows.Forms.MessageBox.Show("报表数据源格式不正确!", "提醒对话框", MessageBoxButtons.OK, MessageBoxIcon.Information);
386                    return;
387                }
388                else
389                {
390                    Microsoft.Reporting.WinForms.LocalReport report = e.Report as Microsoft.Reporting.WinForms.LocalReport;
391                    report.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource(this.DrillDataSourceName, this.GetTableCollection(this.DrillDataSet)[0]));
392                }
393            }
394        }
395        private System.Data.DataTableCollection GetTableCollection(object ReportSource)
396        {
397            System.Type type = ReportSource.GetType();
398
399            if (type == null)
400            {
401               MessageBox.Show("报表数据源格式不正确!", "提醒对话框", MessageBoxButtons.OK, MessageBoxIcon.Information);
402                return null;
403            }
404            else
405            {
406                System.Reflection.PropertyInfo[] picData = type.GetProperties();
407                bool bolExist = false;
408                foreach (System.Reflection.PropertyInfo piData in picData)
409                {
410                    if (piData.Name == "Tables")
411                    {
412                        bolExist = true;
413                        return piData.GetValue(ReportSource, null) as System.Data.DataTableCollection;
414                    }
415                }
416
417                if (!bolExist)
418                {
419                    MessageBox.Show("报表数据源格式不正确!", "提醒对话框", MessageBoxButtons.OK, MessageBoxIcon.Information);
420                    return null;
421                }
422            }
423            return null;
424        }
425    }
426}
427

报表宿主窗口加载报表与数据源的方法:

1 DataSet ds = new DataSet();
2            ds.ReadXml(Application.StartupPath + @"\DataSource.xml");
3            this.reportViewer1.MainDataSet = ds;//报表主数据源
4            this.reportViewer1.MainDataSourceName = "ReportDemoDataSet_ReportDemoTable";//数据源名称
5            this.reportViewer1.MReportEmbeddedResource = "LocalReportDemo.ReportDemo.rdlc";//钳入资源的报表路径
6            this.reportViewer1.ReportName = "ReportDemo";//报表名称
7            this.reportViewer1.BindReport();//加载挷定报表

数据源名称如下图所示:


其中钳入资源的报表路径中,LocalReportDemo为报表钳入的程序集名称

报表格式配置文件ReportSettings.xml:

 1<?xml version="1.0" standalone="yes"?>
 2<ReportSettings>
 3  <ReportDemo>
 4    <ReportName>ReportDemo</ReportName>
 5    <PrinterName>Microsoft Office Document Image Writer</PrinterName>
 6    <PaperName>A4</PaperName>
 7    <PageWidth>21.01</PageWidth>
 8    <PageHeight>29.69</PageHeight>
 9    <MarginTop>0.5</MarginTop>
10    <MarginBottom>0.2</MarginBottom>
11    <MarginLeft>2.3</MarginLeft>
12    <MarginRight>0.2</MarginRight>
13    <Orientation>Z</Orientation>
14  </ReportDemo>
15</ReportSettings>

此Demo运行效果:


打印预览:


有任何问题欢迎在此提出,大家共同讨论解决

此Demo完整代码下载:
/Files/mshwu/LocalReportDemo.rar