• 动态RDLC报表（五）

    动态RDLC报表类DynamicReport：数据表节点数据填充

           数据表部分是最麻烦的，可以添加多个数据表，可以设置多维表头，可以设置多字段的统计行，不同的列可以采用不同的样式。在传入数据表前需要先传入列样式、多维表头，数据表和统计列是同一时间传入的，页眉和页脚则需要在数据表后传入。

           在这里最多可以设置三行表头，从上到下依次是hearderTop、hearderMerge和数据表中的列。表头的样式包含如下几部分：

            public string ColoumName { get; set; }     //列名
            public float ColoumWidth { get; set; }       //列宽
            public TextAlign TextAlign { get; set; }      //对齐
            public ConsoleColor ConsoleColor { get; set; }    //颜色
            public Boolean IsShortDate { get; set; }       //显示短日期格式

           多维表头的数据表结构是：

                DataTable hearderMerge = new DataTable();
                hearderMerge.Columns.Add("CellNumber", Type.GetType("System.Int32"));
                hearderMerge.Columns.Add("CellValue", Type.GetType("System.String"));


           CellNumber代表占用多少列宽度，1为一列，2为合并二列，总列数不能超过或少过数据表的列数；CellValue就是显示的名称。

            统计行可以是单列或多列，以string方式传入，不同列用逗号分隔，如“列名1,列名3”，可以是任意列，可以相邻或间隔，但必须是数据表中存在的列并且值可以相加。当只有一列统计时在此列的前面显示“统计：”，如果是第一列则不显示。

           数据表会生成DataSets节点和Tablix节点。

    1.         private List<ReportColoumStyle> _coloumStyle = new List<ReportColoumStyle>();
    2.         internal const float ColoumWidth = 1.6F; //列宽
    3.         private float tabelTopPosition = 0.0F;
    4.         private DataTable hearderName = new DataTable();
    5.         private DataTable hearderMerge = new DataTable();
    6.         private DataTable hearderTop = new DataTable();
    7.  
    8.         public void SetColoumStyle(List<ReportColoumStyle> coloumStyle)
    9.         {
    10.             this._coloumStyle = coloumStyle;
    11.         }
    12.  
    13.         public void AddData(DataTable dataTable, string totalColumn)
    14.         {
    15.             if (dataTable != null && dataTable.Rows.Count > 0)
    16.             {
    17.                 var coloumNames = new List<string>();
    18.                 foreach (DataColumn dataColumn in dataTable.Columns)
    19.                 {
    20.                     var protertyName = dataColumn.ColumnName;
    21.                     coloumNames.Add(protertyName);
    22.                 }
    23.                 AddReportItemPattern(coloumNames.ToArray(), dataTable, totalColumn);
    24.             }
    25.         }
    26.  
    27.         protected void AddReportItemPattern(string[] coloumNames, dynamic data, string totalColumn = "")
    28.         {
    29.             StringBuilder fields = new StringBuilder();
    30.             StringBuilder coloums = new StringBuilder();
    31.             StringBuilder tablixHearders = new StringBuilder();
    32.             StringBuilder tablixCells = new StringBuilder();
    33.             StringBuilder tablixMembers = new StringBuilder();
    34.             float currentNamePrefix = _reportItemPatterns.Count + _reportHeadPatterns.Count + 1;
    35.             float tableWidth = 0F;
    36.             float dataRows = ((DataTable)data).Rows.Count; //数据行数
    37.             int totalNumber = 0;
    38.             string totalWidth = "";
    39.             string totalCellPattern = "";
    40.             string totalMemberPattern = "";
    41.             string mergeMemberPattern = "";
    42.             Boolean isHearderMerge = true;
    43.             float hearderHeight = 0.0F;
    44.  
    45.             foreach (var coloumName in coloumNames)
    46.             {
    47.                 var coloumWidth = ColoumWidth;
    48.                 var textAlign = TextAlign.Right;
    49.                 var consoleColor = ConsoleColor.Black;
    50.                 var isShortDate = false;
    51.                 var reportColoumStyle = _coloumStyle.FirstOrDefault(r => r.ColoumName == coloumName);
    52.                 if (reportColoumStyle != null)
    53.                 {
    54.                     textAlign = reportColoumStyle.TextAlign;
    55.                     coloumWidth = reportColoumStyle.ColoumWidth;
    56.                     consoleColor = reportColoumStyle.ConsoleColor;
    57.                     isShortDate = reportColoumStyle.IsShortDate;
    58.                 }
    59.                 tableWidth += coloumWidth;
    60.                 if (totalColumn != "")
    61.                 {
    62.                     if (totalColumn.Split(',').Length > 1)
    63.                     {
    64.                         for (int i = 0; i < totalColumn.Split(',').Length; i++)
    65.                         {
    66.                             if (totalColumn.Split(',')[i] == coloumName)
    67.                             {
    68.                                 if (totalWidth == "")
    69.                                 {
    70.                                     totalWidth = totalNumber.ToString();
    71.                                 }
    72.                                 else
    73.                                 {
    74.                                     totalWidth += "," + totalNumber.ToString();
    75.                                 }
    76.                             }
    77.                         }
    78.                     }
    79.                     else
    80.                     {
    81.                         if (totalColumn == coloumName)
    82.                         {
    83.                             totalWidth = totalNumber.ToString();
    84.                         }
    85.                     }
    86.                 }
    87.                 totalNumber += 1;
    88.  
    89.                 var bottomBorder = string.Empty; //每个单元格底部border
    90.                 if (dataRows == 0)
    91.                 {
    92.                     bottomBorder = "<BottomBorder><Style>NoneStyle>BottomBorder>";
    93.                 }
    94.                 var coloumValue = coloumName;
    95.                 if (hearderName.Rows.Count > 0)
    96.                 {
    97.                     foreach (DataColumn dc in hearderName.Columns)
    98.                     {
    99.                         if (dc.ColumnName == coloumName)
    100.                         {
    101.                             if (hearderName.Rows[0][coloumName].ToString().Trim() != "") coloumValue = hearderName.Rows[0][coloumName].ToString();
    102.                         }
    103.                     }
    104.                 }
    105.                 //例外,如果coloumName包含Coloum之类的字段,则将value设成空
    106.                 if (coloumName.IndexOf("Column", System.StringComparison.Ordinal) > -1)
    107.                 {
    108.                     coloumValue = "　";
    109.                 }
    110.  
    111.                 fields.AppendFormat(
    112.                     "<Field Name=\"{0}\"><DataField>{0}DataField><rd:TypeName>System.Stringrd:TypeName>Field>",
    113.                     coloumName);
    114.                 coloums.AppendFormat("<TablixColumn><Width>{0}cmWidth>TablixColumn>", coloumWidth);
    115.                 if (hearderMerge.Rows.Count > 0)
    116.                 {
    117.                     if (isHearderMerge)
    118.                     {
    119.                         hearderHeight += 0.5F;
    120.                         mergeMemberPattern = "<TablixMember><KeepWithGroup>AfterKeepWithGroup><RepeatOnNewPage>trueRepeatOnNewPage>TablixMember>";
    121.                         if (hearderTop.Rows.Count > 0)
    122.                         {
    123.                             hearderHeight += 0.5F;
    124.                             mergeMemberPattern += "<TablixMember><KeepWithGroup>AfterKeepWithGroup><RepeatOnNewPage>trueRepeatOnNewPage>TablixMember>";
    125.                         }
    126.                         isHearderMerge = false;
    127.                         GetHearderMerge(tablixHearders, currentNamePrefix);
    128.                     }
    129.                     tablixHearders.AppendFormat("<TablixCell><CellContents>" +
    130.                                                 "<Textbox Name=\"Textbox{0}{1}\"><CanGrow>trueCanGrow><KeepTogether>trueKeepTogether><Paragraphs><Paragraph>" +
    131.                                                 "<TextRuns><TextRun><Value>{2}Value><Style><FontWeight>BoldFontWeight><FontFamily>" + fontString + "FontFamily><FontSize>" + fontSize + "ptFontSize>Style>TextRun>TextRuns><Style><TextAlign>CenterTextAlign>Style>Paragraph>Paragraphs>" +
    132.                                                 "<rd:DefaultName>Textbox{0}{1}rd:DefaultName><Style><Border><Color>DarkGrayColor><Style>SolidStyle>Border><TopBorder><Style>NoneStyle>TopBorder><VerticalAlign>MiddleVerticalAlign>" +
    133.                                                 "<PaddingLeft>2ptPaddingLeft><PaddingRight>2ptPaddingRight><PaddingTop>2ptPaddingTop><PaddingBottom>1ptPaddingBottom>Style>Textbox>CellContents>TablixCell>",
    134.                                                 coloumName, currentNamePrefix, coloumValue, bottomBorder);
    135.                 }
    136.                 else
    137.                 {
    138.                     tablixHearders.AppendFormat("<TablixCell><CellContents>" +
    139.                                                 "<Textbox Name=\"Textbox{0}{1}\"><CanGrow>trueCanGrow><KeepTogether>trueKeepTogether><Paragraphs><Paragraph>" +
    140.                                                 "<TextRuns><TextRun><Value>{2}Value><Style><FontWeight>BoldFontWeight><FontFamily>" + fontString + "FontFamily><FontSize>" + fontSize + "ptFontSize>Style>TextRun>TextRuns><Style><TextAlign>CenterTextAlign>Style>Paragraph>Paragraphs>" +
    141.                                                 "<rd:DefaultName>Textbox{0}{1}rd:DefaultName><Style><Border><Color>DarkGrayColor><Style>SolidStyle>Border>{3}<VerticalAlign>MiddleVerticalAlign>" +
    142.                                                 "<PaddingLeft>2ptPaddingLeft><PaddingRight>2ptPaddingRight><PaddingTop>2ptPaddingTop><PaddingBottom>1ptPaddingBottom>Style>Textbox>CellContents>TablixCell>",
    143.                                                 coloumName, currentNamePrefix, coloumValue, bottomBorder);
    144.                 }
    145.                 //string valueString = "=IIf(IIf(Fields!{0}.Value=\"True\",\"√\", Fields!{0}.Value)=\"False\",\"\",IIf(Fields!{0}.Value=\"True\",\"√\", Fields!{0}.Value))";
    146.                 string valueString = "=Fields!{0}.Value";
    147.                 if (isShortDate) valueString = "=FormatDateTime(Fields!{0}.Value,DateFormat.ShortDate)";
    148.                 tablixCells.AppendFormat(
    149.                     "<TablixCell><CellContents><Textbox Name=\"{0}{1}1\"><CanGrow>trueCanGrow><KeepTogether>trueKeepTogether>" +
    150.                     "<Paragraphs><Paragraph><TextRuns><TextRun><Value>" + valueString + "Value><Style><Color>{3}Color><FontFamily>" + fontString + "FontFamily><FontSize>" + fontSize + "ptFontSize>Style>TextRun>TextRuns><Style><TextAlign>{2}TextAlign>Style>Paragraph>Paragraphs>" +
    151.                     "<rd:DefaultName>{0}{1}1rd:DefaultName><Style><Border><Color>DarkGrayColor><Style>SolidStyle>Border><VerticalAlign>MiddleVerticalAlign>" +
    152.                     "<PaddingLeft>2ptPaddingLeft><PaddingRight>2ptPaddingRight><PaddingTop>2ptPaddingTop><PaddingBottom>1ptPaddingBottom>Style>Textbox>CellContents>TablixCell>",
    153.                     coloumName, currentNamePrefix, textAlign, consoleColor);
    154.  
    155.                 tablixMembers.AppendFormat("<TablixMember />");
    156.             }
    157.  
    158.             if (totalColumn != "")
    159.             {
    160.                 totalCellPattern = "<TablixRow><Height>0.5cmHeight><TablixCells>\r\n\r\n";
    161.                 if (totalColumn.Split(',').Length > 1)
    162.                 {
    163.                     for (int i = 0; i < totalColumn.Split(',').Length; i++)
    164.                     {
    165.                         if (i == 0)
    166.                         {
    167.                             for (int n = 0; n < Convert.ToInt32(totalWidth.Split(',')[i]); n++)
    168.                             {
    169.                                 totalCellPattern += "<TablixCell><CellContents><Textbox Name=\"total" + _reportItemPatterns.Count.ToString() + i.ToString() + n + "\"><CanGrow>trueCanGrow><KeepTogether>trueKeepTogether>" +
    170.                                                     "<Paragraphs><Paragraph><TextRuns><TextRun><Value /><Style>NoneStyle>TextRun>TextRuns><Style><TextAlign>LeftTextAlign>Style>Paragraph>Paragraphs>" +
    171.                                                     "<rd:DefaultName>total" + _reportItemPatterns.Count.ToString() + i.ToString() + n + "rd:DefaultName><Style><Border><Color>DarkGrayColor><Style>NoneStyle>Border><VerticalAlign>TopVerticalAlign>" +
    172.                                                     "<PaddingLeft>0ptPaddingLeft><PaddingRight>0ptPaddingRight><PaddingTop>2ptPaddingTop><PaddingBottom>0ptPaddingBottom>Style>Textbox>CellContents>TablixCell>\r\n\r\n";
    173.                             }
    174.                         }
    175.                         else
    176.                         {
    177.                             for (int n = 0; n < (Convert.ToInt32(totalWidth.Split(',')[i]) - Convert.ToInt32(totalWidth.Split(',')[i - 1]) - 1); n++)
    178.                             {
    179.                                 totalCellPattern += "<TablixCell><CellContents><Textbox Name=\"total" + _reportItemPatterns.Count.ToString() + i.ToString() + n + "\"><CanGrow>trueCanGrow><KeepTogether>trueKeepTogether>" +
    180.                                                     "<Paragraphs><Paragraph><TextRuns><TextRun><Value /><Style>NoneStyle>TextRun>TextRuns><Style><TextAlign>LeftTextAlign>Style>Paragraph>Paragraphs>" +
    181.                                                     "<rd:DefaultName>total" + _reportItemPatterns.Count.ToString() + i.ToString() + n + "rd:DefaultName><Style><Border><Color>DarkGrayColor><Style>NoneStyle>Border><VerticalAlign>TopVerticalAlign>" +
    182.                                                     "<PaddingLeft>0ptPaddingLeft><PaddingRight>0ptPaddingRight><PaddingTop>2ptPaddingTop><PaddingBottom>0ptPaddingBottom>Style>Textbox>CellContents>TablixCell>\r\n\r\n";
    183.                             }
    184.                         }
    185.                         totalCellPattern += "<TablixCell><CellContents><Textbox Name=\"totalValue" + _reportItemPatterns.Count.ToString() + i.ToString() + "\"><CanGrow>trueCanGrow><KeepTogether>trueKeepTogether>" +
    186.                                             "<Paragraphs><Paragraph><TextRuns><TextRun><Value>=Sum(CDec(Fields!" + totalColumn.Split(',')[i] + ".Value))Value><Style><FontFamily>" + fontString + "FontFamily><FontSize>" + fontSize + "ptFontSize><FontWeight>BoldFontWeight>Style>TextRun>TextRuns><Style><TextAlign>CenterTextAlign>Style>Paragraph>Paragraphs>" +
    187.                                             "<rd:DefaultName>totalValue" + _reportItemPatterns.Count.ToString() + i.ToString() + "rd:DefaultName><Style><Border><Color>DarkGrayColor><Style>NoneStyle>Border><VerticalAlign>TopVerticalAlign>" +
    188.                                             "<PaddingLeft>0ptPaddingLeft><PaddingRight>2ptPaddingRight><PaddingTop>2ptPaddingTop><PaddingBottom>1ptPaddingBottom>Style>Textbox>CellContents>TablixCell>\r\n\r\n";
    189.                     }
    190.                     for (int i = 1; i < (coloumNames.Length - Convert.ToInt32(totalWidth.Split(',')[totalWidth.Split(',').Length - 1])); i++)
    191.                     {
    192.                         totalCellPattern += "<TablixCell><CellContents><Textbox Name=\"totalall" + _reportItemPatterns.Count.ToString() + i.ToString() + "\"><CanGrow>trueCanGrow><KeepTogether>trueKeepTogether>" +
    193.                                             "<Paragraphs><Paragraph><TextRuns><TextRun><Value /><Style>NoneStyle>TextRun>TextRuns><Style><TextAlign>LeftTextAlign>Style>Paragraph>Paragraphs>" +
    194.                                             "<rd:DefaultName>totalall" + _reportItemPatterns.Count.ToString() + i.ToString() + "rd:DefaultName><Style><Border><Color>DarkGrayColor><Style>NoneStyle>Border><VerticalAlign>TopVerticalAlign>" +
    195.                                             "<PaddingLeft>0ptPaddingLeft><PaddingRight>0ptPaddingRight><PaddingTop>2ptPaddingTop><PaddingBottom>0ptPaddingBottom>Style>Textbox>CellContents>TablixCell>\r\n\r\n";
    196.                     }
    197.                 }
    198.                 else
    199.                 {
    200.                     if (Convert.ToInt32(totalWidth) > 0) totalCellPattern += "<TablixCell><CellContents><Textbox Name=\"totalname" + _reportItemPatterns.Count.ToString() + "\"><CanGrow>trueCanGrow><KeepTogether>trueKeepTogether>" +
    201.                                                                             "<Paragraphs><Paragraph><TextRuns><TextRun><Value>" + totalString + "Value><Style><FontFamily>" + fontString + "FontFamily><FontSize>" + fontSize + "ptFontSize><FontWeight>BoldFontWeight>Style>TextRun>TextRuns><Style><TextAlign>RightTextAlign>Style>Paragraph>Paragraphs>" +
    202.                                                                             "<rd:DefaultName>totalname" + _reportItemPatterns.Count.ToString() + "rd:DefaultName><Style><Border><Color>DarkGrayColor><Style>NoneStyle>Border><VerticalAlign>TopVerticalAlign>" +
    203.                                                                             "<PaddingLeft>2ptPaddingLeft><PaddingRight>2ptPaddingRight><PaddingTop>3ptPaddingTop><PaddingBottom>1ptPaddingBottom>Style>Textbox><ColSpan>" + totalWidth + "ColSpan>CellContents>TablixCell>\r\n\r\n";
    204.                     for (int i = 1; i < Convert.ToInt32(totalWidth); i++)
    205.                     {
    206.                         totalCellPattern += "<TablixCell />\r\n\r\n";
    207.                     }
    208.                     totalCellPattern += "<TablixCell><CellContents><Textbox Name=\"totalValue" + _reportItemPatterns.Count.ToString() + "\"><CanGrow>trueCanGrow><KeepTogether>trueKeepTogether>" +
    209.                                         "<Paragraphs><Paragraph><TextRuns><TextRun><Value>=Sum(CDec(Fields!" + totalColumn + ".Value))Value><Style><FontFamily>" + fontString + "FontFamily><FontSize>" + fontSize + "ptFontSize><FontWeight>BoldFontWeight>Style>TextRun>TextRuns><Style><TextAlign>RightTextAlign>Style>Paragraph>Paragraphs>" +
    210.                                         "<rd:DefaultName>totalValue" + _reportItemPatterns.Count.ToString() + "rd:DefaultName><Style><Border><Color>DarkGrayColor><Style>NoneStyle>Border><VerticalAlign>TopVerticalAlign>" +
    211.                                         "<PaddingLeft>0ptPaddingLeft><PaddingRight>2ptPaddingRight><PaddingTop>2ptPaddingTop><PaddingBottom>1ptPaddingBottom>Style>Textbox>CellContents>TablixCell>\r\n\r\n";
    212.                     for (int i = 1; i < (coloumNames.Length - Convert.ToInt32(totalWidth)); i++)
    213.                     {
    214.                         totalCellPattern += "<TablixCell><CellContents><Textbox Name=\"total" + _reportItemPatterns.Count.ToString() + i + "\"><CanGrow>trueCanGrow><KeepTogether>trueKeepTogether>" +
    215.                                             "<Paragraphs><Paragraph><TextRuns><TextRun><Value /><Style>NoneStyle>TextRun>TextRuns><Style><TextAlign>LeftTextAlign>Style>Paragraph>Paragraphs>" +
    216.                                             "<rd:DefaultName>total" + _reportItemPatterns.Count.ToString() + i + " rd:DefaultName><Style><Border><Color>DarkGrayColor><Style>NoneStyle>Border><VerticalAlign>TopVerticalAlign>" +
    217.                                             "<PaddingLeft>0ptPaddingLeft><PaddingRight>0ptPaddingRight><PaddingTop>2ptPaddingTop><PaddingBottom>0ptPaddingBottom>Style>Textbox>CellContents>TablixCell>\r\n\r\n";
    218.                     }
    219.                 }
    220.                 totalCellPattern += "TablixCells>TablixRow>";
    221.                 totalMemberPattern = "<TablixMember><KeepWithGroup>BeforeKeepWithGroup>TablixMember>";
    222.             }
    223.  
    224.  
    225.             //计算表格应该离左边多少距离
    226.             var leftPosition = (pageWidth - tableWidth) / 2;
    227.             if (leftPosition < leftMargin / 2) leftPosition = leftMargin / 2;
    228.             var dataSetName = string.Format("Data{0}", _reportItemPatterns.Count + _reportHeadPatterns.Count + 1);
    229.             var reportItemPattern = new ReportItemPattern();
    230.             reportItemPattern.Data = DynamicReportExtension.RemoveZeroData(data);
    231.             reportItemPattern.DataSetName = dataSetName;
    232.             reportItemPattern.DataSetString =
    233.                 reportItemPattern.DataSetPattern
    234.                                  .Replace("@DataSetName", dataSetName)
    235.                                  .Replace("@Fields", fields.ToString());
    236.             reportItemPattern.TablixString =
    237.                 reportItemPattern.TablixPattern
    238.                                  .Replace("@DataSetName", dataSetName)
    239.                                  .Replace("@TablixColumns", coloums.ToString())
    240.                                  .Replace("@TablixHeader", tablixHearders.ToString())
    241.                                  .Replace("@TablixCells", tablixCells.ToString())
    242.                                  .Replace("@TablixMember", tablixMembers.ToString())
    243.                                  .Replace("@TotalRow", totalCellPattern.ToString())
    244.                                  .Replace("@MergeMember", mergeMemberPattern.ToString())
    245.                                  .Replace("@TotalMember", totalMemberPattern.ToString())
    246.                                  .Replace("@TopPosition", CaculatePlacePostion().ToString())
    247.                                  .Replace("@LeftPostion", leftPosition.ToString());
    248.  
    249.             //读取行数,如果是空行就加到新的
    250.             if (dataRows == 0)
    251.             {
    252.                 _reportHeadPatterns.Add(reportItemPattern);
    253.             }
    254.             else
    255.             {
    256.                 _reportItemPatterns.Add(reportItemPattern);
    257.             }
    258.             if (totalCellPattern != "")
    259.             {
    260.                 tabelTopPosition = CaculatePlacePostion() + hearderHeight - 0.3F;
    261.             }
    262.             else
    263.             {
    264.                 tabelTopPosition = CaculatePlacePostion() + hearderHeight - 0.5F;
    265.             }
    266.         }
    267.  
    268.         protected float CaculatePlacePostion()
    269.         {
    270.             //每个数据表的高度
    271.             float itemCount = _reportItemPatterns.Count * 2f;
    272.             // 每个空表头的高度
    273.             float emptyItemCount = _reportHeadPatterns.Count * 0.5f;
    274.             return itemCount + emptyItemCount;
    275.         }
    276.  
    277.  
    278.         private void GetHearderMerge(StringBuilder tablixHearders, float currentNamePrefix)
    279.         {
    280.             string topBorder = "";
    281.             if (hearderTop.Rows.Count > 0)
    282.             {
    283.                 topBorder = "<TopBorder><Style>NoneStyle>TopBorder>";
    284.                 for (int i = 0; i < hearderTop.Rows.Count; i++)
    285.                 {
    286.                     if ((Int32)hearderTop.Rows[i]["CellNumber"] == 1)
    287.                     {
    288.                         tablixHearders.AppendFormat("<TablixCell><CellContents>" +
    289.                                                 "<Textbox Name=\"TextboxTop{0}{1}\"><CanGrow>trueCanGrow><KeepTogether>trueKeepTogether><Paragraphs><Paragraph>" +
    290.                                                 "<TextRuns><TextRun><Value /><Style><FontWeight>BoldFontWeight><FontFamily>" + fontString + "FontFamily><FontSize>" + fontSize + "ptFontSize>Style>TextRun>TextRuns><Style><TextAlign>CenterTextAlign>Style>Paragraph>Paragraphs>" +
    291.                                                 "<rd:DefaultName>TextboxTop{0}{1}rd:DefaultName><Style><Border><Color>DarkGrayColor><Style>SolidStyle>Border><BottomBorder><Style>NoneStyle>BottomBorder><VerticalAlign>MiddleVerticalAlign>" +
    292.                                                 "<PaddingLeft>2ptPaddingLeft><PaddingRight>2ptPaddingRight><PaddingTop>2ptPaddingTop><PaddingBottom>1ptPaddingBottom>Style>Textbox>CellContents>TablixCell>",
    293.                                                 i, currentNamePrefix);
    294.                     }
    295.                     else
    296.                     {
    297.                         string borderString = "";
    298.                         if (hearderTop.Rows[i]["CellValue"].ToString().Trim() == "") borderString = "<BottomBorder><Style>NoneStyle>BottomBorder>";
    299.                         tablixHearders.AppendFormat("<TablixCell><CellContents>" +
    300.                                                 "<Textbox Name=\"TextboxTop{0}{1}\"><CanGrow>trueCanGrow><KeepTogether>trueKeepTogether><Paragraphs><Paragraph>" +
    301.                                                 "<TextRuns><TextRun><Value>" + hearderTop.Rows[i]["CellValue"].ToString() + "Value><Style><FontWeight>BoldFontWeight><FontFamily>" + fontString + "FontFamily><FontSize>" + fontSize + "ptFontSize>Style>TextRun>TextRuns><Style><TextAlign>CenterTextAlign>Style>Paragraph>Paragraphs>" +
    302.                                                 "<rd:DefaultName>TextboxTop{0}{1}rd:DefaultName><Style><Border><Color>DarkGrayColor><Style>SolidStyle>Border>" + borderString + "<VerticalAlign>MiddleVerticalAlign>" +
    303.                                                 "<PaddingLeft>2ptPaddingLeft><PaddingRight>2ptPaddingRight><PaddingTop>2ptPaddingTop><PaddingBottom>1ptPaddingBottom>Style>Textbox><ColSpan>" + hearderTop.Rows[i]["CellNumber"].ToString() + "ColSpan>CellContents>TablixCell>",
    304.                                                 i, currentNamePrefix);
    305.                         for (int n = 1; n < Convert.ToInt32(hearderTop.Rows[i]["CellNumber"]); n++)
    306.                         {
    307.                             tablixHearders.AppendFormat("<TablixCell />");
    308.                         }
    309.                     }
    310.                 }
    311.                 tablixHearders.AppendFormat("TablixCells>" +
    312.                                 "           TablixRow>" +
    313.                                 "           <TablixRow>" +
    314.                                 "               <Height>0.5cmHeight>" +
    315.                                 "               <TablixCells>");
    316.             }
    317.             if (hearderMerge.Rows.Count > 0)
    318.             {
    319.                 for (int i = 0; i < hearderMerge.Rows.Count; i++)
    320.                 {
    321.                     if ((Int32)hearderMerge.Rows[i]["CellNumber"] == 1)
    322.                     {
    323.                         tablixHearders.AppendFormat("<TablixCell><CellContents>" +
    324.                                                 "<Textbox Name=\"TextboxMerge{0}{1}\"><CanGrow>trueCanGrow><KeepTogether>trueKeepTogether><Paragraphs><Paragraph>" +
    325.                                                 "<TextRuns><TextRun><Value /><Style><FontWeight>BoldFontWeight><FontFamily>" + fontString + "FontFamily><FontSize>" + fontSize + "ptFontSize>Style>TextRun>TextRuns><Style><TextAlign>CenterTextAlign>Style>Paragraph>Paragraphs>" +
    326.                                                 "<rd:DefaultName>TextboxMerge{0}{1}rd:DefaultName><Style><Border><Color>DarkGrayColor><Style>SolidStyle>Border>" + topBorder + "<BottomBorder><Style>NoneStyle>BottomBorder><VerticalAlign>MiddleVerticalAlign>" +
    327.                                                 "<PaddingLeft>2ptPaddingLeft><PaddingRight>2ptPaddingRight><PaddingTop>2ptPaddingTop><PaddingBottom>1ptPaddingBottom>Style>Textbox>CellContents>TablixCell>",
    328.                                                 i, currentNamePrefix);
    329.                     }
    330.                     else
    331.                     {
    332.                         tablixHearders.AppendFormat("<TablixCell><CellContents>" +
    333.                                                 "<Textbox Name=\"TextboxMerge{0}{1}\"><CanGrow>trueCanGrow><KeepTogether>trueKeepTogether><Paragraphs><Paragraph>" +
    334.                                                 "<TextRuns><TextRun><Value>" + hearderMerge.Rows[i]["CellValue"].ToString() + "Value><Style><FontWeight>BoldFontWeight><FontFamily>" + fontString + "FontFamily><FontSize>" + fontSize + "ptFontSize>Style>TextRun>TextRuns><Style><TextAlign>CenterTextAlign>Style>Paragraph>Paragraphs>" +
    335.                                                 "<rd:DefaultName>TextboxMerge{0}{1}rd:DefaultName><Style><Border><Color>DarkGrayColor><Style>SolidStyle>Border>" + topBorder + "<VerticalAlign>MiddleVerticalAlign>" +
    336.                                                 "<PaddingLeft>2ptPaddingLeft><PaddingRight>2ptPaddingRight><PaddingTop>2ptPaddingTop><PaddingBottom>1ptPaddingBottom>Style>Textbox><ColSpan>" + hearderMerge.Rows[i]["CellNumber"].ToString() + "ColSpan>CellContents>TablixCell>",
    337.                                                 i, currentNamePrefix);
    338.                         for (int n = 1; n < Convert.ToInt32(hearderMerge.Rows[i]["CellNumber"]); n++)
    339.                         {
    340.                             tablixHearders.AppendFormat("<TablixCell />");
    341.                         }
    342.                     }
    343.                 }
    344.                 tablixHearders.AppendFormat("TablixCells>" +
    345.                                 "           TablixRow>" +
    346.                                 "           <TablixRow>" +
    347.                                 "               <Height>0.5cmHeight>" +
    348.                                 "               <TablixCells>");
    349.             }
    350.         }

    动态RDLC报表（一）

    动态RDLC报表（二）

    动态RDLC报表（三）

    动态RDLC报表（四）

    动态RDLC报表（五）

    动态RDLC报表（六）

    动态RDLC报表（七）

    动态RDLC报表完整实例下载

  • 相关阅读:
    QGIS编译（跨平台编译）之五十一：Qt Creator环境下qgis_native库的pro文件
    南瓜科学好奇盒子上新 打造新时代玩具总动员
    NETCONF、RESTCONF和YANG
    昭通市鲁甸县卯家湾安置区：凝心聚力 共谱民族团结进步新篇章
    python日志管理
    Apache Kyuubi & Celeborn，助力 Spark 拥抱云原生
    好强型性格分析，如何改变好强型性格？
    第4套.py
    数据在内存中的存储（1）
    文献学习-14-一种用于高精度微创手术的纤维机器人
  • 原文地址：https://blog.csdn.net/xgh815/article/details/126245597