.Net下动态报表生成实现（一）

川长思鸟来 2021-12-24 15:05 234阅读 0赞

引用：[海风吹的专栏][Link 1]

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][] Code   
![None.gif][]在做报表项目时,有时不仅要满足用户的需求,而且要求软件要有一定的适应性,这就往往就要求报表要动态地生成.  
![None.gif][] 最近在做一个项目时,就碰到这样子的问题.系统要在不现的地区使用,不同的地区下属单位是不一样的,而报表中有列就是显示下属单位的某一属性的.因而报表中的这一项不公名称不能确定,数目也不能定.所以它要求在生成过程中动态地改变报表中的格式.  
![None.gif][] 这个项目是用.NET的C\#开发的,报表用微软的RDLC模板报表.  
![None.gif][] RDLC 是用XML文档定义报表格式,这样就很容易想到通过更改XML文档元素内容来实现这一需求.  
![None.gif][] 报表中实现了多列表头以及向报表中动态添加列增加参数据等内容.  
![None.gif][] 使用方法：  
![None.gif][]　　 privatevoid ProressAllXiangZhen()  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][]![dot.gif][]\{　  
![InBlock.gif][]　　　　　　 　string sql =null;  
![InBlock.gif][]string filename = Application.StartupPath \+"\\\\ChecksMonthAll.rdlc";//报表定义文件地址  
![InBlock.gif][] ReportXml Rex =new ReportXml(destname);//创建XML操作对象  
![InBlock.gif][] XiangZhenEx xz =new XiangZhenEx();//强类型数据集  
![InBlock.gif][] xz = (new XiangZhenBL()).GetAllXiangZhen();  
![InBlock.gif][]//根据数据表值，修改报表格式  
![InBlock.gif][]foreach (DataRow row in xz.\_XiangZhen.Rows)//每镇增加两列当月所得及年累计值  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]![dot.gif][]\{  
![InBlock.gif][]  
![InBlock.gif][]string code = row\["code"\].ToString();  
![InBlock.gif][]string name = row\["name"\].ToString();  
![InBlock.gif][]//系统提示  
![InBlock.gif][] UpStatus(string.Format("设置乡镇\{0\}报表格式![dot.gif][]", name));  
![InBlock.gif][]//增加参数  
![InBlock.gif][] Rex.AddParamter("Params"\+ code, "String", name);  
![InBlock.gif][]//增加字段  
![InBlock.gif][] Rex.AddDataSetColumn("Month\_"\+ code \+"Region", "System.Decimal");  
![InBlock.gif][] Rex.AddTableColumn("2.5cm");  
![InBlock.gif][] Rex.AddDataSetColumn("Year\_"\+ code \+"Region", "System.Decimal");  
![InBlock.gif][] Rex.AddTableColumn("2.5cm");  
![InBlock.gif][]//增加表头第一行，跨列居中  
![InBlock.gif][] Rex.AddTableHaderFirstRowCell("Heade"\+ code \+"01", String.Format("=Parameters!\{0\}.Value", "Params"\+ code));  
![InBlock.gif][]//增加表头第二行，加两列与上对齐  
![InBlock.gif][] Rex.AddTableHaderSecondRowCell("Heade"\+ code \+"0101", "当月");  
![InBlock.gif][] Rex.AddTableHaderSecondRowCell("Heade"\+ code \+"0102", "全年");  
![InBlock.gif][]//增加详细数据行列  
![InBlock.gif][] Rex.AddDetailsCell("Detail"\+ code \+"01", String.Format("=Fields!\{0\}.Value", "Month\_"\+ code \+"Region"));  
![InBlock.gif][] Rex.AddDetailsCell("Detail"\+ code \+"02", String.Format("=Fields!\{0\}.Value", "Year\_"\+ code \+"Region"));  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][] sql \+=","\+ String.Format("dbo.Get\_Month\_Region('\{0\}',\{1\},\{2\},shui\_code,\{3\}) as \\"![dot.gif][]\{ 4\}\\"", code, m\_year, m\_month, m\_item2, "Month\_"\+ code \+"Region");  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][] sql \+=","\+ String.Format("dbo.Get\_Year\_Region('\{0\}',\{1\},\{2\},shui\_code,\{3\}) as \\"![dot.gif][]\{ 4\}\\"", code, m\_year, m\_month, m\_item2, "Year\_"\+ code \+"Region");  
![InBlock.gif][]if (row\["name"\].ToString() =="市直"|| row\["name"\].ToString() =="县直") AddXiangZhenHeJi(Rex, xz.\_XiangZhen.Rows);  
![ExpandedSubBlockEnd.gif][] \}  
![InBlock.gif][] UpStatus("调整报表宽度![dot.gif][]");  
![InBlock.gif][] Int32 width = (xz.\_XiangZhen.Rows.Count\+1) \*5;  
![InBlock.gif][] Rex.EditPageHeaderTb28Width(width);  
![InBlock.gif][] Rex.EditPageHeaderTb29Left(width);  
![InBlock.gif][] Rex.EditPageFooterLineWidth("line1", width);  
![InBlock.gif][] Rex.EditPageFooterLineWidth("line2", width);  
![InBlock.gif][] sql =string.Format("select acctname,sum(money)money,bili,sum(country\_get)country\_get,"  
![InBlock.gif][]\+"sum(province\_get)province\_get,sum(region\_get)region\_get,"  
![InBlock.gif][]\+"shui\_code "\+ sql \+" from v\_report\_month\_allzhen where "  
![InBlock.gif][]\+"year=\{0\} and month=\{1\} and item IN(\{2\})"  
![InBlock.gif][]\+" group by shui\_code,bili,acctname", m\_year, m\_month, m\_item);  
![InBlock.gif][] System.Diagnostics.Debug.WriteLine(sql);  
![InBlock.gif][] UpStatus(string.Format("正在取此数据，大概需要2-3分钟"));  
![InBlock.gif][] ReportBl BL =new ReportBl();  
![InBlock.gif][] DataSet re = BL.GetMonthReport(sql);  
![InBlock.gif][] UpStatus("已经取得数据，正在加载报表数据![dot.gif][]");  
![InBlock.gif][]this.reportViewer.ProcessingMode = ProcessingMode.Local;  
![InBlock.gif][]this.reportViewer.LocalReport.DataSources.Clear();  
![InBlock.gif][] Microsoft.Reporting.WinForms.ReportDataSource RD =new Microsoft.Reporting.WinForms.ReportDataSource("ReportDT\_v\_report\_month", re.Tables\[0\]);  
![InBlock.gif][]this.reportViewer.LocalReport.DataSources.Add(RD);  
![InBlock.gif][] ReportParameter\[\] cc =new ReportParameter\[xz.\_XiangZhen.Rows.Count \+4\];  
![InBlock.gif][]for (int i =0; i < xz.\_XiangZhen.Rows.Count; i\++)//每镇增加两列当月所得及年累计值  
![ExpandedSubBlockStart.gif][]![ContractedSubBlock.gif][]![dot.gif][]\{  
![InBlock.gif][] DataRow row = xz.\_XiangZhen.Rows\[i\];  
![InBlock.gif][]string code = row\["code"\].ToString();  
![InBlock.gif][]string name = row\["name"\].ToString();  
![InBlock.gif][] cc\[i\] =new ReportParameter("Params"\+ code, name);  
![ExpandedSubBlockEnd.gif][] \}  
![InBlock.gif][] UpStatus("设置报表参数");  
![InBlock.gif][]this.reportViewer.LocalReport.ReportPath = destname;  
![InBlock.gif][] cc\[xz.\_XiangZhen.Rows.Count\] =new ReportParameter("dwmc", "全县");  
![InBlock.gif][] cc\[xz.\_XiangZhen.Rows.Count \+1\] =new ReportParameter("date", string.Format("\{0\}年\{1\}月", m\_year, m\_month));  
![InBlock.gif][] cc\[xz.\_XiangZhen.Rows.Count \+2\] =new ReportParameter("shou\_item", m\_item.Replace('\\'', '').Replace(',', '、'));  
![InBlock.gif][] cc\[xz.\_XiangZhen.Rows.Count \+3\] =new ReportParameter("Params100", "乡镇小计");  
![InBlock.gif][]this.reportViewer.LocalReport.SetParameters(cc);  
![InBlock.gif][] UpStatus("就绪");  
![InBlock.gif][]this.reportViewer.RefreshReport();  
![InBlock.gif][]  
![InBlock.gif][]  
![ExpandedBlockEnd.gif][] \}  
![None.gif][] 类代码示例(报表操作类ReportXML源码):  
![None.gif][]public ReportXml(string filename)  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][]![dot.gif][]\{  
![InBlock.gif][]this.filename = filename;  
![InBlock.gif][] doc =new XmlDocument();  
![InBlock.gif][] doc.Load(filename);  
![InBlock.gif][] root = doc.DocumentElement;  
![InBlock.gif][] xnm=new XmlNamespaceManager(doc.NameTable);  
![InBlock.gif][] xnm.AddNamespace("rd", "http://schemas.microsoft.com/SQLServer/reporting/reportdesigner");  
![InBlock.gif][] xnm.AddNamespace("default", "http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition");  
![InBlock.gif][] xnm.PushScope();  
![InBlock.gif][] xpathdoc =new XPathDocument(filename);  
![InBlock.gif][] xnv = xpathdoc.CreateNavigator();  
![InBlock.gif][]  
![ExpandedBlockEnd.gif][] \}  
![None.gif][]private XmlNode CreateNode( string nodename, string innertext)  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][]![dot.gif][]\{  
![InBlock.gif][] XmlNode node =null;  
![InBlock.gif][] node = doc.CreateNode(XmlNodeType.Element, nodename, "http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition");  
![InBlock.gif][] node.InnerText = innertext;  
![InBlock.gif][]return node;  
![ExpandedBlockEnd.gif][] \}  
![None.gif][]private XmlNode CreateNode(string nodename)  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][]![dot.gif][]\{  
![InBlock.gif][] XmlNode node =null;  
![InBlock.gif][] node = doc.CreateNode(XmlNodeType.Element, nodename, "http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition");  
![InBlock.gif][]return node;  
![ExpandedBlockEnd.gif][] \}  
![None.gif][]publicvoid AddParamter(string name, string type, string prompt)  
![ExpandedBlockStart.gif][]![ContractedBlock.gif][]![dot.gif][]\{  
![InBlock.gif][] XmlNode node =null;  
![InBlock.gif][] XmlNode refCd = root.SelectSingleNode("//default:ReportParameters", xnm);  
![InBlock.gif][] XmlElement docFrag = doc.CreateElement("ReportParameter", "http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition");  
![InBlock.gif][] docFrag.SetAttribute("Name",name);  
![InBlock.gif][] node = doc.CreateNode(XmlNodeType.Element, "DataType", "http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition");  
![InBlock.gif][] node.InnerText = type;  
![InBlock.gif][] docFrag.AppendChild(node);  
![InBlock.gif][] node = doc.CreateNode(XmlNodeType.Element, "Nullable", "http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition");  
![InBlock.gif][] node.InnerText ="true";  
![InBlock.gif][] docFrag.AppendChild(node);  
![InBlock.gif][] node = doc.CreateNode(XmlNodeType.Element, "Prompt", "http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition");  
![InBlock.gif][] node.InnerText = prompt;  
![InBlock.gif][] docFrag.AppendChild(node);  
![InBlock.gif][] refCd.InsertAfter(docFrag, refCd.LastChild);  
![InBlock.gif][] doc.Save(filename);  
![InBlock.gif][]  
![ExpandedBlockEnd.gif][] \}  
![None.gif][](未完)  
![None.gif][] 实现的效果图(1):  
![None.gif][]

实现的效果图(1):

![示样][E7_A4_BA_E6_A0_B7.gif]

转载于:https://www.cnblogs.com/hubcarl/archive/2009/05/05/1449609.html

[Link 1]: http://blog.csdn.net/XiaoGuiPian1916/
[ContractedBlock.gif]: https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif
[ExpandedBlockStart.gif]: /images/20211223/b40227c85ce34372bb8aafdc1ec5c36a.png
[None.gif]: /images/20211223/82bc3ffa6f8b413db5988d071f0f9b79.png
[dot.gif]: /images/20211223/7c5701771ac441adaba8ec170bb66a6d.png
[InBlock.gif]: /images/20211223/3b6d7a4979c744989b45f9d62e00c6eb.png
[ExpandedSubBlockStart.gif]: https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif
[ContractedSubBlock.gif]: https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif
[ExpandedSubBlockEnd.gif]: /images/20211223/15abc6da18734943998fff987a54ee4b.png
[ExpandedBlockEnd.gif]: /images/20211223/7497d11b875844aeb6458ee19595d70a.png
[E7_A4_BA_E6_A0_B7.gif]: /images/20211223/d8025d2022674fdeac2b09c27a701739.png