xTrareport 交叉报表数据域的数据没显示!
发表于2019-05-10
回复:0
查看:2768 |
**用vs利用ReportDesigner设计了个报表,在里面增加了个Pivot Grid,设定对应的列名和绑定数据字段对应的FieldName名,并手动对Xreport绑定数据源。运行后在RowArea数据能够显示,DataArea域里面的数据为0(数据源中的数据为非0),应该怎样解决呢?**
<pre class='brush: csharp'> private void Form1_Load(object sender, EventArgs e)
{
DataTableCreate();
DataTableDataInit();
XtraReport xr = new XtraReport();
xr.LoadLayout(@"D:\111.repx");
xr.DataSource = this.infoDt;
this.documentViewer1.DocumentSource = xr;
xr.CreateDocument();
}
private void DataTableDataInit()
{
this.infoDt.Rows.Clear();
for (int i = 0; i < 5; i++)
{
DataRow dr = this.infoDt.NewRow();
dr[0] = "花园";
dr[1] = "3期";
dr[2] = "3座";
dr[3] = "60"+i.ToString();
dr[4] = new Random().Next(1,100);
dr[5] = new Random().Next(1, 100);
dr[6] = new Random().Next(1, 100);
dr[7] = new Random().Next(1, 100);
dr[8] = new Random().Next(1, 100);
dr[9] = new Random().Next(1, 100);
dr[10] =new Random().Next(1, 100);
infoDt.Rows.Add(dr);
}
for (int i = 0; i < 5; i++)
{
DataRow dr = this.infoDt.NewRow();
dr[0] = "花园";
dr[1] = "3期";
dr[2] = "4座";
dr[3] = "30" + i.ToString();
dr[4] = new Random().Next(1, 20);
dr[5] = new Random().Next(1, 30);
dr[6] = new Random().Next(1, 100;
dr[7] = new Random().Next(1, 100);
dr[8] = new Random().Next(1, 100);
dr[9] = new Random().Next(1, 100);
dr[10] = new Random().Next(1, 100);
infoDt.Rows.Add(dr);
}
}</pre>
对应的repx文件:
<pre class='brush: csharp'> //
// pivotGridField1
//
this.pivotGridField1.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.pivotGridField1.AreaIndex = 0;
this.pivotGridField1.Caption = "小区";
this.pivotGridField1.FieldName = "nodeName01";
this.pivotGridField1.Name = "pivotGridField1";
this.pivotGridField1.SortOrder = DevExpress.XtraPivotGrid.PivotSortOrder.Descending;
//
// pivotGridField8
//
this.pivotGridField8.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.pivotGridField8.AreaIndex = 3;
this.pivotGridField8.Caption = "04";
this.pivotGridField8.FieldName = "04";
this.pivotGridField8.Name = "pivotGridField8";
//
// pivotGridField7
//
this.pivotGridField7.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.pivotGridField7.AreaIndex = 2;
this.pivotGridField7.Caption = "03";
this.pivotGridField7.FieldName = "03";
this.pivotGridField7.Name = "pivotGridField7";</pre>
登录 慧都网发表评论