这两天为了做报表,研究了一下XtraReport 。为了添加空行,想了很多办法。其中如果有分组时,网上给出的办法就会失败。
现将经验公布一下,希望各位都能少走弯路。
1.加入自定义函数CreateCellArray,用于创建空行。
2.生成报表的 FillEmptySpace 事件,填写如下代码。
3.tableDetail 是指细节 区带
4.****注意,如果有分组,必须将分组PrintAtBottom设置为true,就是将其下沉。
private void CreateCellArray(XRTableRow xrRow, XRTableRow xrRowTemplate)
{
int Xmargin = 0;
for (int i = 0; i < xrRowTemplate.Cells.Count; i++)
{
XRTableCell xrcell = new XRTableCell();
xrcell.BorderWidth = 1;
xrcell.Borders = (DevExpress.XtraPrinting.BorderSide)((BorderSide.Left | BorderSide.Right) | BorderSide.Bottom);
xrcell.WidthF = xrRowTemplate.Cells.WidthF;
xrcell.BackColor = xrRowTemplate.Cells.BackColor;
xrcell.Height = xrRowTemplate.Height;
if (i != 0)
{
xrcell.Location = new Point(Convert.ToInt32(Xmargin + xrRowTemplate.Cells.WidthF), 0);
}
else
{
xrcell.Location = new Point(0, 0);
}
xrRow.Cells.Add(xrcell);
}
}
private void XR_HT_RT_FillEmptySpace(object sender, BandEventArgs e)
{
XRTable table = tableDetail;//Template Detail Band XRTable
int iheight = table.Rows[table.Rows.Count - 1].Height;
XRTable xrTable = new XRTable();
xrTable.Size = new Size(table.Width, e.Band.Height - 1);
xrTable.BorderWidth = table.BorderWidth;
xrTable.Location = table.Location;
xrTable.BackColor = table.BackColor;
int SpaceRowCount = e.Band.Height / iheight;
XRTableRow[] xrRow = new XRTableRow[SpaceRowCount];
if (SpaceRowCount > 0)
{
for (int i = 0; i < SpaceRowCount; i++)
{
xrRow = new XRTableRow();
xrRow.Size = new Size(table.Width, iheight);
xrRow.Location = new Point(table.Location.X, i * iheight);
xrRow.Borders = (DevExpress.XtraPrinting.BorderSide)((BorderSide.Left | BorderSide.Right) | BorderSide.Bottom);
xrRow.BorderWidth = 1;
xrRow.BorderColor = table.Rows[table.Rows.Count - 1].BorderColor;
//CreateCell
XRTableRow row = table.Rows[table.Rows.Count - 1];
CreateCellArray(xrRow, row);
}
xrTable.Rows.AddRange(xrRow);
e.Band.Controls.Add(xrTable);
}
}