private void button2_Click(object sender, EventArgs e)
{
using (XtraReport report = new XtraReport1())
using (ReportPrintTool tool = new ReportPrintTool(report)) {
XRCrossTab crossTab = report.FindControl("xrCrossTab1", false) as XRCrossTab;
//Apply Best Fit to "CategoryName" column (Cell named "cellCategoryName" in XRCrossTab)
(crossTab.Cells["cellCategoryName"] as XRCrossTabCell).ColumnAutoWidthMode = DevExpress.XtraReports.UI.AutoSizeMode.ShrinkAndGrow;
tool.ShowPreviewDialog();
}
}
private void button1_Click(object sender, EventArgs e)
{
using (XtraReport1 report = new XtraReport1()) {
XRCrossTab crossTab = new XRCrossTab();
report.Detail.Controls.Add(crossTab);
SqlDataSource ds = new SqlDataSource(new Access97ConnectionParameters(@"|DataDirectory|\nwind.mdb", String.Empty, String.Empty));
ds.Queries.Add(SelectQueryFluentBuilder
.AddTable("Order Details")
.SelectColumns(
"UnitPrice",
"Quantity",
"OrderID"
)
.Join("Products", "ProductID")
.SelectColumns(
"ProductName"
)
.Filter("[Order Details].[OrderID] < 10250")
.Build("SalesInfo"));
crossTab.DataSource = ds;
crossTab.DataMember = "SalesInfo";
crossTab.RowFields.Add(new CrossTabRowField()
{
FieldName = "ProductName"
});
crossTab.ColumnFields.Add(new CrossTabColumnField()
{
FieldName = "OrderID"
});
crossTab.DataFields.Add(new CrossTabDataField()
{
FieldName = "UnitPrice"
});
crossTab.DataFields.Add(new CrossTabDataField()
{
FieldName = "Quantity"
});
crossTab.DataFields.Add(new CrossTabDataField());
crossTab.GenerateLayout();
/*
+---------------------+---------------------------------------+---------------------------------------+
| ProductName | [OrderID] | Grand total |
| +-------------+------------+------------+-------------+------------+------------+
| | Unit Price | Quantity | Empty cell | UnitPrice | Quantity | Empty cell |
+---------------------+-------------+------------+------------+-------------+------------+------------+
| [ProductName] | [UnitPrice] | [Quantity] | Empty cell | [UnitPrice] | [Quantity] | Empty cell |
+---------------------+-------------+------------+------------+-------------+------------+------------+
| Grand Total | | | | | | |
+---------------------+-------------+------------+------------+-------------+------------+------------+
*/
//Adjust generated cells
foreach (var c in crossTab.ColumnDefinitions)
{
//Enable auto-width for all columns
c.AutoWidthMode = DevExpress.XtraReports.UI.AutoSizeMode.ShrinkAndGrow;
}
foreach (XRCrossTabCell c in crossTab.Cells)
{
if (c.DataLevel == 0 && c.RowIndex != 1)
{
//Adjust format string for the "UnitPrice" cells
c.TextFormatString = "{0:c}";
}
if (c.RowIndex == 0 && c.ColumnLevel == 0)
{
//Adjust format string for the "OrderID" cells
c.TextFormatString = "Order {0}";
}
if (c.DataLevel == 2 && c.RowIndex != 1)
{
//Set custom expression for empty data cells
c.ExpressionBindings.Add(new ExpressionBinding("Text", "[UnitPrice] * [Quantity]"));
c.Font = new Font(c.Font, FontStyle.Bold);
c.TextFormatString = "{0:c}";
}
if (c.DataLevel == 2 && c.RowIndex == 1)
{
//Set text for empty header cells
c.Font = new Font(c.Font, FontStyle.Bold);
c.Text = "Total";
}
}
// Assign styles to cross tab
crossTab.CrossTabStyles.GeneralStyle = new XRControlStyle()
{
Name = "Default",
Borders = BorderSide.All,
Padding = new PaddingInfo()
{
All = 2
}
};
crossTab.CrossTabStyles.DataAreaStyle = crossTab.CrossTabStyles.TotalAreaStyle = new XRControlStyle()
{
Name = "Data",
TextAlignment = TextAlignment.TopRight
};
crossTab.CrossTabStyles.HeaderAreaStyle = new XRControlStyle()
{
Name = "HeaderAndTotals",
BackColor = Color.WhiteSmoke
};
report.ShowRibbonPreviewDialog();
}
}
private XtraReport CreateReport()
{
// Create a blank report.
XtraReport crossTabReport = new XtraReport()
{
VerticalContentSplitting = VerticalContentSplitting.Smart,
HorizontalContentSplitting = HorizontalContentSplitting.Smart
};
// Create a detail band and add it to the report.
DetailBand detail = new DetailBand();
crossTabReport.Bands.Add(detail);
// Create a cross tab and add it to the Detail band.
XRCrossTab crossTab = new XRCrossTab();
detail.Controls.Add(crossTab);
crossTab.PrintOptions.RepeatColumnHeaders = true;
crossTab.PrintOptions.RepeatRowHeaders = true;
// Create a data source
Access97ConnectionParameters connectionParameters = new Access97ConnectionParameters(@"|DataDirectory|\nwind.mdb", "", "");
SqlDataSource ds = new SqlDataSource(connectionParameters);
// Create an SQL query to access the SalesPerson view.
SelectQuery query = SelectQueryFluentBuilder.AddTable("SalesPerson")
.SelectColumn("CategoryName")
.SelectColumn("ProductName")
.SelectColumn("Country")
.SelectColumn("Sales Person")
.SelectColumn("Quantity")
.SelectColumn("Extended Price").Build("SalesPerson");
ds.Queries.Add(query);
// Bind the cross tab to data.
crossTab.DataSource = ds;
crossTab.DataMember = "SalesPerson";
// Generate cross tab's fields.
crossTab.RowFields.Add(new CrossTabRowField()
{
FieldName = "CategoryName"
});
crossTab.RowFields.Add(new CrossTabRowField()
{
FieldName = "ProductName"
});
crossTab.ColumnFields.Add(new CrossTabColumnField()
{
FieldName = "Country"
});
crossTab.ColumnFields.Add(new CrossTabColumnField()
{
FieldName = "Sales Person"
});
crossTab.DataFields.Add(new CrossTabDataField()
{
FieldName = "Quantity"
});
crossTab.DataFields.Add(new CrossTabDataField()
{
FieldName = "Extended Price"
});
crossTab.GenerateLayout();
/*
+----------------+---------------+-------------------------------+---------------------------+---------------------------+
| Category Name | Product Name | [Country] | Total [Country] | Grand total |
| | +-------------------------------+ | |
| | | [Sales Person] | | |
| | +------------+------------------+----------+----------------+----------+----------------+
| | | Quantity | Extended Price | Quantity | Extended Price | Quantity | Extended Price |
+----------------+---------------+------------+------------------+----------+----------------+----------+----------------+
| [CategoryName] | [ProductName] | [Quantity] | [Extended Price] | | | | |
+----------------+---------------+------------+------------------+----------+----------------+----------+----------------+
| Total [CategoryName] | | | | | | |
+--------------------------------+------------+------------------+----------+----------------+----------+----------------+
| Grand Total | | | | | | |
+--------------------------------+------------+------------------+----------+----------------+----------+----------------+
*/
//Adjust generated cells
foreach (var c in crossTab.ColumnDefinitions)
{
//Enable auto-width for all columns
c.AutoWidthMode = DevExpress.XtraReports.UI.AutoSizeMode.GrowOnly;
}
foreach (XRCrossTabCell c in crossTab.Cells)
{
if (c.DataLevel == 1 && c.RowIndex != 2)
{
//Adjust format string for the "Extended Price" cells
c.TextFormatString = "{0:c}";
}
}
// Assign styles to cross tab
crossTab.CrossTabStyles.GeneralStyle = new XRControlStyle()
{
Name = "Default",
Borders = BorderSide.All,
Padding = new PaddingInfo()
{
All = 2
}
};
crossTab.CrossTabStyles.DataAreaStyle = crossTab.CrossTabStyles.TotalAreaStyle = new XRControlStyle()
{
Name = "Data",
TextAlignment = TextAlignment.TopRight
};
crossTab.CrossTabStyles.HeaderAreaStyle = new XRControlStyle()
{
Name = "HeaderAndTotals",
BackColor = Color.WhiteSmoke
};
return(crossTabReport);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
DevExpress.DataAccess.Sql.SelectQuery selectQuery1 = new DevExpress.DataAccess.Sql.SelectQuery();
DevExpress.DataAccess.Sql.Column column1 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression1 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Table table1 = new DevExpress.DataAccess.Sql.Table();
DevExpress.DataAccess.Sql.Column column2 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression2 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column3 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression3 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column4 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression4 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column5 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression5 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column6 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression6 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column7 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression7 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column8 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression8 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column9 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression9 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column10 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression10 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column11 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression11 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column12 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression12 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column13 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression13 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column14 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression14 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column15 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression15 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column16 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression16 = new DevExpress.DataAccess.Sql.ColumnExpression();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(xTab));
DevExpress.XtraReports.UI.CrossTab.CrossTabColumnDefinition crossTabColumnDefinition1 = new DevExpress.XtraReports.UI.CrossTab.CrossTabColumnDefinition(100F);
DevExpress.XtraReports.UI.CrossTab.CrossTabColumnField crossTabColumnField1 = new DevExpress.XtraReports.UI.CrossTab.CrossTabColumnField();
DevExpress.XtraReports.UI.CrossTab.CrossTabRowField crossTabRowField1 = new DevExpress.XtraReports.UI.CrossTab.CrossTabRowField();
this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
this.crossTabGeneralStyle = new DevExpress.XtraReports.UI.XRControlStyle();
this.crossTabDataStyle = new DevExpress.XtraReports.UI.XRControlStyle();
this.crossTabHeaderStyle = new DevExpress.XtraReports.UI.XRControlStyle();
this.crossTabTotalStyle = new DevExpress.XtraReports.UI.XRControlStyle();
this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand();
this.Detail = new DevExpress.XtraReports.UI.DetailBand();
this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand();
this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand();
this.label1 = new DevExpress.XtraReports.UI.XRLabel();
this.crossTab1 = new DevExpress.XtraReports.UI.XRCrossTab();
this.xrCrossTabCell1 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
this.xrCrossTabCell2 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
this.xrCrossTabCell3 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
this.xrCrossTabCell4 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
this.xrCrossTabCell5 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
this.xrCrossTabCell6 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
this.xrCrossTabCell7 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
this.xrCrossTabCell8 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
this.xrCrossTabCell9 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
this.TitleStyle = new DevExpress.XtraReports.UI.XRControlStyle();
((System.ComponentModel.ISupportInitialize)(this.crossTab1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionName = "MainConnection";
this.sqlDataSource1.Name = "sqlDataSource1";
columnExpression1.ColumnName = "ComplaintId";
table1.Name = "Complaints";
columnExpression1.Table = table1;
column1.Expression = columnExpression1;
columnExpression2.ColumnName = "ComplaintTitle";
columnExpression2.Table = table1;
column2.Expression = columnExpression2;
columnExpression3.ColumnName = "NonResidentComplainants";
columnExpression3.Table = table1;
column3.Expression = columnExpression3;
columnExpression4.ColumnName = "NonResidentRespondents";
columnExpression4.Table = table1;
column4.Expression = columnExpression4;
columnExpression5.ColumnName = "NonResidentVictims";
columnExpression5.Table = table1;
column5.Expression = columnExpression5;
columnExpression6.ColumnName = "IncidentLocation";
columnExpression6.Table = table1;
column6.Expression = columnExpression6;
columnExpression7.ColumnName = "DisputeNature";
columnExpression7.Table = table1;
column7.Expression = columnExpression7;
columnExpression8.ColumnName = "IncidentDateTime";
columnExpression8.Table = table1;
column8.Expression = columnExpression8;
columnExpression9.ColumnName = "DateTimeRecorded";
columnExpression9.Table = table1;
column9.Expression = columnExpression9;
columnExpression10.ColumnName = "ComplainantNarrative";
columnExpression10.Table = table1;
column10.Expression = columnExpression10;
columnExpression11.ColumnName = "CreatedBy";
columnExpression11.Table = table1;
column11.Expression = columnExpression11;
columnExpression12.ColumnName = "LastUpdatedBy";
columnExpression12.Table = table1;
column12.Expression = columnExpression12;
columnExpression13.ColumnName = "ModeOfSettlement";
columnExpression13.Table = table1;
column13.Expression = columnExpression13;
columnExpression14.ColumnName = "ComplaintStatus";
columnExpression14.Table = table1;
column14.Expression = columnExpression14;
columnExpression15.ColumnName = "GovernmentSavings";
columnExpression15.Table = table1;
column15.Expression = columnExpression15;
columnExpression16.ColumnName = "Remarks";
columnExpression16.Table = table1;
column16.Expression = columnExpression16;
selectQuery1.Columns.Add(column1);
selectQuery1.Columns.Add(column2);
selectQuery1.Columns.Add(column3);
selectQuery1.Columns.Add(column4);
selectQuery1.Columns.Add(column5);
selectQuery1.Columns.Add(column6);
selectQuery1.Columns.Add(column7);
selectQuery1.Columns.Add(column8);
selectQuery1.Columns.Add(column9);
selectQuery1.Columns.Add(column10);
selectQuery1.Columns.Add(column11);
selectQuery1.Columns.Add(column12);
selectQuery1.Columns.Add(column13);
selectQuery1.Columns.Add(column14);
selectQuery1.Columns.Add(column15);
selectQuery1.Columns.Add(column16);
selectQuery1.Name = "Complaints";
selectQuery1.Tables.Add(table1);
this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1
});
this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable");
//
// crossTabGeneralStyle
//
this.crossTabGeneralStyle.BorderColor = System.Drawing.Color.FromArgb(((int)(((byte)(230)))), ((int)(((byte)(232)))), ((int)(((byte)(234)))));
this.crossTabGeneralStyle.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top)
| DevExpress.XtraPrinting.BorderSide.Right)
| DevExpress.XtraPrinting.BorderSide.Bottom)));
this.crossTabGeneralStyle.BorderWidth = 1F;
this.crossTabGeneralStyle.Font = new System.Drawing.Font("Arial", 9.75F);
this.crossTabGeneralStyle.Name = "crossTabGeneralStyle";
this.crossTabGeneralStyle.Padding = new DevExpress.XtraPrinting.PaddingInfo(6, 6, 0, 0, 100F);
//
// crossTabDataStyle
//
this.crossTabDataStyle.Name = "crossTabDataStyle";
this.crossTabDataStyle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
//
// crossTabHeaderStyle
//
this.crossTabHeaderStyle.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(251)))), ((int)(((byte)(251)))), ((int)(((byte)(251)))));
this.crossTabHeaderStyle.Font = new System.Drawing.Font("Arial", 9.75F, System.Drawing.FontStyle.Bold);
this.crossTabHeaderStyle.Name = "crossTabHeaderStyle";
this.crossTabHeaderStyle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
//
// crossTabTotalStyle
//
this.crossTabTotalStyle.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(251)))), ((int)(((byte)(251)))), ((int)(((byte)(251)))));
this.crossTabTotalStyle.Font = new System.Drawing.Font("Arial", 9.75F, System.Drawing.FontStyle.Bold);
this.crossTabTotalStyle.Name = "crossTabTotalStyle";
this.crossTabTotalStyle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
//
// ReportHeader
//
this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.label1
});
this.ReportHeader.HeightF = 42.01302F;
this.ReportHeader.Name = "ReportHeader";
//
// Detail
//
this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.crossTab1
});
this.Detail.HeightF = 75F;
this.Detail.Name = "Detail";
//
// TopMargin
//
this.TopMargin.Name = "TopMargin";
//
// BottomMargin
//
this.BottomMargin.Name = "BottomMargin";
//
// label1
//
this.label1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 6F);
this.label1.Name = "label1";
this.label1.SizeF = new System.Drawing.SizeF(59.5786F, 30.01302F);
this.label1.StyleName = "TitleStyle";
this.label1.Text = "xTab";
//
// crossTab1
//
this.crossTab1.Cells.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrCrossTabCell1,
this.xrCrossTabCell2,
this.xrCrossTabCell3,
this.xrCrossTabCell4,
this.xrCrossTabCell5,
this.xrCrossTabCell6,
this.xrCrossTabCell7,
this.xrCrossTabCell8,
this.xrCrossTabCell9
});
crossTabColumnDefinition1.AutoWidthMode = DevExpress.XtraReports.UI.AutoSizeMode.ShrinkAndGrow;
this.crossTab1.ColumnDefinitions.AddRange(new DevExpress.XtraReports.UI.CrossTab.CrossTabColumnDefinition[] {
crossTabColumnDefinition1,
new DevExpress.XtraReports.UI.CrossTab.CrossTabColumnDefinition(100F),
new DevExpress.XtraReports.UI.CrossTab.CrossTabColumnDefinition(100F)
});
crossTabColumnField1.FieldName = "DisputeNature";
this.crossTab1.ColumnFields.AddRange(new DevExpress.XtraReports.UI.CrossTab.CrossTabColumnField[] {
crossTabColumnField1
});
this.crossTab1.DataAreaStyleName = "crossTabDataStyle";
this.crossTab1.DataMember = "Complaints";
this.crossTab1.DataSource = this.sqlDataSource1;
this.crossTab1.GeneralStyleName = "crossTabGeneralStyle";
this.crossTab1.HeaderAreaStyleName = "crossTabHeaderStyle";
this.crossTab1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
this.crossTab1.Name = "crossTab1";
this.crossTab1.RowDefinitions.AddRange(new DevExpress.XtraReports.UI.CrossTab.CrossTabRowDefinition[] {
new DevExpress.XtraReports.UI.CrossTab.CrossTabRowDefinition(25F),
new DevExpress.XtraReports.UI.CrossTab.CrossTabRowDefinition(25F),
new DevExpress.XtraReports.UI.CrossTab.CrossTabRowDefinition(25F)
});
crossTabRowField1.FieldName = "ComplaintId";
this.crossTab1.RowFields.AddRange(new DevExpress.XtraReports.UI.CrossTab.CrossTabRowField[] {
crossTabRowField1
});
this.crossTab1.SizeF = new System.Drawing.SizeF(300F, 75F);
this.crossTab1.TotalAreaStyleName = "crossTabTotalStyle";
//
// xrCrossTabCell1
//
this.xrCrossTabCell1.ColumnIndex = 0;
this.xrCrossTabCell1.Name = "xrCrossTabCell1";
this.xrCrossTabCell1.RowIndex = 0;
this.xrCrossTabCell1.Text = "Complaint Id";
//
// xrCrossTabCell2
//
this.xrCrossTabCell2.ColumnIndex = 1;
this.xrCrossTabCell2.Name = "xrCrossTabCell2";
this.xrCrossTabCell2.RowIndex = 1;
//
// xrCrossTabCell3
//
this.xrCrossTabCell3.ColumnIndex = 1;
this.xrCrossTabCell3.Name = "xrCrossTabCell3";
this.xrCrossTabCell3.RowIndex = 0;
//
// xrCrossTabCell4
//
this.xrCrossTabCell4.ColumnIndex = 2;
this.xrCrossTabCell4.Name = "xrCrossTabCell4";
this.xrCrossTabCell4.RowIndex = 0;
this.xrCrossTabCell4.Text = "Grand Total";
//
// xrCrossTabCell5
//
this.xrCrossTabCell5.ColumnIndex = 2;
this.xrCrossTabCell5.Name = "xrCrossTabCell5";
this.xrCrossTabCell5.RowIndex = 1;
//
// xrCrossTabCell6
//
this.xrCrossTabCell6.ColumnIndex = 0;
this.xrCrossTabCell6.Name = "xrCrossTabCell6";
this.xrCrossTabCell6.RowIndex = 1;
//
// xrCrossTabCell7
//
this.xrCrossTabCell7.ColumnIndex = 0;
this.xrCrossTabCell7.Name = "xrCrossTabCell7";
this.xrCrossTabCell7.RowIndex = 2;
this.xrCrossTabCell7.Text = "Grand Total";
//
// xrCrossTabCell8
//
this.xrCrossTabCell8.ColumnIndex = 1;
this.xrCrossTabCell8.Name = "xrCrossTabCell8";
this.xrCrossTabCell8.RowIndex = 2;
//
// xrCrossTabCell9
//
this.xrCrossTabCell9.ColumnIndex = 2;
this.xrCrossTabCell9.Name = "xrCrossTabCell9";
this.xrCrossTabCell9.RowIndex = 2;
//
// TitleStyle
//
this.TitleStyle.Font = new System.Drawing.Font("Arial", 18F);
this.TitleStyle.Name = "TitleStyle";
this.TitleStyle.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
//
// xTab
//
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.ReportHeader,
this.Detail,
this.TopMargin,
this.BottomMargin
});
this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
this.sqlDataSource1
});
this.Font = new System.Drawing.Font("Arial", 9.75F);
this.HorizontalContentSplitting = DevExpress.XtraPrinting.HorizontalContentSplitting.Smart;
this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] {
this.TitleStyle,
this.crossTabGeneralStyle,
this.crossTabHeaderStyle,
this.crossTabDataStyle,
this.crossTabTotalStyle
});
this.Version = "19.2";
this.VerticalContentSplitting = DevExpress.XtraPrinting.VerticalContentSplitting.Smart;
((System.ComponentModel.ISupportInitialize)(this.crossTab1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
