/// <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();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(XtraRepNormalisedAgency));
DevExpress.XtraReports.UI.XRSummary xrSummary1 = new DevExpress.XtraReports.UI.XRSummary();
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.Group group1 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression4 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group2 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression5 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.XtraReports.UI.XRSummary xrSummary2 = new DevExpress.XtraReports.UI.XRSummary();
this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand();
this.xrlborghead = new DevExpress.XtraReports.UI.XRLabel();
this.xrlbsubHead2 = new DevExpress.XtraReports.UI.XRLabel();
this.xrPictureBox2 = new DevExpress.XtraReports.UI.XRPictureBox();
this.xrPictureBox1 = new DevExpress.XtraReports.UI.XRPictureBox();
this.xrPictureBox3 = new DevExpress.XtraReports.UI.XRPictureBox();
this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand();
this.Detail = new DevExpress.XtraReports.UI.DetailBand();
this.xrTable1 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell();
this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
this.xrlbsubHead = new DevExpress.XtraReports.UI.XRLabel();
this.ReportFooter = new DevExpress.XtraReports.UI.ReportFooterBand();
this.xrTable3 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow3 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell7 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell9 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTable2 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell();
((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// TopMargin
//
this.TopMargin.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrTable2,
this.xrlbsubHead,
this.xrlborghead,
this.xrlbsubHead2,
this.xrPictureBox2,
this.xrPictureBox1,
this.xrPictureBox3
});
this.TopMargin.HeightF = 190.625F;
this.TopMargin.Name = "TopMargin";
//
// xrlborghead
//
this.xrlborghead.Font = new System.Drawing.Font("Arial Rounded MT Bold", 13F, System.Drawing.FontStyle.Bold);
this.xrlborghead.LocationFloat = new DevExpress.Utils.PointFloat(163.1007F, 10.00001F);
this.xrlborghead.Multiline = true;
this.xrlborghead.Name = "xrlborghead";
this.xrlborghead.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrlborghead.SizeF = new System.Drawing.SizeF(435.4167F, 34.45835F);
this.xrlborghead.StylePriority.UseFont = false;
this.xrlborghead.StylePriority.UseTextAlignment = false;
this.xrlborghead.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
//
// xrlbsubHead2
//
this.xrlbsubHead2.Font = new System.Drawing.Font("Arial Rounded MT Bold", 12F, System.Drawing.FontStyle.Bold);
this.xrlbsubHead2.LocationFloat = new DevExpress.Utils.PointFloat(163.1007F, 121.1667F);
this.xrlbsubHead2.Multiline = true;
this.xrlbsubHead2.Name = "xrlbsubHead2";
this.xrlbsubHead2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrlbsubHead2.SizeF = new System.Drawing.SizeF(435.4167F, 25.08337F);
this.xrlbsubHead2.StylePriority.UseFont = false;
this.xrlbsubHead2.StylePriority.UseTextAlignment = false;
this.xrlbsubHead2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// xrPictureBox2
//
this.xrPictureBox2.ImageSource = new DevExpress.XtraPrinting.Drawing.ImageSource("img", resources.GetString("xrPictureBox2.ImageSource"));
this.xrPictureBox2.LocationFloat = new DevExpress.Utils.PointFloat(20.41667F, 10.00001F);
this.xrPictureBox2.Name = "xrPictureBox2";
this.xrPictureBox2.SizeF = new System.Drawing.SizeF(129.1667F, 122.625F);
this.xrPictureBox2.Sizing = DevExpress.XtraPrinting.ImageSizeMode.ZoomImage;
//
// xrPictureBox1
//
this.xrPictureBox1.ImageSource = new DevExpress.XtraPrinting.Drawing.ImageSource("img", resources.GetString("xrPictureBox1.ImageSource"));
this.xrPictureBox1.LocationFloat = new DevExpress.Utils.PointFloat(20.41667F, 10.00001F);
this.xrPictureBox1.Name = "xrPictureBox1";
this.xrPictureBox1.SizeF = new System.Drawing.SizeF(129.1667F, 122.625F);
this.xrPictureBox1.Sizing = DevExpress.XtraPrinting.ImageSizeMode.ZoomImage;
//
// xrPictureBox3
//
this.xrPictureBox3.ImageSource = new DevExpress.XtraPrinting.Drawing.ImageSource("img", resources.GetString("xrPictureBox3.ImageSource"));
this.xrPictureBox3.LocationFloat = new DevExpress.Utils.PointFloat(20.41667F, 10.00001F);
this.xrPictureBox3.Name = "xrPictureBox3";
this.xrPictureBox3.SizeF = new System.Drawing.SizeF(129.1667F, 122.625F);
this.xrPictureBox3.Sizing = DevExpress.XtraPrinting.ImageSizeMode.ZoomImage;
//
// BottomMargin
//
this.BottomMargin.HeightF = 25F;
this.BottomMargin.Name = "BottomMargin";
//
// Detail
//
this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrTable1
});
this.Detail.HeightF = 26.04167F;
this.Detail.Name = "Detail";
//
// xrTable1
//
this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(10.00001F, 0F);
this.xrTable1.Name = "xrTable1";
this.xrTable1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow1
});
this.xrTable1.SizeF = new System.Drawing.SizeF(629.9999F, 25F);
//
// xrTableRow1
//
this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell1,
this.xrTableCell2,
this.xrTableCell3
});
this.xrTableRow1.Name = "xrTableRow1";
this.xrTableRow1.Weight = 1D;
//
// xrTableCell1
//
this.xrTableCell1.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "sumRecordNumber([AgencyCode])")
});
this.xrTableCell1.Multiline = true;
this.xrTableCell1.Name = "xrTableCell1";
this.xrTableCell1.StylePriority.UseTextAlignment = false;
xrSummary1.Running = DevExpress.XtraReports.UI.SummaryRunning.Report;
this.xrTableCell1.Summary = xrSummary1;
this.xrTableCell1.Text = "xrTableCell1";
this.xrTableCell1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell1.Weight = 0.375D;
//
// xrTableCell2
//
this.xrTableCell2.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[AgencyName]")
});
this.xrTableCell2.Multiline = true;
this.xrTableCell2.Name = "xrTableCell2";
this.xrTableCell2.StylePriority.UseTextAlignment = false;
this.xrTableCell2.Text = "xrTableCell2";
this.xrTableCell2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell2.Weight = 1.625D;
this.xrTableCell2.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell2_BeforePrint);
this.xrTableCell2.PreviewMouseMove += new DevExpress.XtraReports.UI.PreviewMouseEventHandler(this.xrTableCell2_PreviewMouseMove);
//
// xrTableCell3
//
this.xrTableCell3.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Amount]")
});
this.xrTableCell3.Multiline = true;
this.xrTableCell3.Name = "xrTableCell3";
this.xrTableCell3.StylePriority.UseTextAlignment = false;
this.xrTableCell3.Text = "xrTableCell3";
this.xrTableCell3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell3.TextFormatString = "{0:n2}";
this.xrTableCell3.Weight = 1D;
//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionName = "Registration2ConnectionString";
this.sqlDataSource1.Name = "sqlDataSource1";
columnExpression1.ColumnName = "AgencyName";
table1.MetaSerializable = "<Meta X=\"30\" Y=\"30\" Width=\"125\" Height=\"1223\" />";
table1.Name = "ViewNormalizedPayment";
columnExpression1.Table = table1;
column1.Expression = columnExpression1;
columnExpression2.ColumnName = "AgencyCode";
columnExpression2.Table = table1;
column2.Expression = columnExpression2;
column3.Alias = "Amount";
columnExpression3.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Sum;
columnExpression3.ColumnName = "Amount";
columnExpression3.Table = table1;
column3.Expression = columnExpression3;
selectQuery1.Columns.Add(column1);
selectQuery1.Columns.Add(column2);
selectQuery1.Columns.Add(column3);
columnExpression4.ColumnName = "AgencyName";
columnExpression4.Table = table1;
group1.Expression = columnExpression4;
columnExpression5.ColumnName = "AgencyCode";
columnExpression5.Table = table1;
group2.Expression = columnExpression5;
selectQuery1.Groups.Add(group1);
selectQuery1.Groups.Add(group2);
selectQuery1.Name = "ViewNormalizedPayment";
selectQuery1.Tables.Add(table1);
this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1
});
this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable");
//
// xrlbsubHead
//
this.xrlbsubHead.Font = new System.Drawing.Font("Arial Rounded MT Bold", 11F, System.Drawing.FontStyle.Bold);
this.xrlbsubHead.LocationFloat = new DevExpress.Utils.PointFloat(163.1007F, 64.00002F);
this.xrlbsubHead.Multiline = true;
this.xrlbsubHead.Name = "xrlbsubHead";
this.xrlbsubHead.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrlbsubHead.SizeF = new System.Drawing.SizeF(453.125F, 43.83336F);
this.xrlbsubHead.StylePriority.UseFont = false;
this.xrlbsubHead.StylePriority.UseTextAlignment = false;
this.xrlbsubHead.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
//
// ReportFooter
//
this.ReportFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrTable3
});
this.ReportFooter.HeightF = 26.04167F;
this.ReportFooter.Name = "ReportFooter";
//
// xrTable3
//
this.xrTable3.LocationFloat = new DevExpress.Utils.PointFloat(350F, 0F);
this.xrTable3.Name = "xrTable3";
this.xrTable3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrTable3.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow3
});
this.xrTable3.SizeF = new System.Drawing.SizeF(300F, 25F);
//
// xrTableRow3
//
this.xrTableRow3.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell7,
this.xrTableCell9
});
this.xrTableRow3.Name = "xrTableRow3";
this.xrTableRow3.Weight = 1D;
//
// xrTableCell7
//
this.xrTableCell7.Font = new System.Drawing.Font("Arial", 9.75F, System.Drawing.FontStyle.Bold);
this.xrTableCell7.Multiline = true;
this.xrTableCell7.Name = "xrTableCell7";
this.xrTableCell7.StylePriority.UseFont = false;
this.xrTableCell7.StylePriority.UseTextAlignment = false;
this.xrTableCell7.Text = "Grand Total";
this.xrTableCell7.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell7.Weight = 0.90208221435546876D;
//
// xrTableCell9
//
this.xrTableCell9.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "sumSum([Amount])")
});
this.xrTableCell9.Multiline = true;
this.xrTableCell9.Name = "xrTableCell9";
this.xrTableCell9.StylePriority.UseTextAlignment = false;
xrSummary2.IgnoreNullValues = true;
xrSummary2.Running = DevExpress.XtraReports.UI.SummaryRunning.Report;
this.xrTableCell9.Summary = xrSummary2;
this.xrTableCell9.Text = "xrTableCell9";
this.xrTableCell9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell9.TextFormatString = "{0:n2}";
this.xrTableCell9.Weight = 2.0979177856445315D;
//
// xrTable2
//
this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(10.00004F, 165.625F);
this.xrTable2.Name = "xrTable2";
this.xrTable2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow2
});
this.xrTable2.SizeF = new System.Drawing.SizeF(630F, 25F);
//
// xrTableRow2
//
this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell4,
this.xrTableCell5,
this.xrTableCell6
});
this.xrTableRow2.Name = "xrTableRow2";
this.xrTableRow2.Weight = 1D;
//
// xrTableCell4
//
this.xrTableCell4.Multiline = true;
this.xrTableCell4.Name = "xrTableCell4";
this.xrTableCell4.StylePriority.UseTextAlignment = false;
this.xrTableCell4.Text = "SN";
this.xrTableCell4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell4.Weight = 0.37499985467819941D;
//
// xrTableCell5
//
this.xrTableCell5.Multiline = true;
this.xrTableCell5.Name = "xrTableCell5";
this.xrTableCell5.StylePriority.UseTextAlignment = false;
this.xrTableCell5.Text = "Agency Name";
this.xrTableCell5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell5.Weight = 1.6250001453218006D;
//
// xrTableCell6
//
this.xrTableCell6.Multiline = true;
this.xrTableCell6.Name = "xrTableCell6";
this.xrTableCell6.StylePriority.UseTextAlignment = false;
this.xrTableCell6.Text = "Amount";
this.xrTableCell6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell6.Weight = 1D;
//
// XtraRepNormalisedAgency
//
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.TopMargin,
this.BottomMargin,
this.Detail,
this.ReportFooter
});
this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
this.sqlDataSource1
});
this.DataMember = "ViewNormalizedPayment";
this.DataSource = this.sqlDataSource1;
this.Font = new System.Drawing.Font("Arial", 9.75F);
this.Margins = new System.Drawing.Printing.Margins(100, 100, 191, 25);
this.Version = "20.2";
((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable3)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
/// <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.Table table2 = new DevExpress.DataAccess.Sql.Table();
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.Table table3 = new DevExpress.DataAccess.Sql.Table();
DevExpress.DataAccess.Sql.Column column9 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression9 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Table table4 = new DevExpress.DataAccess.Sql.Table();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(MarketTotal));
DevExpress.DataAccess.Sql.Group group1 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression10 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.QueryParameter queryParameter1 = new DevExpress.DataAccess.Sql.QueryParameter();
DevExpress.DataAccess.Sql.QueryParameter queryParameter2 = new DevExpress.DataAccess.Sql.QueryParameter();
DevExpress.DataAccess.Sql.QueryParameter queryParameter3 = new DevExpress.DataAccess.Sql.QueryParameter();
DevExpress.DataAccess.Sql.QueryParameter queryParameter4 = new DevExpress.DataAccess.Sql.QueryParameter();
DevExpress.DataAccess.Sql.QueryParameter queryParameter5 = new DevExpress.DataAccess.Sql.QueryParameter();
DevExpress.DataAccess.Sql.QueryParameter queryParameter6 = new DevExpress.DataAccess.Sql.QueryParameter();
DevExpress.DataAccess.Sql.Join join1 = new DevExpress.DataAccess.Sql.Join();
DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo();
DevExpress.DataAccess.Sql.Join join2 = new DevExpress.DataAccess.Sql.Join();
DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo2 = new DevExpress.DataAccess.Sql.RelationColumnInfo();
DevExpress.DataAccess.Sql.Join join3 = new DevExpress.DataAccess.Sql.Join();
DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo3 = new DevExpress.DataAccess.Sql.RelationColumnInfo();
DevExpress.XtraReports.Parameters.StaticListLookUpSettings staticListLookUpSettings1 = new DevExpress.XtraReports.Parameters.StaticListLookUpSettings();
DevExpress.XtraReports.UI.XRSummary xrSummary1 = new DevExpress.XtraReports.UI.XRSummary();
DevExpress.XtraReports.UI.XRSummary xrSummary2 = new DevExpress.XtraReports.UI.XRSummary();
DevExpress.XtraReports.Parameters.StaticListLookUpSettings staticListLookUpSettings2 = new DevExpress.XtraReports.Parameters.StaticListLookUpSettings();
this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand();
this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand();
this.Detail = new DevExpress.XtraReports.UI.DetailBand();
this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand();
this.xrLabel14 = new DevExpress.XtraReports.UI.XRLabel();
this.xrPanel2 = new DevExpress.XtraReports.UI.XRPanel();
this.xrLabel10 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel11 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel12 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel13 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel29 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel42 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel43 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel();
this.DetailReport = new DevExpress.XtraReports.UI.DetailReportBand();
this.Detail1 = new DevExpress.XtraReports.UI.DetailBand();
this.xrLabel15 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel7 = new DevExpress.XtraReports.UI.XRLabel();
this.TenantId = new DevExpress.XtraReports.Parameters.Parameter();
this.paramStartDate = new DevExpress.XtraReports.Parameters.Parameter();
this.paramEndDate = new DevExpress.XtraReports.Parameters.Parameter();
this.MarketId = new DevExpress.XtraReports.Parameters.Parameter();
this.ReportFooter = new DevExpress.XtraReports.UI.ReportFooterBand();
this.xrLabel16 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel9 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLine2 = new DevExpress.XtraReports.UI.XRLine();
this.xrLabel8 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLine1 = new DevExpress.XtraReports.UI.XRLine();
this.InventoryTransType = new DevExpress.XtraReports.Parameters.Parameter();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionName = "ApplicationContext";
this.sqlDataSource1.Name = "sqlDataSource1";
column1.Alias = "OrderNumber";
columnExpression1.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Max;
columnExpression1.ColumnName = "OrderNumber";
table1.MetaSerializable = "<Meta X=\"495\" Y=\"30\" Width=\"125\" Height=\"1331\" />";
table1.Name = "Orders";
columnExpression1.Table = table1;
column1.Expression = columnExpression1;
column2.Alias = "IssueDate";
columnExpression2.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Max;
columnExpression2.ColumnName = "IssueDate";
columnExpression2.Table = table1;
column2.Expression = columnExpression2;
column3.Alias = "TenentId";
columnExpression3.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Max;
columnExpression3.ColumnName = "TenentId";
columnExpression3.Table = table1;
column3.Expression = columnExpression3;
column4.Alias = "OrderDiscount";
columnExpression4.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Max;
columnExpression4.ColumnName = "OrderDiscount";
columnExpression4.Table = table1;
column4.Expression = columnExpression4;
column5.Alias = "OrderTotal";
columnExpression5.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Max;
columnExpression5.ColumnName = "OrderTotal";
columnExpression5.Table = table1;
column5.Expression = columnExpression5;
column6.Alias = "CompanyName";
columnExpression6.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Max;
columnExpression6.ColumnName = "CompanyName";
table2.MetaSerializable = "<Meta X=\"340\" Y=\"30\" Width=\"125\" Height=\"647\" />";
table2.Name = "Account";
columnExpression6.Table = table2;
column6.Expression = columnExpression6;
columnExpression7.ColumnName = "AccountID";
columnExpression7.Table = table2;
column7.Expression = columnExpression7;
column8.Alias = "Id";
columnExpression8.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Max;
columnExpression8.ColumnName = "Id";
table3.MetaSerializable = "<Meta X=\"185\" Y=\"30\" Width=\"125\" Height=\"324\" />";
table3.Name = "MarketCustomers";
columnExpression8.Table = table3;
column8.Expression = columnExpression8;
column9.Alias = "Name";
columnExpression9.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Max;
columnExpression9.ColumnName = "Name";
table4.MetaSerializable = "<Meta X=\"30\" Y=\"30\" Width=\"125\" Height=\"267\" />";
table4.Name = "Markets";
columnExpression9.Table = table4;
column9.Expression = columnExpression9;
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.FilterString = resources.GetString("selectQuery1.FilterString");
selectQuery1.GroupFilterString = "";
columnExpression10.ColumnName = "AccountID";
columnExpression10.Table = table2;
group1.Expression = columnExpression10;
selectQuery1.Groups.Add(group1);
selectQuery1.Name = "Markets";
queryParameter1.Name = "SqlMarketId";
queryParameter1.Type = typeof(DevExpress.DataAccess.Expression);
queryParameter1.Value = new DevExpress.DataAccess.Expression("?MarketId", typeof(int));
queryParameter2.Name = "sqlDateFrom";
queryParameter2.Type = typeof(DevExpress.DataAccess.Expression);
queryParameter2.Value = new DevExpress.DataAccess.Expression("?paramStartDate", typeof(System.DateTime));
queryParameter3.Name = "sqlDateto";
queryParameter3.Type = typeof(DevExpress.DataAccess.Expression);
queryParameter3.Value = new DevExpress.DataAccess.Expression("?paramEndDate", typeof(System.DateTime));
queryParameter4.Name = "sqlTenantId";
queryParameter4.Type = typeof(DevExpress.DataAccess.Expression);
queryParameter4.Value = new DevExpress.DataAccess.Expression("?TenantId", typeof(int));
queryParameter5.Name = "InventoryTransTypeId";
queryParameter5.Type = typeof(DevExpress.DataAccess.Expression);
queryParameter5.Value = new DevExpress.DataAccess.Expression("?InventoryTransType", typeof(int));
queryParameter6.Name = "TenantId";
queryParameter6.Type = typeof(DevExpress.DataAccess.Expression);
queryParameter6.Value = new DevExpress.DataAccess.Expression("?TenantId", typeof(int));
selectQuery1.Parameters.Add(queryParameter1);
selectQuery1.Parameters.Add(queryParameter2);
selectQuery1.Parameters.Add(queryParameter3);
selectQuery1.Parameters.Add(queryParameter4);
selectQuery1.Parameters.Add(queryParameter5);
selectQuery1.Parameters.Add(queryParameter6);
relationColumnInfo1.NestedKeyColumn = "MarketId";
relationColumnInfo1.ParentKeyColumn = "Id";
join1.KeyColumns.Add(relationColumnInfo1);
join1.Nested = table3;
join1.Parent = table4;
relationColumnInfo2.NestedKeyColumn = "AccountID";
relationColumnInfo2.ParentKeyColumn = "AccountId";
join2.KeyColumns.Add(relationColumnInfo2);
join2.Nested = table2;
join2.Parent = table3;
relationColumnInfo3.NestedKeyColumn = "AccountID";
relationColumnInfo3.ParentKeyColumn = "AccountID";
join3.KeyColumns.Add(relationColumnInfo3);
join3.Nested = table1;
join3.Parent = table2;
selectQuery1.Relations.Add(join1);
selectQuery1.Relations.Add(join2);
selectQuery1.Relations.Add(join3);
selectQuery1.Tables.Add(table4);
selectQuery1.Tables.Add(table3);
selectQuery1.Tables.Add(table2);
selectQuery1.Tables.Add(table1);
this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1
});
this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable");
//
// TopMargin
//
this.TopMargin.HeightF = 6F;
this.TopMargin.Name = "TopMargin";
//
// BottomMargin
//
this.BottomMargin.HeightF = 10.875F;
this.BottomMargin.Name = "BottomMargin";
//
// Detail
//
this.Detail.HeightF = 2.333291F;
this.Detail.Name = "Detail";
//
// ReportHeader
//
this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrLabel14,
this.xrPanel2,
this.xrLabel29,
this.xrLabel42,
this.xrLabel3,
this.xrLabel43,
this.xrLabel5
});
this.ReportHeader.HeightF = 84.37503F;
this.ReportHeader.Name = "ReportHeader";
//
// xrLabel14
//
this.xrLabel14.BackColor = System.Drawing.Color.Gainsboro;
this.xrLabel14.Font = new System.Drawing.Font("Verdana", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.xrLabel14.LocationFloat = new DevExpress.Utils.PointFloat(485.1457F, 58.10579F);
this.xrLabel14.Name = "xrLabel14";
this.xrLabel14.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel14.SizeF = new System.Drawing.SizeF(145.3356F, 16.26923F);
this.xrLabel14.StylePriority.UseBackColor = false;
this.xrLabel14.StylePriority.UseFont = false;
this.xrLabel14.StylePriority.UseTextAlignment = false;
this.xrLabel14.Text = "ORDER DISCOUNT:";
this.xrLabel14.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// xrPanel2
//
this.xrPanel2.BackColor = System.Drawing.Color.Transparent;
this.xrPanel2.BorderColor = System.Drawing.Color.Black;
this.xrPanel2.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrLabel10,
this.xrLabel11,
this.xrLabel12,
this.xrLabel13
});
this.xrPanel2.LocationFloat = new DevExpress.Utils.PointFloat(3.999964F, 35.25163F);
this.xrPanel2.Name = "xrPanel2";
this.xrPanel2.SizeF = new System.Drawing.SizeF(743.0002F, 22.85416F);
this.xrPanel2.StylePriority.UseBackColor = false;
this.xrPanel2.StylePriority.UseBorderColor = false;
//
// xrLabel10
//
this.xrLabel10.BackColor = System.Drawing.Color.Transparent;
this.xrLabel10.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.xrLabel10.ForeColor = System.Drawing.Color.Black;
this.xrLabel10.LocationFloat = new DevExpress.Utils.PointFloat(135.4353F, 0F);
this.xrLabel10.Name = "xrLabel10";
this.xrLabel10.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel10.SizeF = new System.Drawing.SizeF(107.973F, 18.83335F);
this.xrLabel10.StylePriority.UseBackColor = false;
this.xrLabel10.StylePriority.UseFont = false;
this.xrLabel10.StylePriority.UseForeColor = false;
this.xrLabel10.StylePriority.UseTextAlignment = false;
this.xrLabel10.Text = "Report Period :";
this.xrLabel10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
//
// xrLabel11
//
this.xrLabel11.BackColor = System.Drawing.Color.Transparent;
this.xrLabel11.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "?paramStartDate")
});
this.xrLabel11.Font = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.xrLabel11.ForeColor = System.Drawing.Color.Black;
this.xrLabel11.LocationFloat = new DevExpress.Utils.PointFloat(243.4083F, 0F);
this.xrLabel11.Name = "xrLabel11";
this.xrLabel11.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel11.SizeF = new System.Drawing.SizeF(156.7502F, 18.83335F);
this.xrLabel11.StylePriority.UseBackColor = false;
this.xrLabel11.StylePriority.UseFont = false;
this.xrLabel11.StylePriority.UseForeColor = false;
this.xrLabel11.StylePriority.UseTextAlignment = false;
this.xrLabel11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
this.xrLabel11.TextFormatString = "{0:dd/MM/yyyy}";
//
// xrLabel12
//
this.xrLabel12.BackColor = System.Drawing.Color.Transparent;
this.xrLabel12.Font = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.xrLabel12.ForeColor = System.Drawing.Color.Black;
this.xrLabel12.LocationFloat = new DevExpress.Utils.PointFloat(400.1585F, 0F);
this.xrLabel12.Name = "xrLabel12";
this.xrLabel12.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel12.SizeF = new System.Drawing.SizeF(23.95834F, 18.83335F);
this.xrLabel12.StylePriority.UseBackColor = false;
this.xrLabel12.StylePriority.UseFont = false;
this.xrLabel12.StylePriority.UseForeColor = false;
this.xrLabel12.StylePriority.UseTextAlignment = false;
this.xrLabel12.Text = "-";
this.xrLabel12.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
//
// xrLabel13
//
this.xrLabel13.BackColor = System.Drawing.Color.Transparent;
this.xrLabel13.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "AddSeconds(?paramEndDate,-1)")
});
this.xrLabel13.Font = new System.Drawing.Font("Microsoft Sans Serif", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.xrLabel13.ForeColor = System.Drawing.Color.Black;
this.xrLabel13.LocationFloat = new DevExpress.Utils.PointFloat(424.1169F, 0F);
this.xrLabel13.Name = "xrLabel13";
this.xrLabel13.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel13.SizeF = new System.Drawing.SizeF(158.3333F, 18.83334F);
this.xrLabel13.StylePriority.UseBackColor = false;
this.xrLabel13.StylePriority.UseFont = false;
this.xrLabel13.StylePriority.UseForeColor = false;
this.xrLabel13.StylePriority.UseTextAlignment = false;
this.xrLabel13.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
this.xrLabel13.TextFormatString = "{0:dd/MM/yyyy}";
//
// xrLabel29
//
this.xrLabel29.BackColor = System.Drawing.Color.Gainsboro;
this.xrLabel29.Font = new System.Drawing.Font("Verdana", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.xrLabel29.LocationFloat = new DevExpress.Utils.PointFloat(0F, 58.10579F);
this.xrLabel29.Name = "xrLabel29";
this.xrLabel29.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel29.SizeF = new System.Drawing.SizeF(101.0132F, 16.26924F);
this.xrLabel29.StylePriority.UseBackColor = false;
this.xrLabel29.StylePriority.UseFont = false;
this.xrLabel29.StylePriority.UseTextAlignment = false;
this.xrLabel29.Text = "ORDER NO:";
this.xrLabel29.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// xrLabel42
//
this.xrLabel42.BackColor = System.Drawing.Color.Gainsboro;
this.xrLabel42.Font = new System.Drawing.Font("Verdana", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.xrLabel42.LocationFloat = new DevExpress.Utils.PointFloat(101.0129F, 58.10579F);
this.xrLabel42.Name = "xrLabel42";
this.xrLabel42.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel42.SizeF = new System.Drawing.SizeF(135.7428F, 16.26924F);
this.xrLabel42.StylePriority.UseBackColor = false;
this.xrLabel42.StylePriority.UseFont = false;
this.xrLabel42.StylePriority.UseTextAlignment = false;
this.xrLabel42.Text = "DATE:";
this.xrLabel42.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// xrLabel3
//
this.xrLabel3.BackColor = System.Drawing.Color.Gainsboro;
this.xrLabel3.Font = new System.Drawing.Font("Verdana", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(236.7557F, 58.10575F);
this.xrLabel3.Name = "xrLabel3";
this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel3.SizeF = new System.Drawing.SizeF(248.39F, 16.26923F);
this.xrLabel3.StylePriority.UseBackColor = false;
this.xrLabel3.StylePriority.UseFont = false;
this.xrLabel3.StylePriority.UseTextAlignment = false;
this.xrLabel3.Text = "ACCOUNT:";
this.xrLabel3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// xrLabel43
//
this.xrLabel43.BackColor = System.Drawing.Color.Gainsboro;
this.xrLabel43.Font = new System.Drawing.Font("Verdana", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.xrLabel43.LocationFloat = new DevExpress.Utils.PointFloat(630.4814F, 58.10579F);
this.xrLabel43.Name = "xrLabel43";
this.xrLabel43.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel43.SizeF = new System.Drawing.SizeF(116.5184F, 16.26923F);
this.xrLabel43.StylePriority.UseBackColor = false;
this.xrLabel43.StylePriority.UseFont = false;
this.xrLabel43.StylePriority.UseTextAlignment = false;
this.xrLabel43.Text = "ORDER TOTAL:";
this.xrLabel43.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// xrLabel5
//
this.xrLabel5.BackColor = System.Drawing.Color.Transparent;
this.xrLabel5.Borders = DevExpress.XtraPrinting.BorderSide.None;
this.xrLabel5.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Markets].[Name]")
});
this.xrLabel5.Font = new System.Drawing.Font("Verdana", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(3.999964F, 0F);
this.xrLabel5.Name = "xrLabel5";
this.xrLabel5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel5.SizeF = new System.Drawing.SizeF(743.0002F, 30.62501F);
this.xrLabel5.StylePriority.UseBackColor = false;
this.xrLabel5.StylePriority.UseBorders = false;
this.xrLabel5.StylePriority.UseFont = false;
this.xrLabel5.StylePriority.UseTextAlignment = false;
this.xrLabel5.Text = "Market Total";
this.xrLabel5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
//
// DetailReport
//
this.DetailReport.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.Detail1
});
this.DetailReport.DataMember = "Markets";
this.DetailReport.DataSource = this.sqlDataSource1;
this.DetailReport.Level = 0;
this.DetailReport.Name = "DetailReport";
//
// Detail1
//
this.Detail1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrLabel15,
this.xrLabel2,
this.xrLabel4,
this.xrLabel6,
this.xrLabel7
});
this.Detail1.HeightF = 30.20833F;
this.Detail1.Name = "Detail1";
//
// xrLabel15
//
this.xrLabel15.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[OrderDiscount]")
});
this.xrLabel15.LocationFloat = new DevExpress.Utils.PointFloat(485.1457F, 0F);
this.xrLabel15.Multiline = true;
this.xrLabel15.Name = "xrLabel15";
this.xrLabel15.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel15.SizeF = new System.Drawing.SizeF(134.375F, 23F);
this.xrLabel15.StylePriority.UseTextAlignment = false;
this.xrLabel15.Text = "xrLabel7";
this.xrLabel15.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// xrLabel2
//
this.xrLabel2.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[OrderNumber]")
});
this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(1.012905F, 0F);
this.xrLabel2.Multiline = true;
this.xrLabel2.Name = "xrLabel2";
this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel2.SizeF = new System.Drawing.SizeF(100F, 23F);
this.xrLabel2.Text = "xrLabel2";
//
// xrLabel4
//
this.xrLabel4.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[IssueDate]")
});
this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(101.0129F, 0F);
this.xrLabel4.Multiline = true;
this.xrLabel4.Name = "xrLabel4";
this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel4.SizeF = new System.Drawing.SizeF(135.7428F, 23F);
this.xrLabel4.Text = "xrLabel4";
this.xrLabel4.TextFormatString = "{0:d}";
//
// xrLabel6
//
this.xrLabel6.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[CompanyName]")
});
this.xrLabel6.LocationFloat = new DevExpress.Utils.PointFloat(236.7557F, 0F);
this.xrLabel6.Multiline = true;
this.xrLabel6.Name = "xrLabel6";
this.xrLabel6.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel6.SizeF = new System.Drawing.SizeF(248.39F, 23F);
this.xrLabel6.Text = "xrLabel6";
//
// xrLabel7
//
this.xrLabel7.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[OrderTotal]")
});
this.xrLabel7.LocationFloat = new DevExpress.Utils.PointFloat(619.5207F, 0F);
this.xrLabel7.Multiline = true;
this.xrLabel7.Name = "xrLabel7";
this.xrLabel7.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel7.SizeF = new System.Drawing.SizeF(127.4794F, 23F);
this.xrLabel7.StylePriority.UseTextAlignment = false;
this.xrLabel7.Text = "xrLabel7";
this.xrLabel7.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// TenantId
//
this.TenantId.Description = "Tenants";
this.TenantId.Name = "TenantId";
this.TenantId.Type = typeof(int);
this.TenantId.ValueInfo = "0";
this.TenantId.Visible = false;
//
// paramStartDate
//
this.paramStartDate.Description = "Start Date";
this.paramStartDate.Name = "paramStartDate";
this.paramStartDate.Type = typeof(System.DateTime);
this.paramStartDate.ValueInfo = "1753-12-11";
//
// paramEndDate
//
this.paramEndDate.Description = "End Date";
this.paramEndDate.Name = "paramEndDate";
this.paramEndDate.Type = typeof(System.DateTime);
this.paramEndDate.ValueInfo = "1753-12-11";
//
// MarketId
//
this.MarketId.AllowNull = true;
this.MarketId.Description = "Market";
this.MarketId.LookUpSettings = staticListLookUpSettings1;
this.MarketId.Name = "MarketId";
this.MarketId.Type = typeof(int);
//
// ReportFooter
//
this.ReportFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrLabel16,
this.xrLabel9,
this.xrLabel1,
this.xrLine2,
this.xrLabel8,
this.xrLine1
});
this.ReportFooter.HeightF = 108.75F;
this.ReportFooter.KeepTogether = true;
this.ReportFooter.Name = "ReportFooter";
//
// xrLabel16
//
this.xrLabel16.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "sumSum([Markets].[OrderDiscount])")
});
this.xrLabel16.Font = new System.Drawing.Font("Arial", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.xrLabel16.LocationFloat = new DevExpress.Utils.PointFloat(485.1457F, 32.54166F);
this.xrLabel16.Multiline = true;
this.xrLabel16.Name = "xrLabel16";
this.xrLabel16.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel16.SizeF = new System.Drawing.SizeF(134.375F, 23F);
this.xrLabel16.StylePriority.UseFont = false;
this.xrLabel16.StylePriority.UseTextAlignment = false;
xrSummary1.Running = DevExpress.XtraReports.UI.SummaryRunning.Page;
this.xrLabel16.Summary = xrSummary1;
this.xrLabel16.Text = "xrLabel16";
this.xrLabel16.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// xrLabel9
//
this.xrLabel9.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "sumSum([Markets].[OrderTotal])")
});
this.xrLabel9.Font = new System.Drawing.Font("Arial", 9.75F, System.Drawing.FontStyle.Bold);
this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(630.4814F, 32.54166F);
this.xrLabel9.Multiline = true;
this.xrLabel9.Name = "xrLabel9";
this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel9.SizeF = new System.Drawing.SizeF(110.9607F, 23F);
this.xrLabel9.StylePriority.UseFont = false;
this.xrLabel9.StylePriority.UseTextAlignment = false;
xrSummary2.Running = DevExpress.XtraReports.UI.SummaryRunning.Page;
this.xrLabel9.Summary = xrSummary2;
this.xrLabel9.Text = "xrLabel9";
this.xrLabel9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// xrLabel1
//
this.xrLabel1.Font = new System.Drawing.Font("Arial", 9.75F, System.Drawing.FontStyle.Bold);
this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(385.1457F, 32.54165F);
this.xrLabel1.Multiline = true;
this.xrLabel1.Name = "xrLabel1";
this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel1.SizeF = new System.Drawing.SizeF(100F, 23F);
this.xrLabel1.StylePriority.UseFont = false;
this.xrLabel1.Text = "Total:";
//
// xrLine2
//
this.xrLine2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
this.xrLine2.Name = "xrLine2";
this.xrLine2.SizeF = new System.Drawing.SizeF(750F, 13.62502F);
//
// xrLabel8
//
this.xrLabel8.BackColor = System.Drawing.Color.Transparent;
this.xrLabel8.Borders = DevExpress.XtraPrinting.BorderSide.None;
this.xrLabel8.BorderWidth = 0F;
this.xrLabel8.Font = new System.Drawing.Font("Verdana", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.xrLabel8.LocationFloat = new DevExpress.Utils.PointFloat(0F, 69.16667F);
this.xrLabel8.Multiline = true;
this.xrLabel8.Name = "xrLabel8";
this.xrLabel8.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel8.SizeF = new System.Drawing.SizeF(750F, 20.83333F);
this.xrLabel8.StylePriority.UseBackColor = false;
this.xrLabel8.StylePriority.UseBorderColor = false;
this.xrLabel8.StylePriority.UseBorders = false;
this.xrLabel8.StylePriority.UseBorderWidth = false;
this.xrLabel8.StylePriority.UseFont = false;
this.xrLabel8.StylePriority.UseTextAlignment = false;
this.xrLabel8.Text = "©WarehouseZone\r\n";
this.xrLabel8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
//
// xrLine1
//
this.xrLine1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 55.54165F);
this.xrLine1.Name = "xrLine1";
this.xrLine1.SizeF = new System.Drawing.SizeF(750F, 13.62502F);
//
// InventoryTransType
//
this.InventoryTransType.AllowNull = true;
this.InventoryTransType.Description = "Inventory Transaction Type";
this.InventoryTransType.LookUpSettings = staticListLookUpSettings2;
this.InventoryTransType.Name = "InventoryTransType";
this.InventoryTransType.Type = typeof(int);
//
// MarketTotal
//
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.TopMargin,
this.BottomMargin,
this.Detail,
this.ReportHeader,
this.DetailReport,
this.ReportFooter
});
this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
this.sqlDataSource1
});
this.DataMember = "Markets";
this.DataSource = this.sqlDataSource1;
this.Font = new System.Drawing.Font("Arial", 9.75F);
this.Margins = new System.Drawing.Printing.Margins(49, 46, 6, 11);
this.Parameters.AddRange(new DevExpress.XtraReports.Parameters.Parameter[] {
this.TenantId,
this.paramStartDate,
this.paramEndDate,
this.InventoryTransType,
this.MarketId
});
this.Version = "19.1";
this.DataSourceDemanded += new System.EventHandler <System.EventArgs>(this.MarketTotal_DataSourceDemanded);
this.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.MarketTotal_BeforePrint);
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
/// <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.XtraReports.UI.XRSummary xrSummary1 = new DevExpress.XtraReports.UI.XRSummary();
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.Group group1 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression6 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group2 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression7 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group3 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression8 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Sorting sorting1 = new DevExpress.DataAccess.Sql.Sorting();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression9 = new DevExpress.DataAccess.Sql.ColumnExpression();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(XtraRepTccLineSummaryAll));
this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand();
this.xrTable2 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell7 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell10 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell11 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell12 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell9 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrLabel10 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel9 = new DevExpress.XtraReports.UI.XRLabel();
this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand();
this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo();
this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo();
this.Detail = new DevExpress.XtraReports.UI.DetailBand();
this.xrTable1 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell();
this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// TopMargin
//
this.TopMargin.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrTable2,
this.xrLabel10,
this.xrLabel9
});
this.TopMargin.HeightF = 130F;
this.TopMargin.Name = "TopMargin";
//
// xrTable2
//
this.xrTable2.Font = new System.Drawing.Font("Berlin Sans FB Demi", 8F);
this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 104.7917F);
this.xrTable2.Name = "xrTable2";
this.xrTable2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow2
});
this.xrTable2.SizeF = new System.Drawing.SizeF(693F, 25F);
this.xrTable2.StylePriority.UseFont = false;
//
// xrTableRow2
//
this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell7,
this.xrTableCell10,
this.xrTableCell8,
this.xrTableCell11,
this.xrTableCell12,
this.xrTableCell9
});
this.xrTableRow2.Name = "xrTableRow2";
this.xrTableRow2.Weight = 1D;
//
// xrTableCell7
//
this.xrTableCell7.Multiline = true;
this.xrTableCell7.Name = "xrTableCell7";
this.xrTableCell7.StylePriority.UseTextAlignment = false;
this.xrTableCell7.Text = "S/N";
this.xrTableCell7.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell7.Weight = 0.30132266349647685D;
//
// xrTableCell10
//
this.xrTableCell10.Multiline = true;
this.xrTableCell10.Name = "xrTableCell10";
this.xrTableCell10.StylePriority.UseTextAlignment = false;
this.xrTableCell10.Text = "Name";
this.xrTableCell10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell10.Weight = 2.5051922123544839D;
//
// xrTableCell8
//
this.xrTableCell8.Multiline = true;
this.xrTableCell8.Name = "xrTableCell8";
this.xrTableCell8.StylePriority.UseTextAlignment = false;
this.xrTableCell8.Text = "STIN";
this.xrTableCell8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell8.Weight = 0.90492502427163968D;
//
// xrTableCell11
//
this.xrTableCell11.Multiline = true;
this.xrTableCell11.Name = "xrTableCell11";
this.xrTableCell11.StylePriority.UseTextAlignment = false;
this.xrTableCell11.Text = "Tax Office";
this.xrTableCell11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell11.Weight = 1.1049558963745407D;
//
// xrTableCell12
//
this.xrTableCell12.Multiline = true;
this.xrTableCell12.Name = "xrTableCell12";
this.xrTableCell12.StylePriority.UseTextAlignment = false;
this.xrTableCell12.Text = "Income";
this.xrTableCell12.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell12.Weight = 0.95448756324948847D;
//
// xrTableCell9
//
this.xrTableCell9.Multiline = true;
this.xrTableCell9.Name = "xrTableCell9";
this.xrTableCell9.StylePriority.UseTextAlignment = false;
this.xrTableCell9.Text = "Paid";
this.xrTableCell9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell9.Weight = 0.88293462886199747D;
//
// xrLabel10
//
this.xrLabel10.Font = new System.Drawing.Font("Bahnschrift SemiLight", 14F, System.Drawing.FontStyle.Bold);
this.xrLabel10.LocationFloat = new DevExpress.Utils.PointFloat(211.0438F, 64.125F);
this.xrLabel10.Multiline = true;
this.xrLabel10.Name = "xrLabel10";
this.xrLabel10.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel10.SizeF = new System.Drawing.SizeF(320.4439F, 30.66666F);
this.xrLabel10.StylePriority.UseFont = false;
this.xrLabel10.StylePriority.UseTextAlignment = false;
this.xrLabel10.Text = "(All)";
this.xrLabel10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// xrLabel9
//
this.xrLabel9.Font = new System.Drawing.Font("Arial Rounded MT Bold", 20F, System.Drawing.FontStyle.Bold);
this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(132.9188F, 20.95833F);
this.xrLabel9.Multiline = true;
this.xrLabel9.Name = "xrLabel9";
this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel9.SizeF = new System.Drawing.SizeF(442.0812F, 43.16666F);
this.xrLabel9.StylePriority.UseFont = false;
this.xrLabel9.StylePriority.UseTextAlignment = false;
this.xrLabel9.Text = "Tax Clearance";
this.xrLabel9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// BottomMargin
//
this.BottomMargin.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrPageInfo2,
this.xrPageInfo1
});
this.BottomMargin.HeightF = 23F;
this.BottomMargin.Name = "BottomMargin";
//
// xrPageInfo2
//
this.xrPageInfo2.Font = new System.Drawing.Font("Calisto MT", 9.75F);
this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(283.0734F, 0F);
this.xrPageInfo2.Name = "xrPageInfo2";
this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrPageInfo2.PageInfo = DevExpress.XtraPrinting.PageInfo.DateTime;
this.xrPageInfo2.SizeF = new System.Drawing.SizeF(248.4142F, 23F);
this.xrPageInfo2.StylePriority.UseFont = false;
this.xrPageInfo2.StylePriority.UseTextAlignment = false;
this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
//
// xrPageInfo1
//
this.xrPageInfo1.Font = new System.Drawing.Font("Calisto MT", 9.75F);
this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(550F, 0F);
this.xrPageInfo1.Name = "xrPageInfo1";
this.xrPageInfo1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrPageInfo1.SizeF = new System.Drawing.SizeF(100F, 23F);
this.xrPageInfo1.StylePriority.UseFont = false;
this.xrPageInfo1.StylePriority.UseTextAlignment = false;
this.xrPageInfo1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrPageInfo1.TextFormatString = "Page {0} of {1}";
//
// Detail
//
this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrTable1
});
this.Detail.HeightF = 25F;
this.Detail.Name = "Detail";
//
// xrTable1
//
this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
this.xrTable1.Name = "xrTable1";
this.xrTable1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow1
});
this.xrTable1.SizeF = new System.Drawing.SizeF(698F, 25F);
//
// xrTableRow1
//
this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell1,
this.xrTableCell4,
this.xrTableCell2,
this.xrTableCell6,
this.xrTableCell3,
this.xrTableCell5
});
this.xrTableRow1.Name = "xrTableRow1";
this.xrTableRow1.Weight = 1D;
//
// xrTableCell1
//
this.xrTableCell1.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "sumRecordNumber([Utin])")
});
this.xrTableCell1.Multiline = true;
this.xrTableCell1.Name = "xrTableCell1";
this.xrTableCell1.StylePriority.UseTextAlignment = false;
xrSummary1.Running = DevExpress.XtraReports.UI.SummaryRunning.Report;
this.xrTableCell1.Summary = xrSummary1;
this.xrTableCell1.Text = "xrTableCell1";
this.xrTableCell1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell1.Weight = 0.27563113596471006D;
//
// xrTableCell4
//
this.xrTableCell4.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[PayerName]")
});
this.xrTableCell4.Multiline = true;
this.xrTableCell4.Name = "xrTableCell4";
this.xrTableCell4.StylePriority.UseTextAlignment = false;
this.xrTableCell4.Text = "xrTableCell4";
this.xrTableCell4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell4.Weight = 2.2915930349467604D;
//
// xrTableCell2
//
this.xrTableCell2.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Utin]")
});
this.xrTableCell2.Multiline = true;
this.xrTableCell2.Name = "xrTableCell2";
this.xrTableCell2.StylePriority.UseTextAlignment = false;
this.xrTableCell2.Text = "xrTableCell2";
this.xrTableCell2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell2.Weight = 0.82776928855024745D;
this.xrTableCell2.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell2_BeforePrint);
this.xrTableCell2.PreviewMouseMove += new DevExpress.XtraReports.UI.PreviewMouseEventHandler(this.xrTableCell2_PreviewMouseMove);
//
// xrTableCell6
//
this.xrTableCell6.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[RevenueOfficeName]")
});
this.xrTableCell6.Multiline = true;
this.xrTableCell6.Name = "xrTableCell6";
this.xrTableCell6.StylePriority.UseTextAlignment = false;
this.xrTableCell6.Text = "xrTableCell6";
this.xrTableCell6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell6.Weight = 1.0107445984311D;
//
// xrTableCell3
//
this.xrTableCell3.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Income]")
});
this.xrTableCell3.Multiline = true;
this.xrTableCell3.Name = "xrTableCell3";
this.xrTableCell3.StylePriority.UseTextAlignment = false;
this.xrTableCell3.Text = "xrTableCell3";
this.xrTableCell3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell3.TextFormatString = "{0:n2}";
this.xrTableCell3.Weight = 0.87310505410968409D;
//
// xrTableCell5
//
this.xrTableCell5.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Paid]")
});
this.xrTableCell5.Multiline = true;
this.xrTableCell5.Name = "xrTableCell5";
this.xrTableCell5.StylePriority.UseTextAlignment = false;
this.xrTableCell5.Text = "xrTableCell5";
this.xrTableCell5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell5.TextFormatString = "{0:n2}";
this.xrTableCell5.Weight = 0.85156765697484926D;
//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionName = "Registration2ConnectionString";
this.sqlDataSource1.Name = "sqlDataSource1";
columnExpression1.ColumnName = "Utin";
table1.MetaSerializable = "<Meta X=\"30\" Y=\"30\" Width=\"125\" Height=\"248\" />";
table1.Name = "ViewTccDetails";
columnExpression1.Table = table1;
column1.Expression = columnExpression1;
columnExpression2.ColumnName = "PayerName";
columnExpression2.Table = table1;
column2.Expression = columnExpression2;
columnExpression3.ColumnName = "RevenueOfficeName";
columnExpression3.Table = table1;
column3.Expression = columnExpression3;
column4.Alias = "Income";
columnExpression4.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Sum;
columnExpression4.ColumnName = "Income";
columnExpression4.Table = table1;
column4.Expression = columnExpression4;
column5.Alias = "Paid";
columnExpression5.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Sum;
columnExpression5.ColumnName = "Paid";
columnExpression5.Table = table1;
column5.Expression = columnExpression5;
selectQuery1.Columns.Add(column1);
selectQuery1.Columns.Add(column2);
selectQuery1.Columns.Add(column3);
selectQuery1.Columns.Add(column4);
selectQuery1.Columns.Add(column5);
columnExpression6.ColumnName = "Utin";
columnExpression6.Table = table1;
group1.Expression = columnExpression6;
columnExpression7.ColumnName = "PayerName";
columnExpression7.Table = table1;
group2.Expression = columnExpression7;
columnExpression8.ColumnName = "RevenueOfficeName";
columnExpression8.Table = table1;
group3.Expression = columnExpression8;
selectQuery1.Groups.Add(group1);
selectQuery1.Groups.Add(group2);
selectQuery1.Groups.Add(group3);
selectQuery1.Name = "ViewTccDetails";
columnExpression9.ColumnName = "PayerName";
columnExpression9.Table = table1;
sorting1.Expression = columnExpression9;
selectQuery1.Sorting.Add(sorting1);
selectQuery1.Tables.Add(table1);
this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1
});
this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable");
//
// XtraRepTccLineSummaryAll
//
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.TopMargin,
this.BottomMargin,
this.Detail
});
this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
this.sqlDataSource1
});
this.DataMember = "ViewTccDetails";
this.DataSource = this.sqlDataSource1;
this.Font = new System.Drawing.Font("Arial Nova", 8F);
this.Margins = new System.Drawing.Printing.Margins(100, 52, 130, 23);
this.Version = "19.2";
((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
/// <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.CustomExpression customExpression1 = new DevExpress.DataAccess.Sql.CustomExpression();
DevExpress.DataAccess.Sql.Column column4 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression3 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Table table2 = new DevExpress.DataAccess.Sql.Table();
DevExpress.DataAccess.Sql.Group group1 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression4 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group2 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression5 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Join join1 = new DevExpress.DataAccess.Sql.Join();
DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo();
DevExpress.DataAccess.Sql.Sorting sorting1 = new DevExpress.DataAccess.Sql.Sorting();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression6 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Sorting sorting2 = new DevExpress.DataAccess.Sql.Sorting();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression7 = new DevExpress.DataAccess.Sql.ColumnExpression();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(XtraReport1));
this.Detail = new DevExpress.XtraReports.UI.DetailBand();
this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel();
this.xrTable1 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell();
this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand();
this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand();
this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
this.calculatedField1 = new DevExpress.XtraReports.UI.CalculatedField();
((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// Detail
//
this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrLabel2,
this.xrLabel1,
this.xrTable1
});
this.Detail.HeightF = 107.0659F;
this.Detail.Name = "Detail";
this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// xrLabel2
//
this.xrLabel2.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "Products.CategoryName")
});
this.xrLabel2.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(440.5816F, 0F);
this.xrLabel2.Name = "xrLabel2";
this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel2.SizeF = new System.Drawing.SizeF(209.4184F, 23.95833F);
this.xrLabel2.StylePriority.UseFont = false;
this.xrLabel2.StylePriority.UseTextAlignment = false;
this.xrLabel2.Text = "xrLabel2";
this.xrLabel2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
//
// xrLabel1
//
this.xrLabel1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "Products.CategoryID", "Category: {0}")
});
this.xrLabel1.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
this.xrLabel1.Name = "xrLabel1";
this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel1.SizeF = new System.Drawing.SizeF(177.5897F, 24.9566F);
this.xrLabel1.StylePriority.UseFont = false;
//
// xrTable1
//
this.xrTable1.BorderColor = System.Drawing.Color.Gainsboro;
this.xrTable1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top)
| DevExpress.XtraPrinting.BorderSide.Right)
| DevExpress.XtraPrinting.BorderSide.Bottom)));
this.xrTable1.Font = new System.Drawing.Font("Tahoma", 9.75F);
this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 26.45833F);
this.xrTable1.Name = "xrTable1";
this.xrTable1.Padding = new DevExpress.XtraPrinting.PaddingInfo(4, 4, 4, 4, 100F);
this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow2,
this.xrTableRow1
});
this.xrTable1.SizeF = new System.Drawing.SizeF(650F, 50F);
this.xrTable1.StylePriority.UseBorderColor = false;
this.xrTable1.StylePriority.UseBorders = false;
this.xrTable1.StylePriority.UseFont = false;
this.xrTable1.StylePriority.UsePadding = false;
this.xrTable1.StylePriority.UseTextAlignment = false;
this.xrTable1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
//
// xrTableRow2
//
this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell4,
this.xrTableCell5,
this.xrTableCell6
});
this.xrTableRow2.Name = "xrTableRow2";
this.xrTableRow2.Weight = 11.5D;
//
// xrTableCell4
//
this.xrTableCell4.Name = "xrTableCell4";
this.xrTableCell4.Text = "Sum (Unit Price * Units In Stock)";
this.xrTableCell4.Weight = 0.2857142857142857D;
//
// xrTableCell5
//
this.xrTableCell5.Name = "xrTableCell5";
this.xrTableCell5.Text = "Sum (Units In Stock)";
this.xrTableCell5.Weight = 0.19159405048076922D;
//
// xrTableCell6
//
this.xrTableCell6.Name = "xrTableCell6";
this.xrTableCell6.Text = "Price average (weighted over units in stock)";
this.xrTableCell6.Weight = 0.37983452094780218D;
//
// xrTableRow1
//
this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell1,
this.xrTableCell2,
this.xrTableCell3
});
this.xrTableRow1.Name = "xrTableRow1";
this.xrTableRow1.Weight = 11.5D;
//
// xrTableCell1
//
this.xrTableCell1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "Products.Sum_PriceInStock")
});
this.xrTableCell1.Name = "xrTableCell1";
this.xrTableCell1.StylePriority.UseTextAlignment = false;
this.xrTableCell1.Text = "xrTableCell1";
this.xrTableCell1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell1.Weight = 0.2857142857142857D;
//
// xrTableCell2
//
this.xrTableCell2.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "Products.Sum_UnitsInStock")
});
this.xrTableCell2.Name = "xrTableCell2";
this.xrTableCell2.StylePriority.UseTextAlignment = false;
this.xrTableCell2.Text = "xrTableCell2";
this.xrTableCell2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell2.Weight = 0.19159405048076922D;
//
// xrTableCell3
//
this.xrTableCell3.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "Products.calculatedField1", "{0:#.0000}")
});
this.xrTableCell3.Font = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Bold);
this.xrTableCell3.Name = "xrTableCell3";
this.xrTableCell3.StylePriority.UseFont = false;
this.xrTableCell3.StylePriority.UseTextAlignment = false;
this.xrTableCell3.Text = "xrTableCell3";
this.xrTableCell3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell3.Weight = 0.37983452094780218D;
//
// TopMargin
//
this.TopMargin.HeightF = 100F;
this.TopMargin.Name = "TopMargin";
this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// BottomMargin
//
this.BottomMargin.HeightF = 100F;
this.BottomMargin.Name = "BottomMargin";
this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionName = "nwind";
this.sqlDataSource1.Name = "sqlDataSource1";
column1.Alias = "Sum_UnitsInStock";
columnExpression1.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Sum;
columnExpression1.ColumnName = "UnitsInStock";
table1.Name = "Products";
columnExpression1.Table = table1;
column1.Expression = columnExpression1;
columnExpression2.ColumnName = "CategoryID";
columnExpression2.Table = table1;
column2.Expression = columnExpression2;
column3.Alias = "Sum_PriceInStock";
customExpression1.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Sum;
customExpression1.Expression = "[Products].[UnitPrice] * [Products].[UnitsInStock]";
column3.Expression = customExpression1;
columnExpression3.ColumnName = "CategoryName";
table2.Name = "Categories";
columnExpression3.Table = table2;
column4.Expression = columnExpression3;
selectQuery1.Columns.Add(column1);
selectQuery1.Columns.Add(column2);
selectQuery1.Columns.Add(column3);
selectQuery1.Columns.Add(column4);
columnExpression4.ColumnName = "CategoryID";
columnExpression4.Table = table1;
group1.Expression = columnExpression4;
columnExpression5.ColumnName = "CategoryName";
columnExpression5.Table = table2;
group2.Expression = columnExpression5;
selectQuery1.Groups.Add(group1);
selectQuery1.Groups.Add(group2);
selectQuery1.Name = "Products";
relationColumnInfo1.NestedKeyColumn = "CategoryID";
relationColumnInfo1.ParentKeyColumn = "CategoryID";
join1.KeyColumns.Add(relationColumnInfo1);
join1.Nested = table2;
join1.Parent = table1;
selectQuery1.Relations.Add(join1);
columnExpression6.ColumnName = "CategoryID";
columnExpression6.Table = table1;
sorting1.Expression = columnExpression6;
columnExpression7.ColumnName = "CategoryName";
columnExpression7.Table = table2;
sorting2.Expression = columnExpression7;
selectQuery1.Sorting.Add(sorting1);
selectQuery1.Sorting.Add(sorting2);
selectQuery1.Tables.Add(table1);
selectQuery1.Tables.Add(table2);
this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1
});
this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable");
//
// calculatedField1
//
this.calculatedField1.DataMember = "Products";
this.calculatedField1.Expression = "[Sum_PriceInStock] / [Sum_UnitsInStock]";
this.calculatedField1.Name = "calculatedField1";
//
// XtraReport1
//
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.Detail,
this.TopMargin,
this.BottomMargin
});
this.CalculatedFields.AddRange(new DevExpress.XtraReports.UI.CalculatedField[] {
this.calculatedField1
});
this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
this.sqlDataSource1
});
this.DataMember = "Products";
this.DataSource = this.sqlDataSource1;
this.Version = "16.1";
((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
/// <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.XtraReports.UI.XRSummary xrSummary1 = new DevExpress.XtraReports.UI.XRSummary();
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.Group group1 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression4 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group2 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression5 = new DevExpress.DataAccess.Sql.ColumnExpression();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(XtraRepSelfEmployed));
this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand();
this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand();
this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo();
this.Detail = new DevExpress.XtraReports.UI.DetailBand();
this.xrTable1 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell();
this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
this.PageHeader = new DevExpress.XtraReports.UI.PageHeaderBand();
this.xrTable2 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrPictureBox2 = new DevExpress.XtraReports.UI.XRPictureBox();
this.xrPictureBox1 = new DevExpress.XtraReports.UI.XRPictureBox();
this.xrPictureBox3 = new DevExpress.XtraReports.UI.XRPictureBox();
this.xrlborghead = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel();
this.xrlbsubHead = new DevExpress.XtraReports.UI.XRLabel();
this.xrlbsubHead2 = new DevExpress.XtraReports.UI.XRLabel();
((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// TopMargin
//
this.TopMargin.HeightF = 24F;
this.TopMargin.Name = "TopMargin";
//
// BottomMargin
//
this.BottomMargin.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrPageInfo1
});
this.BottomMargin.HeightF = 29F;
this.BottomMargin.Name = "BottomMargin";
//
// xrPageInfo1
//
this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(531.2499F, 3.000069F);
this.xrPageInfo1.Name = "xrPageInfo1";
this.xrPageInfo1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrPageInfo1.SizeF = new System.Drawing.SizeF(118.7501F, 23F);
this.xrPageInfo1.TextFormatString = "Page {0} of {1}";
//
// Detail
//
this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrTable1
});
this.Detail.HeightF = 26.45833F;
this.Detail.Name = "Detail";
//
// xrTable1
//
this.xrTable1.Font = new System.Drawing.Font("Arial Rounded MT Bold", 9.75F);
this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(44.79167F, 1.458327F);
this.xrTable1.Name = "xrTable1";
this.xrTable1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow1
});
this.xrTable1.SizeF = new System.Drawing.SizeF(556.245F, 25F);
this.xrTable1.StylePriority.UseFont = false;
this.xrTable1.StylePriority.UseTextAlignment = false;
this.xrTable1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
//
// xrTableRow1
//
this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell1,
this.xrTableCell2,
this.xrTableCell3
});
this.xrTableRow1.Name = "xrTableRow1";
this.xrTableRow1.Weight = 1D;
//
// xrTableCell1
//
this.xrTableCell1.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "sumRecordNumber([RevenueOfficeID])")
});
this.xrTableCell1.Multiline = true;
this.xrTableCell1.Name = "xrTableCell1";
xrSummary1.Running = DevExpress.XtraReports.UI.SummaryRunning.Report;
this.xrTableCell1.Summary = xrSummary1;
this.xrTableCell1.Text = "xrTableCell1";
this.xrTableCell1.Weight = 0.29090909090909089D;
//
// xrTableCell2
//
this.xrTableCell2.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[RevenueOfficeName]")
});
this.xrTableCell2.Multiline = true;
this.xrTableCell2.Name = "xrTableCell2";
this.xrTableCell2.Text = "xrTableCell2";
this.xrTableCell2.Weight = 2.3393941761363637D;
this.xrTableCell2.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell2_BeforePrint);
this.xrTableCell2.PreviewMouseMove += new DevExpress.XtraReports.UI.PreviewMouseEventHandler(this.xrTableCell2_PreviewMouseMove);
//
// xrTableCell3
//
this.xrTableCell3.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Rec_Count]")
});
this.xrTableCell3.Multiline = true;
this.xrTableCell3.Name = "xrTableCell3";
this.xrTableCell3.Text = "xrTableCell3";
this.xrTableCell3.Weight = 0.60603125D;
//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionName = "Registration2ConnectionString";
this.sqlDataSource1.Name = "sqlDataSource1";
column1.Alias = "Rec_Count";
columnExpression1.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Count;
columnExpression1.ColumnName = "RegTypeCode";
table1.MetaSerializable = "<Meta X=\"30\" Y=\"30\" Width=\"125\" Height=\"383\" />";
table1.Name = "vwPayerInfo";
columnExpression1.Table = table1;
column1.Expression = columnExpression1;
columnExpression2.ColumnName = "RevenueOfficeID";
columnExpression2.Table = table1;
column2.Expression = columnExpression2;
columnExpression3.ColumnName = "RevenueOfficeName";
columnExpression3.Table = table1;
column3.Expression = columnExpression3;
selectQuery1.Columns.Add(column1);
selectQuery1.Columns.Add(column2);
selectQuery1.Columns.Add(column3);
columnExpression4.ColumnName = "RevenueOfficeID";
columnExpression4.Table = table1;
group1.Expression = columnExpression4;
columnExpression5.ColumnName = "RevenueOfficeName";
columnExpression5.Table = table1;
group2.Expression = columnExpression5;
selectQuery1.Groups.Add(group1);
selectQuery1.Groups.Add(group2);
selectQuery1.Name = "vwPayerInfo";
selectQuery1.Tables.Add(table1);
this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1
});
this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable");
//
// PageHeader
//
this.PageHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrTable2,
this.xrPictureBox2,
this.xrPictureBox1,
this.xrPictureBox3,
this.xrlborghead,
this.xrLabel1,
this.xrlbsubHead,
this.xrlbsubHead2
});
this.PageHeader.HeightF = 222.9167F;
this.PageHeader.Name = "PageHeader";
//
// xrTable2
//
this.xrTable2.Font = new System.Drawing.Font("Arial Nova Cond", 9.75F, System.Drawing.FontStyle.Bold);
this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(44.79167F, 197.9167F);
this.xrTable2.Name = "xrTable2";
this.xrTable2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow2
});
this.xrTable2.SizeF = new System.Drawing.SizeF(556.245F, 25F);
this.xrTable2.StylePriority.UseFont = false;
//
// xrTableRow2
//
this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell4,
this.xrTableCell5,
this.xrTableCell6
});
this.xrTableRow2.Name = "xrTableRow2";
this.xrTableRow2.Weight = 1D;
//
// xrTableCell4
//
this.xrTableCell4.Multiline = true;
this.xrTableCell4.Name = "xrTableCell4";
this.xrTableCell4.Text = "SN";
this.xrTableCell4.Weight = 0.29091188503486887D;
//
// xrTableCell5
//
this.xrTableCell5.Multiline = true;
this.xrTableCell5.Name = "xrTableCell5";
this.xrTableCell5.Text = "Tax Office";
this.xrTableCell5.Weight = 2.3394164988343875D;
//
// xrTableCell6
//
this.xrTableCell6.Multiline = true;
this.xrTableCell6.Name = "xrTableCell6";
this.xrTableCell6.Text = "Record Count";
this.xrTableCell6.Weight = 0.60603754676596044D;
//
// xrPictureBox2
//
this.xrPictureBox2.ImageSource = new DevExpress.XtraPrinting.Drawing.ImageSource("img", resources.GetString("xrPictureBox2.ImageSource"));
this.xrPictureBox2.LocationFloat = new DevExpress.Utils.PointFloat(21.45831F, 10.00001F);
this.xrPictureBox2.Name = "xrPictureBox2";
this.xrPictureBox2.SizeF = new System.Drawing.SizeF(162.5F, 132F);
this.xrPictureBox2.Sizing = DevExpress.XtraPrinting.ImageSizeMode.ZoomImage;
//
// xrPictureBox1
//
this.xrPictureBox1.ImageSource = new DevExpress.XtraPrinting.Drawing.ImageSource("img", resources.GetString("xrPictureBox1.ImageSource"));
this.xrPictureBox1.LocationFloat = new DevExpress.Utils.PointFloat(21.45832F, 8.125067F);
this.xrPictureBox1.Name = "xrPictureBox1";
this.xrPictureBox1.SizeF = new System.Drawing.SizeF(162.5F, 132F);
this.xrPictureBox1.Sizing = DevExpress.XtraPrinting.ImageSizeMode.ZoomImage;
//
// xrPictureBox3
//
this.xrPictureBox3.ImageSource = new DevExpress.XtraPrinting.Drawing.ImageSource("img", resources.GetString("xrPictureBox3.ImageSource"));
this.xrPictureBox3.LocationFloat = new DevExpress.Utils.PointFloat(21.45832F, 10.00001F);
this.xrPictureBox3.Name = "xrPictureBox3";
this.xrPictureBox3.SizeF = new System.Drawing.SizeF(162.5F, 132F);
this.xrPictureBox3.Sizing = DevExpress.XtraPrinting.ImageSizeMode.ZoomImage;
//
// xrlborghead
//
this.xrlborghead.Font = new System.Drawing.Font("Arial Rounded MT Bold", 13F, System.Drawing.FontStyle.Bold);
this.xrlborghead.LocationFloat = new DevExpress.Utils.PointFloat(198.5173F, 4.458332F);
this.xrlborghead.Multiline = true;
this.xrlborghead.Name = "xrlborghead";
this.xrlborghead.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrlborghead.SizeF = new System.Drawing.SizeF(435.4167F, 34.45835F);
this.xrlborghead.StylePriority.UseFont = false;
this.xrlborghead.StylePriority.UseTextAlignment = false;
this.xrlborghead.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
//
// xrLabel1
//
this.xrLabel1.Font = new System.Drawing.Font("Arial Rounded MT Bold", 12F, System.Drawing.FontStyle.Bold);
this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(198.5173F, 38.91667F);
this.xrLabel1.Multiline = true;
this.xrLabel1.Name = "xrLabel1";
this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel1.SizeF = new System.Drawing.SizeF(435.4167F, 35.50002F);
this.xrLabel1.StylePriority.UseFont = false;
this.xrLabel1.StylePriority.UseTextAlignment = false;
this.xrLabel1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
//
// xrlbsubHead
//
this.xrlbsubHead.Font = new System.Drawing.Font("Arial Rounded MT Bold", 11F, System.Drawing.FontStyle.Bold);
this.xrlbsubHead.LocationFloat = new DevExpress.Utils.PointFloat(198.5173F, 74.41669F);
this.xrlbsubHead.Multiline = true;
this.xrlbsubHead.Name = "xrlbsubHead";
this.xrlbsubHead.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrlbsubHead.SizeF = new System.Drawing.SizeF(435.4167F, 43.83336F);
this.xrlbsubHead.StylePriority.UseFont = false;
this.xrlbsubHead.StylePriority.UseTextAlignment = false;
this.xrlbsubHead.Text = "TaxPayers Registered Report (Self Empolyed) \r\nby Tax Office";
this.xrlbsubHead.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
//
// xrlbsubHead2
//
this.xrlbsubHead2.Font = new System.Drawing.Font("Arial Rounded MT Bold", 12F, System.Drawing.FontStyle.Bold);
this.xrlbsubHead2.LocationFloat = new DevExpress.Utils.PointFloat(198.5173F, 118.2501F);
this.xrlbsubHead2.Multiline = true;
this.xrlbsubHead2.Name = "xrlbsubHead2";
this.xrlbsubHead2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrlbsubHead2.SizeF = new System.Drawing.SizeF(435.4167F, 25.08337F);
this.xrlbsubHead2.StylePriority.UseFont = false;
this.xrlbsubHead2.StylePriority.UseTextAlignment = false;
this.xrlbsubHead2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// XtraRepSelfEmployed
//
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.TopMargin,
this.BottomMargin,
this.Detail,
this.PageHeader
});
this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
this.sqlDataSource1
});
this.DataMember = "vwPayerInfo";
this.DataSource = this.sqlDataSource1;
this.Font = new System.Drawing.Font("Arial", 9.75F);
this.Margins = new System.Drawing.Printing.Margins(100, 64, 24, 29);
this.Version = "20.1";
((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
/// <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.Table table2 = new DevExpress.DataAccess.Sql.Table();
DevExpress.DataAccess.Sql.Column column3 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.CustomExpression customExpression1 = new DevExpress.DataAccess.Sql.CustomExpression();
DevExpress.DataAccess.Sql.Column column4 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression3 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column5 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression4 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group1 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression5 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group2 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression6 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group3 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression7 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group4 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression8 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Join join1 = new DevExpress.DataAccess.Sql.Join();
DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo();
DevExpress.DataAccess.Sql.Table table3 = new DevExpress.DataAccess.Sql.Table();
DevExpress.DataAccess.Sql.Join join2 = new DevExpress.DataAccess.Sql.Join();
DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo2 = new DevExpress.DataAccess.Sql.RelationColumnInfo();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(XtraReport1));
DevExpress.XtraCharts.XYDiagram xyDiagram1 = new DevExpress.XtraCharts.XYDiagram();
DevExpress.XtraCharts.Legend legend1 = new DevExpress.XtraCharts.Legend();
DevExpress.XtraCharts.Series series1 = new DevExpress.XtraCharts.Series();
DevExpress.XtraCharts.StackedBarSeriesView stackedBarSeriesView1 = new DevExpress.XtraCharts.StackedBarSeriesView();
DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings1 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings();
DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings2 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings();
this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
this.Detail = new DevExpress.XtraReports.UI.DetailBand();
this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand();
this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand();
this.xrChart1 = new DevExpress.XtraReports.UI.XRChart();
this.Moneda = new DevExpress.XtraReports.Parameters.Parameter();
this.UnidadArtistica = new DevExpress.XtraReports.Parameters.Parameter();
this.Desde = new DevExpress.XtraReports.Parameters.Parameter();
this.Hasta = new DevExpress.XtraReports.Parameters.Parameter();
this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand();
((System.ComponentModel.ISupportInitialize)(this.xrChart1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(xyDiagram1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(series1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(stackedBarSeriesView1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionName = "DXApplication9.Properties.Settings.artistasConnectionString";
this.sqlDataSource1.Name = "sqlDataSource1";
columnExpression1.ColumnName = "Nombre";
table1.Name = "Agrupacion";
columnExpression1.Table = table1;
column1.Expression = columnExpression1;
columnExpression2.ColumnName = "Abreviatura";
table2.Name = "TipoMoneda";
columnExpression2.Table = table2;
column2.Expression = columnExpression2;
column3.Alias = "Expr";
customExpression1.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Sum;
customExpression1.Expression = "[OrdenDeTrabajo.ImporteFinal] * (100-[OrdenDeTrabajo.PorcientoCliente])/100";
column3.Expression = customExpression1;
columnExpression3.ColumnName = "AgrupacionID";
columnExpression3.Table = table1;
column4.Expression = columnExpression3;
columnExpression4.ColumnName = "TipoMonedaID";
columnExpression4.Table = table2;
column5.Expression = columnExpression4;
selectQuery1.Columns.Add(column1);
selectQuery1.Columns.Add(column2);
selectQuery1.Columns.Add(column3);
selectQuery1.Columns.Add(column4);
selectQuery1.Columns.Add(column5);
selectQuery1.FilterString = "[OrdenDeTrabajo.Estado] <> 1s And [OrdenDeTrabajo.Estado] <> 3s";
selectQuery1.GroupFilterString = "";
columnExpression5.ColumnName = "TipoMonedaID";
columnExpression5.Table = table2;
group1.Expression = columnExpression5;
columnExpression6.ColumnName = "AgrupacionID";
columnExpression6.Table = table1;
group2.Expression = columnExpression6;
columnExpression7.ColumnName = "Nombre";
columnExpression7.Table = table1;
group3.Expression = columnExpression7;
columnExpression8.ColumnName = "Abreviatura";
columnExpression8.Table = table2;
group4.Expression = columnExpression8;
selectQuery1.Groups.Add(group1);
selectQuery1.Groups.Add(group2);
selectQuery1.Groups.Add(group3);
selectQuery1.Groups.Add(group4);
selectQuery1.Name = "Agrupacion_1";
relationColumnInfo1.NestedKeyColumn = "AgrupacionId";
relationColumnInfo1.ParentKeyColumn = "AgrupacionID";
join1.KeyColumns.Add(relationColumnInfo1);
table3.Name = "OrdenDeTrabajo";
join1.Nested = table3;
join1.Parent = table1;
relationColumnInfo2.NestedKeyColumn = "TipoMonedaID";
relationColumnInfo2.ParentKeyColumn = "TipoMonedaId";
join2.KeyColumns.Add(relationColumnInfo2);
join2.Nested = table2;
join2.Parent = table3;
selectQuery1.Relations.Add(join1);
selectQuery1.Relations.Add(join2);
selectQuery1.Tables.Add(table1);
selectQuery1.Tables.Add(table3);
selectQuery1.Tables.Add(table2);
this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1
});
this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable");
//
// Detail
//
this.Detail.Dpi = 254F;
this.Detail.HeightF = 0F;
this.Detail.KeepTogether = true;
this.Detail.Name = "Detail";
this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F);
this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// TopMargin
//
this.TopMargin.Dpi = 254F;
this.TopMargin.HeightF = 132F;
this.TopMargin.Name = "TopMargin";
this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F);
this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// BottomMargin
//
this.BottomMargin.Dpi = 254F;
this.BottomMargin.HeightF = 132F;
this.BottomMargin.Name = "BottomMargin";
this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 254F);
this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// xrChart1
//
this.xrChart1.BorderColor = System.Drawing.Color.Black;
this.xrChart1.Borders = DevExpress.XtraPrinting.BorderSide.None;
this.xrChart1.DataMember = "Agrupacion_1";
this.xrChart1.DataSource = this.sqlDataSource1;
xyDiagram1.AxisX.VisibleInPanesSerializable = "-1";
xyDiagram1.AxisY.VisibleInPanesSerializable = "-1";
xyDiagram1.DefaultPane.EnableAxisXScrolling = DevExpress.Utils.DefaultBoolean.False;
xyDiagram1.DefaultPane.EnableAxisXZooming = DevExpress.Utils.DefaultBoolean.False;
xyDiagram1.DefaultPane.EnableAxisYScrolling = DevExpress.Utils.DefaultBoolean.False;
xyDiagram1.DefaultPane.EnableAxisYZooming = DevExpress.Utils.DefaultBoolean.False;
this.xrChart1.Diagram = xyDiagram1;
this.xrChart1.Dpi = 254F;
this.xrChart1.Legend.Name = "Default Legend";
legend1.Name = "Legend1";
this.xrChart1.Legends.AddRange(new DevExpress.XtraCharts.Legend[] {
legend1
});
this.xrChart1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 24.99998F);
this.xrChart1.Name = "xrChart1";
this.xrChart1.SeriesDataMember = "TipoMonedaID";
series1.ArgumentDataMember = "Nombre";
series1.Name = "Series 4";
series1.SummaryFunction = "SUM([Expr])";
this.xrChart1.SeriesSerializable = new DevExpress.XtraCharts.Series[] {
series1
};
this.xrChart1.SeriesTemplate.ArgumentDataMember = "Expr";
this.xrChart1.SeriesTemplate.View = stackedBarSeriesView1;
this.xrChart1.SizeF = new System.Drawing.SizeF(2440.94F, 2809.044F);
//
// Moneda
//
this.Moneda.Description = "Moneda";
dynamicListLookUpSettings1.DataAdapter = null;
dynamicListLookUpSettings1.DataMember = "Agrupacion_1";
dynamicListLookUpSettings1.DataSource = this.sqlDataSource1;
dynamicListLookUpSettings1.DisplayMember = "Abreviatura";
dynamicListLookUpSettings1.ValueMember = "TipoMonedaID";
this.Moneda.LookUpSettings = dynamicListLookUpSettings1;
this.Moneda.Name = "Moneda";
this.Moneda.Type = typeof(int);
this.Moneda.ValueInfo = "0";
//
// UnidadArtistica
//
this.UnidadArtistica.Description = "Unidad Artística:";
dynamicListLookUpSettings2.DataAdapter = null;
dynamicListLookUpSettings2.DataMember = "Agrupacion_1";
dynamicListLookUpSettings2.DataSource = this.sqlDataSource1;
dynamicListLookUpSettings2.DisplayMember = "Nombre";
dynamicListLookUpSettings2.ValueMember = "AgrupacionID";
this.UnidadArtistica.LookUpSettings = dynamicListLookUpSettings2;
this.UnidadArtistica.MultiValue = true;
this.UnidadArtistica.Name = "UnidadArtistica";
this.UnidadArtistica.Type = typeof(int);
this.UnidadArtistica.ValueInfo = "0";
//
// Desde
//
this.Desde.Description = "Desde:";
this.Desde.Name = "Desde";
this.Desde.Type = typeof(System.DateTime);
//
// Hasta
//
this.Hasta.Description = "Hasta:";
this.Hasta.Name = "Hasta";
this.Hasta.Type = typeof(System.DateTime);
this.Hasta.ValueInfo = "2050-01-01";
//
// ReportHeader
//
this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrChart1
});
this.ReportHeader.Dpi = 254F;
this.ReportHeader.HeightF = 2834.044F;
this.ReportHeader.Name = "ReportHeader";
//
// XtraReport1
//
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.Detail,
this.TopMargin,
this.BottomMargin,
this.ReportHeader
});
this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
this.sqlDataSource1
});
this.DataMember = "Agrupacion_1";
this.DataSource = this.sqlDataSource1;
this.Dpi = 254F;
this.FilterString = "[AgrupacionID] In (?UnidadArtistica) And [TipoMonedaID] = ?Moneda And [FechaLiqui" +
"dacion] >= ?Desde And [FechaLiquidacion] <= ?Hasta";
this.Landscape = true;
this.Margins = new System.Drawing.Printing.Margins(178, 150, 132, 132);
this.PageHeight = 2159;
this.PageWidth = 2794;
this.PaperKind = System.Drawing.Printing.PaperKind.Custom;
this.Parameters.AddRange(new DevExpress.XtraReports.Parameters.Parameter[] {
this.Moneda,
this.UnidadArtistica,
this.Desde,
this.Hasta
});
this.ReportUnit = DevExpress.XtraReports.UI.ReportUnit.TenthsOfAMillimeter;
this.RollPaper = true;
this.SnapGridSize = 25F;
this.Version = "17.1";
((System.ComponentModel.ISupportInitialize)(xyDiagram1)).EndInit();
((System.ComponentModel.ISupportInitialize)(series1)).EndInit();
((System.ComponentModel.ISupportInitialize)(stackedBarSeriesView1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.xrChart1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
/// <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.XtraReports.UI.XRSummary xrSummary1 = new DevExpress.XtraReports.UI.XRSummary();
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.Group group1 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression4 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group2 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression5 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Sorting sorting1 = new DevExpress.DataAccess.Sql.Sorting();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression6 = new DevExpress.DataAccess.Sql.ColumnExpression();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(XtraRepCollAgency));
DevExpress.XtraReports.UI.XRSummary xrSummary2 = new DevExpress.XtraReports.UI.XRSummary();
this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand();
this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand();
this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo();
this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo();
this.Detail = new DevExpress.XtraReports.UI.DetailBand();
this.xrTable1 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell();
this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
this.PageHeader = new DevExpress.XtraReports.UI.PageHeaderBand();
this.xrTable2 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrPictureBox1 = new DevExpress.XtraReports.UI.XRPictureBox();
this.xrPictureBox3 = new DevExpress.XtraReports.UI.XRPictureBox();
this.xrPictureBox2 = new DevExpress.XtraReports.UI.XRPictureBox();
this.xrlborghead = new DevExpress.XtraReports.UI.XRLabel();
this.xrlbsubHead = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel();
this.ReportFooter = new DevExpress.XtraReports.UI.ReportFooterBand();
this.xrTable3 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow3 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell9 = new DevExpress.XtraReports.UI.XRTableCell();
((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// TopMargin
//
this.TopMargin.HeightF = 21F;
this.TopMargin.Name = "TopMargin";
//
// BottomMargin
//
this.BottomMargin.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrPageInfo1,
this.xrPageInfo2
});
this.BottomMargin.HeightF = 23F;
this.BottomMargin.Name = "BottomMargin";
//
// xrPageInfo1
//
this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(521.2499F, 0F);
this.xrPageInfo1.Name = "xrPageInfo1";
this.xrPageInfo1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrPageInfo1.SizeF = new System.Drawing.SizeF(118.7501F, 23F);
this.xrPageInfo1.StylePriority.UseTextAlignment = false;
this.xrPageInfo1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrPageInfo1.TextFormatString = "Page {0} of {1}";
//
// xrPageInfo2
//
this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(303.5414F, 0F);
this.xrPageInfo2.Name = "xrPageInfo2";
this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrPageInfo2.PageInfo = DevExpress.XtraPrinting.PageInfo.DateTime;
this.xrPageInfo2.SizeF = new System.Drawing.SizeF(217.7084F, 23F);
this.xrPageInfo2.StylePriority.UseTextAlignment = false;
this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
//
// Detail
//
this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrTable1
});
this.Detail.HeightF = 25F;
this.Detail.Name = "Detail";
//
// xrTable1
//
this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(10.00001F, 0F);
this.xrTable1.Name = "xrTable1";
this.xrTable1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow1
});
this.xrTable1.SizeF = new System.Drawing.SizeF(650.9999F, 25F);
//
// xrTableRow1
//
this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell1,
this.xrTableCell2,
this.xrTableCell3
});
this.xrTableRow1.Name = "xrTableRow1";
this.xrTableRow1.Weight = 1D;
//
// xrTableCell1
//
this.xrTableCell1.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "sumRecordNumber([AgencyCode])")
});
this.xrTableCell1.Multiline = true;
this.xrTableCell1.Name = "xrTableCell1";
this.xrTableCell1.StylePriority.UseTextAlignment = false;
xrSummary1.Running = DevExpress.XtraReports.UI.SummaryRunning.Report;
this.xrTableCell1.Summary = xrSummary1;
this.xrTableCell1.Text = "xrTableCell1";
this.xrTableCell1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell1.Weight = 0.18708786933051547D;
//
// xrTableCell2
//
this.xrTableCell2.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[AgencyName]")
});
this.xrTableCell2.Multiline = true;
this.xrTableCell2.Name = "xrTableCell2";
this.xrTableCell2.StylePriority.UseTextAlignment = false;
this.xrTableCell2.Text = "xrTableCell2";
this.xrTableCell2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell2.Weight = 1.8705159633401347D;
this.xrTableCell2.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell2_BeforePrint);
this.xrTableCell2.PreviewMouseMove += new DevExpress.XtraReports.UI.PreviewMouseEventHandler(this.xrTableCell2_PreviewMouseMove);
//
// xrTableCell3
//
this.xrTableCell3.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Amount]")
});
this.xrTableCell3.Multiline = true;
this.xrTableCell3.Name = "xrTableCell3";
this.xrTableCell3.StylePriority.UseTextAlignment = false;
this.xrTableCell3.Text = "xrTableCell3";
this.xrTableCell3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell3.TextFormatString = "{0:n2}";
this.xrTableCell3.Weight = 0.94239616732934972D;
//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionName = "Registration2ConnectionString";
this.sqlDataSource1.Name = "sqlDataSource1";
columnExpression1.ColumnName = "AgencyCode";
table1.MetaSerializable = "<Meta X=\"30\" Y=\"30\" Width=\"125\" Height=\"223\" />";
table1.Name = "vwCollection";
columnExpression1.Table = table1;
column1.Expression = columnExpression1;
columnExpression2.ColumnName = "AgencyName";
columnExpression2.Table = table1;
column2.Expression = columnExpression2;
column3.Alias = "Amount";
columnExpression3.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Sum;
columnExpression3.ColumnName = "Amount";
columnExpression3.Table = table1;
column3.Expression = columnExpression3;
selectQuery1.Columns.Add(column1);
selectQuery1.Columns.Add(column2);
selectQuery1.Columns.Add(column3);
columnExpression4.ColumnName = "AgencyCode";
columnExpression4.Table = table1;
group1.Expression = columnExpression4;
columnExpression5.ColumnName = "AgencyName";
columnExpression5.Table = table1;
group2.Expression = columnExpression5;
selectQuery1.Groups.Add(group1);
selectQuery1.Groups.Add(group2);
selectQuery1.Name = "vwCollection";
columnExpression6.ColumnName = "AgencyName";
columnExpression6.Table = table1;
sorting1.Expression = columnExpression6;
selectQuery1.Sorting.Add(sorting1);
selectQuery1.Tables.Add(table1);
this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1
});
this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable");
//
// PageHeader
//
this.PageHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrTable2,
this.xrPictureBox1,
this.xrPictureBox3,
this.xrPictureBox2,
this.xrlborghead,
this.xrlbsubHead,
this.xrLabel1
});
this.PageHeader.HeightF = 195.875F;
this.PageHeader.Name = "PageHeader";
//
// xrTable2
//
this.xrTable2.Font = new System.Drawing.Font("Arial Rounded MT Bold", 9F);
this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(10.00001F, 170.5F);
this.xrTable2.Name = "xrTable2";
this.xrTable2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow2
});
this.xrTable2.SizeF = new System.Drawing.SizeF(651F, 25F);
this.xrTable2.StylePriority.UseFont = false;
//
// xrTableRow2
//
this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell4,
this.xrTableCell5,
this.xrTableCell6
});
this.xrTableRow2.Name = "xrTableRow2";
this.xrTableRow2.Weight = 1D;
//
// xrTableCell4
//
this.xrTableCell4.Multiline = true;
this.xrTableCell4.Name = "xrTableCell4";
this.xrTableCell4.StylePriority.UseTextAlignment = false;
this.xrTableCell4.Text = "S/N";
this.xrTableCell4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell4.Weight = 0.17977968425424584D;
//
// xrTableCell5
//
this.xrTableCell5.Multiline = true;
this.xrTableCell5.Name = "xrTableCell5";
this.xrTableCell5.StylePriority.UseTextAlignment = false;
this.xrTableCell5.Text = "Agency Name";
this.xrTableCell5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell5.Weight = 1.9134204384349782D;
//
// xrTableCell6
//
this.xrTableCell6.Multiline = true;
this.xrTableCell6.Name = "xrTableCell6";
this.xrTableCell6.StylePriority.UseTextAlignment = false;
this.xrTableCell6.Text = "Amount";
this.xrTableCell6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell6.Weight = 0.90679987731077594D;
//
// xrPictureBox1
//
this.xrPictureBox1.ImageSource = new DevExpress.XtraPrinting.Drawing.ImageSource("img", resources.GetString("xrPictureBox1.ImageSource"));
this.xrPictureBox1.LocationFloat = new DevExpress.Utils.PointFloat(35.76762F, 0F);
this.xrPictureBox1.Name = "xrPictureBox1";
this.xrPictureBox1.SizeF = new System.Drawing.SizeF(128.125F, 113.25F);
this.xrPictureBox1.Sizing = DevExpress.XtraPrinting.ImageSizeMode.ZoomImage;
//
// xrPictureBox3
//
this.xrPictureBox3.ImageSource = new DevExpress.XtraPrinting.Drawing.ImageSource("img", resources.GetString("xrPictureBox3.ImageSource"));
this.xrPictureBox3.LocationFloat = new DevExpress.Utils.PointFloat(35.76762F, 0F);
this.xrPictureBox3.Name = "xrPictureBox3";
this.xrPictureBox3.SizeF = new System.Drawing.SizeF(128.125F, 113.25F);
this.xrPictureBox3.Sizing = DevExpress.XtraPrinting.ImageSizeMode.ZoomImage;
//
// xrPictureBox2
//
this.xrPictureBox2.ImageSource = new DevExpress.XtraPrinting.Drawing.ImageSource("img", resources.GetString("xrPictureBox2.ImageSource"));
this.xrPictureBox2.LocationFloat = new DevExpress.Utils.PointFloat(35.76762F, 0F);
this.xrPictureBox2.Name = "xrPictureBox2";
this.xrPictureBox2.SizeF = new System.Drawing.SizeF(128.125F, 113.25F);
this.xrPictureBox2.Sizing = DevExpress.XtraPrinting.ImageSizeMode.ZoomImage;
//
// xrlborghead
//
this.xrlborghead.Font = new System.Drawing.Font("Arial Rounded MT Bold", 18F, System.Drawing.FontStyle.Bold);
this.xrlborghead.LocationFloat = new DevExpress.Utils.PointFloat(171.7084F, 10.00001F);
this.xrlborghead.Multiline = true;
this.xrlborghead.Name = "xrlborghead";
this.xrlborghead.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrlborghead.SizeF = new System.Drawing.SizeF(461.4583F, 48.00002F);
this.xrlborghead.StylePriority.UseFont = false;
this.xrlborghead.StylePriority.UseTextAlignment = false;
this.xrlborghead.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// xrlbsubHead
//
this.xrlbsubHead.Font = new System.Drawing.Font("Arial Rounded MT Bold", 16F, System.Drawing.FontStyle.Bold);
this.xrlbsubHead.LocationFloat = new DevExpress.Utils.PointFloat(188.601F, 58.00002F);
this.xrlbsubHead.Multiline = true;
this.xrlbsubHead.Name = "xrlbsubHead";
this.xrlbsubHead.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrlbsubHead.SizeF = new System.Drawing.SizeF(343.8814F, 80.62502F);
this.xrlbsubHead.StylePriority.UseFont = false;
this.xrlbsubHead.StylePriority.UseTextAlignment = false;
this.xrlbsubHead.Text = "Revenue Collection Analysed by \r\nAgency\'s";
this.xrlbsubHead.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// xrLabel1
//
this.xrLabel1.Font = new System.Drawing.Font("Arial Rounded MT Bold", 14F);
this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(183.601F, 142.625F);
this.xrLabel1.Multiline = true;
this.xrLabel1.Name = "xrLabel1";
this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel1.SizeF = new System.Drawing.SizeF(398.0481F, 23F);
this.xrLabel1.StylePriority.UseFont = false;
this.xrLabel1.StylePriority.UseTextAlignment = false;
this.xrLabel1.Text = "xrLabel1";
this.xrLabel1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
//
// ReportFooter
//
this.ReportFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrTable3
});
this.ReportFooter.HeightF = 25.83332F;
this.ReportFooter.Name = "ReportFooter";
//
// xrTable3
//
this.xrTable3.Font = new System.Drawing.Font("Arial Rounded MT Bold", 9.75F);
this.xrTable3.LocationFloat = new DevExpress.Utils.PointFloat(356.665F, 0.7499377F);
this.xrTable3.Name = "xrTable3";
this.xrTable3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrTable3.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow3
});
this.xrTable3.SizeF = new System.Drawing.SizeF(304.335F, 25F);
this.xrTable3.StylePriority.UseFont = false;
//
// xrTableRow3
//
this.xrTableRow3.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell8,
this.xrTableCell9
});
this.xrTableRow3.Name = "xrTableRow3";
this.xrTableRow3.Weight = 1D;
//
// xrTableCell8
//
this.xrTableCell8.Multiline = true;
this.xrTableCell8.Name = "xrTableCell8";
this.xrTableCell8.StylePriority.UseTextAlignment = false;
this.xrTableCell8.Text = "Grand Total";
this.xrTableCell8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell8.Weight = 0.88161605549605193D;
//
// xrTableCell9
//
this.xrTableCell9.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "sumSum([Amount])")
});
this.xrTableCell9.Multiline = true;
this.xrTableCell9.Name = "xrTableCell9";
this.xrTableCell9.StylePriority.UseTextAlignment = false;
xrSummary2.IgnoreNullValues = true;
xrSummary2.Running = DevExpress.XtraReports.UI.SummaryRunning.Report;
this.xrTableCell9.Summary = xrSummary2;
this.xrTableCell9.Text = "xrTableCell9";
this.xrTableCell9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell9.TextFormatString = "{0:n2}";
this.xrTableCell9.Weight = 1.805883639328167D;
//
// XtraRepCollAgency
//
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.TopMargin,
this.BottomMargin,
this.Detail,
this.PageHeader,
this.ReportFooter
});
this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
this.sqlDataSource1
});
this.DataMember = "vwCollection";
this.DataSource = this.sqlDataSource1;
this.Font = new System.Drawing.Font("Arial", 9.75F);
this.Margins = new System.Drawing.Printing.Margins(100, 79, 21, 23);
this.Version = "20.1";
((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable3)).EndInit();
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
/// <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.XtraReports.UI.XRSummary xrSummary1 = new DevExpress.XtraReports.UI.XRSummary();
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.Group group1 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression4 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group2 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression5 = new DevExpress.DataAccess.Sql.ColumnExpression();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(XtraRepRevenue));
DevExpress.XtraReports.UI.XRSummary xrSummary2 = new DevExpress.XtraReports.UI.XRSummary();
this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand();
this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand();
this.Detail = new DevExpress.XtraReports.UI.DetailBand();
this.xrTable1 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell();
this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand();
this.xrlborghead = new DevExpress.XtraReports.UI.XRLabel();
this.xrPictureBox1 = new DevExpress.XtraReports.UI.XRPictureBox();
this.xrPictureBox3 = new DevExpress.XtraReports.UI.XRPictureBox();
this.xrPictureBox2 = new DevExpress.XtraReports.UI.XRPictureBox();
this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel();
this.xrTable2 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo();
this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo();
this.ReportFooter = new DevExpress.XtraReports.UI.ReportFooterBand();
this.xrTable3 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow3 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell9 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrlbsubHead = new DevExpress.XtraReports.UI.XRLabel();
((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// TopMargin
//
this.TopMargin.HeightF = 19F;
this.TopMargin.Name = "TopMargin";
//
// BottomMargin
//
this.BottomMargin.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrPageInfo2,
this.xrPageInfo1
});
this.BottomMargin.HeightF = 26F;
this.BottomMargin.Name = "BottomMargin";
//
// Detail
//
this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrTable1
});
this.Detail.HeightF = 25F;
this.Detail.Name = "Detail";
//
// xrTable1
//
this.xrTable1.Font = new System.Drawing.Font("Arial", 9F);
this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(9F, 0F);
this.xrTable1.Name = "xrTable1";
this.xrTable1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow1
});
this.xrTable1.SizeF = new System.Drawing.SizeF(650F, 25F);
this.xrTable1.StylePriority.UseFont = false;
//
// xrTableRow1
//
this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell1,
this.xrTableCell2,
this.xrTableCell3
});
this.xrTableRow1.Name = "xrTableRow1";
this.xrTableRow1.Weight = 1D;
//
// xrTableCell1
//
this.xrTableCell1.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "sumRecordNumber([RevenueCode])")
});
this.xrTableCell1.Multiline = true;
this.xrTableCell1.Name = "xrTableCell1";
this.xrTableCell1.StylePriority.UseTextAlignment = false;
xrSummary1.Running = DevExpress.XtraReports.UI.SummaryRunning.Report;
this.xrTableCell1.Summary = xrSummary1;
this.xrTableCell1.Text = "xrTableCell1";
this.xrTableCell1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell1.Weight = 0.10366017286243853D;
//
// xrTableCell2
//
this.xrTableCell2.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[RevenueName]")
});
this.xrTableCell2.Multiline = true;
this.xrTableCell2.Name = "xrTableCell2";
this.xrTableCell2.StylePriority.UseTextAlignment = false;
this.xrTableCell2.Text = "xrTableCell2";
this.xrTableCell2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell2.Weight = 2.2071736742645518D;
//
// xrTableCell3
//
this.xrTableCell3.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Amount]")
});
this.xrTableCell3.Multiline = true;
this.xrTableCell3.Name = "xrTableCell3";
this.xrTableCell3.StylePriority.UseTextAlignment = false;
this.xrTableCell3.Text = "xrTableCell3";
this.xrTableCell3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell3.TextFormatString = "{0:n2}";
this.xrTableCell3.Weight = 0.68916615287301D;
//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionName = "Registration2ConnectionString";
this.sqlDataSource1.Name = "sqlDataSource1";
columnExpression1.ColumnName = "RevenueCode";
table1.MetaSerializable = "<Meta X=\"30\" Y=\"30\" Width=\"125\" Height=\"223\" />";
table1.Name = "vwCollection";
columnExpression1.Table = table1;
column1.Expression = columnExpression1;
columnExpression2.ColumnName = "RevenueName";
columnExpression2.Table = table1;
column2.Expression = columnExpression2;
column3.Alias = "Amount";
columnExpression3.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Sum;
columnExpression3.ColumnName = "Amount";
columnExpression3.Table = table1;
column3.Expression = columnExpression3;
selectQuery1.Columns.Add(column1);
selectQuery1.Columns.Add(column2);
selectQuery1.Columns.Add(column3);
columnExpression4.ColumnName = "RevenueCode";
columnExpression4.Table = table1;
group1.Expression = columnExpression4;
columnExpression5.ColumnName = "RevenueName";
columnExpression5.Table = table1;
group2.Expression = columnExpression5;
selectQuery1.Groups.Add(group1);
selectQuery1.Groups.Add(group2);
selectQuery1.Name = "vwCollection";
selectQuery1.Tables.Add(table1);
this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1
});
this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable");
//
// ReportHeader
//
this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrlbsubHead,
this.xrTable2,
this.xrLabel1,
this.xrPictureBox2,
this.xrPictureBox3,
this.xrPictureBox1,
this.xrlborghead
});
this.ReportHeader.HeightF = 199.4583F;
this.ReportHeader.Name = "ReportHeader";
//
// xrlborghead
//
this.xrlborghead.Font = new System.Drawing.Font("Arial Rounded MT Bold", 18F, System.Drawing.FontStyle.Bold);
this.xrlborghead.LocationFloat = new DevExpress.Utils.PointFloat(183.601F, 10.00001F);
this.xrlborghead.Multiline = true;
this.xrlborghead.Name = "xrlborghead";
this.xrlborghead.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrlborghead.SizeF = new System.Drawing.SizeF(489.1491F, 48.00002F);
this.xrlborghead.StylePriority.UseFont = false;
this.xrlborghead.StylePriority.UseTextAlignment = false;
this.xrlborghead.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// xrPictureBox1
//
this.xrPictureBox1.ImageSource = new DevExpress.XtraPrinting.Drawing.ImageSource("img", resources.GetString("xrPictureBox1.ImageSource"));
this.xrPictureBox1.LocationFloat = new DevExpress.Utils.PointFloat(22.4597F, 10.00001F);
this.xrPictureBox1.Name = "xrPictureBox1";
this.xrPictureBox1.SizeF = new System.Drawing.SizeF(128.125F, 113.25F);
this.xrPictureBox1.Sizing = DevExpress.XtraPrinting.ImageSizeMode.ZoomImage;
//
// xrPictureBox3
//
this.xrPictureBox3.ImageSource = new DevExpress.XtraPrinting.Drawing.ImageSource("img", resources.GetString("xrPictureBox3.ImageSource"));
this.xrPictureBox3.LocationFloat = new DevExpress.Utils.PointFloat(22.4597F, 10.00001F);
this.xrPictureBox3.Name = "xrPictureBox3";
this.xrPictureBox3.SizeF = new System.Drawing.SizeF(128.125F, 113.25F);
this.xrPictureBox3.Sizing = DevExpress.XtraPrinting.ImageSizeMode.ZoomImage;
//
// xrPictureBox2
//
this.xrPictureBox2.ImageSource = new DevExpress.XtraPrinting.Drawing.ImageSource("img", resources.GetString("xrPictureBox2.ImageSource"));
this.xrPictureBox2.LocationFloat = new DevExpress.Utils.PointFloat(22.4597F, 10.00001F);
this.xrPictureBox2.Name = "xrPictureBox2";
this.xrPictureBox2.SizeF = new System.Drawing.SizeF(128.125F, 113.25F);
this.xrPictureBox2.Sizing = DevExpress.XtraPrinting.ImageSizeMode.ZoomImage;
//
// xrLabel1
//
this.xrLabel1.Font = new System.Drawing.Font("Arial Rounded MT Bold", 14F);
this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(183.601F, 142.625F);
this.xrLabel1.Multiline = true;
this.xrLabel1.Name = "xrLabel1";
this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel1.SizeF = new System.Drawing.SizeF(398.0481F, 23F);
this.xrLabel1.StylePriority.UseFont = false;
this.xrLabel1.StylePriority.UseTextAlignment = false;
this.xrLabel1.Text = "xrLabel1";
this.xrLabel1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
//
// xrTable2
//
this.xrTable2.Font = new System.Drawing.Font("Arial Rounded MT Bold", 9F);
this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(9F, 172.5F);
this.xrTable2.Name = "xrTable2";
this.xrTable2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow2
});
this.xrTable2.SizeF = new System.Drawing.SizeF(651F, 25F);
this.xrTable2.StylePriority.UseFont = false;
//
// xrTableRow2
//
this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell4,
this.xrTableCell5,
this.xrTableCell6
});
this.xrTableRow2.Name = "xrTableRow2";
this.xrTableRow2.Weight = 1D;
//
// xrTableCell4
//
this.xrTableCell4.Multiline = true;
this.xrTableCell4.Name = "xrTableCell4";
this.xrTableCell4.StylePriority.UseTextAlignment = false;
this.xrTableCell4.Text = "S/N";
this.xrTableCell4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell4.Weight = 0.17977968425424584D;
//
// xrTableCell5
//
this.xrTableCell5.Multiline = true;
this.xrTableCell5.Name = "xrTableCell5";
this.xrTableCell5.StylePriority.UseTextAlignment = false;
this.xrTableCell5.Text = "Revenue Name";
this.xrTableCell5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell5.Weight = 1.9134204384349782D;
//
// xrTableCell6
//
this.xrTableCell6.Multiline = true;
this.xrTableCell6.Name = "xrTableCell6";
this.xrTableCell6.StylePriority.UseTextAlignment = false;
this.xrTableCell6.Text = "Amount";
this.xrTableCell6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell6.Weight = 0.90679987731077594D;
//
// xrPageInfo2
//
this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(317.5414F, 0F);
this.xrPageInfo2.Name = "xrPageInfo2";
this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrPageInfo2.PageInfo = DevExpress.XtraPrinting.PageInfo.DateTime;
this.xrPageInfo2.SizeF = new System.Drawing.SizeF(217.7084F, 23F);
this.xrPageInfo2.StylePriority.UseTextAlignment = false;
this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
//
// xrPageInfo1
//
this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(535.2499F, 0F);
this.xrPageInfo1.Name = "xrPageInfo1";
this.xrPageInfo1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrPageInfo1.SizeF = new System.Drawing.SizeF(118.7501F, 23F);
this.xrPageInfo1.StylePriority.UseTextAlignment = false;
this.xrPageInfo1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrPageInfo1.TextFormatString = "Page {0} of {1}";
//
// ReportFooter
//
this.ReportFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrTable3
});
this.ReportFooter.HeightF = 27.79166F;
this.ReportFooter.Name = "ReportFooter";
//
// xrTable3
//
this.xrTable3.LocationFloat = new DevExpress.Utils.PointFloat(333.9583F, 2.791659F);
this.xrTable3.Name = "xrTable3";
this.xrTable3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrTable3.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow3
});
this.xrTable3.SizeF = new System.Drawing.SizeF(326.0417F, 25F);
//
// xrTableRow3
//
this.xrTableRow3.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell8,
this.xrTableCell9
});
this.xrTableRow3.Name = "xrTableRow3";
this.xrTableRow3.Weight = 1D;
//
// xrTableCell8
//
this.xrTableCell8.Multiline = true;
this.xrTableCell8.Name = "xrTableCell8";
this.xrTableCell8.StylePriority.UseTextAlignment = false;
this.xrTableCell8.Text = "Grand Total";
this.xrTableCell8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell8.Weight = 1.2926614379882813D;
//
// xrTableCell9
//
this.xrTableCell9.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "sumSum([Amount])")
});
this.xrTableCell9.Multiline = true;
this.xrTableCell9.Name = "xrTableCell9";
this.xrTableCell9.StylePriority.UseTextAlignment = false;
xrSummary2.IgnoreNullValues = true;
xrSummary2.Running = DevExpress.XtraReports.UI.SummaryRunning.Report;
this.xrTableCell9.Summary = xrSummary2;
this.xrTableCell9.Text = "xrTableCell9";
this.xrTableCell9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell9.TextFormatString = "{0:n2}";
this.xrTableCell9.Weight = 1.9677554321289061D;
//
// xrlbsubHead
//
this.xrlbsubHead.Font = new System.Drawing.Font("Arial Rounded MT Bold", 16F, System.Drawing.FontStyle.Bold);
this.xrlbsubHead.LocationFloat = new DevExpress.Utils.PointFloat(188.601F, 58.00002F);
this.xrlbsubHead.Multiline = true;
this.xrlbsubHead.Name = "xrlbsubHead";
this.xrlbsubHead.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrlbsubHead.SizeF = new System.Drawing.SizeF(445.9648F, 80.62502F);
this.xrlbsubHead.StylePriority.UseFont = false;
this.xrlbsubHead.StylePriority.UseTextAlignment = false;
this.xrlbsubHead.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// XtraRepRevenue
//
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.TopMargin,
this.BottomMargin,
this.Detail,
this.ReportHeader,
this.ReportFooter
});
this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
this.sqlDataSource1
});
this.DataMember = "vwCollection";
this.DataSource = this.sqlDataSource1;
this.Font = new System.Drawing.Font("Arial", 9.75F);
this.Margins = new System.Drawing.Printing.Margins(100, 55, 19, 26);
this.Version = "20.1";
((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable3)).EndInit();
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
/// <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.Group group1 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression6 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group2 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression7 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group3 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression8 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Sorting sorting1 = new DevExpress.DataAccess.Sql.Sorting();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression9 = new DevExpress.DataAccess.Sql.ColumnExpression();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(XtraRepTccLineYearSummary));
DevExpress.XtraReports.UI.XRSummary xrSummary1 = new DevExpress.XtraReports.UI.XRSummary();
DevExpress.XtraReports.UI.XRSummary xrSummary2 = new DevExpress.XtraReports.UI.XRSummary();
DevExpress.XtraReports.UI.XRSummary xrSummary3 = new DevExpress.XtraReports.UI.XRSummary();
this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand();
this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand();
this.Detail = new DevExpress.XtraReports.UI.DetailBand();
this.xrLabel9 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel10 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel11 = new DevExpress.XtraReports.UI.XRLabel();
this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo();
this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
this.xrTable1 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTable2 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell7 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell9 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell10 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell11 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell12 = new DevExpress.XtraReports.UI.XRTableCell();
this.GroupFooter1 = new DevExpress.XtraReports.UI.GroupFooterBand();
this.xrTable3 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow3 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell13 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell14 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell15 = new DevExpress.XtraReports.UI.XRTableCell();
((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// TopMargin
//
this.TopMargin.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrTable2,
this.xrLabel9,
this.xrLabel10,
this.xrLabel11
});
this.TopMargin.HeightF = 170F;
this.TopMargin.Name = "TopMargin";
//
// BottomMargin
//
this.BottomMargin.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrPageInfo1
});
this.BottomMargin.HeightF = 23F;
this.BottomMargin.Name = "BottomMargin";
//
// Detail
//
this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrTable1
});
this.Detail.HeightF = 25F;
this.Detail.Name = "Detail";
//
// xrLabel9
//
this.xrLabel9.Font = new System.Drawing.Font("Arial Rounded MT Bold", 20F, System.Drawing.FontStyle.Bold);
this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(56.52725F, 15.83338F);
this.xrLabel9.Multiline = true;
this.xrLabel9.Name = "xrLabel9";
this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel9.SizeF = new System.Drawing.SizeF(524.1666F, 43.16666F);
this.xrLabel9.StylePriority.UseFont = false;
this.xrLabel9.StylePriority.UseTextAlignment = false;
this.xrLabel9.Text = "Tax Clearance Report";
this.xrLabel9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// xrLabel10
//
this.xrLabel10.Font = new System.Drawing.Font("Bahnschrift SemiLight", 14F, System.Drawing.FontStyle.Bold);
this.xrLabel10.LocationFloat = new DevExpress.Utils.PointFloat(132.4439F, 89.66672F);
this.xrLabel10.Multiline = true;
this.xrLabel10.Name = "xrLabel10";
this.xrLabel10.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel10.SizeF = new System.Drawing.SizeF(359.5832F, 30.66667F);
this.xrLabel10.StylePriority.UseFont = false;
this.xrLabel10.StylePriority.UseTextAlignment = false;
this.xrLabel10.Text = "Taxpayers Line Totals";
this.xrLabel10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// xrLabel11
//
this.xrLabel11.Font = new System.Drawing.Font("Bahnschrift SemiLight", 14F, System.Drawing.FontStyle.Bold);
this.xrLabel11.LocationFloat = new DevExpress.Utils.PointFloat(109.9871F, 59.00005F);
this.xrLabel11.Multiline = true;
this.xrLabel11.Name = "xrLabel11";
this.xrLabel11.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel11.SizeF = new System.Drawing.SizeF(431.9022F, 30.66667F);
this.xrLabel11.StylePriority.UseFont = false;
this.xrLabel11.StylePriority.UseTextAlignment = false;
this.xrLabel11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// xrPageInfo1
//
this.xrPageInfo1.Font = new System.Drawing.Font("Calisto MT", 9.75F);
this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(550F, 0F);
this.xrPageInfo1.Name = "xrPageInfo1";
this.xrPageInfo1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrPageInfo1.SizeF = new System.Drawing.SizeF(100F, 23F);
this.xrPageInfo1.StylePriority.UseFont = false;
this.xrPageInfo1.TextFormatString = "Page {0} of {1}";
//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionName = "Registration2ConnectionString";
this.sqlDataSource1.Name = "sqlDataSource1";
columnExpression1.ColumnName = "Utin";
table1.MetaSerializable = "<Meta X=\"30\" Y=\"30\" Width=\"125\" Height=\"210\" />";
table1.Name = "ViewTccDetails";
columnExpression1.Table = table1;
column1.Expression = columnExpression1;
columnExpression2.ColumnName = "PayerName";
columnExpression2.Table = table1;
column2.Expression = columnExpression2;
columnExpression3.ColumnName = "RevenueOfficeName";
columnExpression3.Table = table1;
column3.Expression = columnExpression3;
column4.Alias = "Income";
columnExpression4.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Sum;
columnExpression4.ColumnName = "Income";
columnExpression4.Table = table1;
column4.Expression = columnExpression4;
column5.Alias = "Paid";
columnExpression5.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Sum;
columnExpression5.ColumnName = "Paid";
columnExpression5.Table = table1;
column5.Expression = columnExpression5;
selectQuery1.Columns.Add(column1);
selectQuery1.Columns.Add(column2);
selectQuery1.Columns.Add(column3);
selectQuery1.Columns.Add(column4);
selectQuery1.Columns.Add(column5);
columnExpression6.ColumnName = "Utin";
columnExpression6.Table = table1;
group1.Expression = columnExpression6;
columnExpression7.ColumnName = "PayerName";
columnExpression7.Table = table1;
group2.Expression = columnExpression7;
columnExpression8.ColumnName = "RevenueOfficeName";
columnExpression8.Table = table1;
group3.Expression = columnExpression8;
selectQuery1.Groups.Add(group1);
selectQuery1.Groups.Add(group2);
selectQuery1.Groups.Add(group3);
selectQuery1.Name = "ViewTccDetails";
columnExpression9.ColumnName = "PayerName";
columnExpression9.Table = table1;
sorting1.Expression = columnExpression9;
selectQuery1.Sorting.Add(sorting1);
selectQuery1.Tables.Add(table1);
this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1
});
this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable");
//
// xrTable1
//
this.xrTable1.Font = new System.Drawing.Font("Arial", 8F);
this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(10F, 0F);
this.xrTable1.Name = "xrTable1";
this.xrTable1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow1
});
this.xrTable1.SizeF = new System.Drawing.SizeF(678.9999F, 25F);
this.xrTable1.StylePriority.UseFont = false;
//
// xrTableRow1
//
this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell4,
this.xrTableCell1,
this.xrTableCell2,
this.xrTableCell5,
this.xrTableCell6,
this.xrTableCell3
});
this.xrTableRow1.Name = "xrTableRow1";
this.xrTableRow1.Weight = 1D;
//
// xrTableCell1
//
this.xrTableCell1.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[PayerName]")
});
this.xrTableCell1.Multiline = true;
this.xrTableCell1.Name = "xrTableCell1";
this.xrTableCell1.StylePriority.UseTextAlignment = false;
this.xrTableCell1.Text = "xrTableCell1";
this.xrTableCell1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell1.Weight = 2.2057415141698669D;
//
// xrTableCell2
//
this.xrTableCell2.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Utin]")
});
this.xrTableCell2.Multiline = true;
this.xrTableCell2.Name = "xrTableCell2";
this.xrTableCell2.StylePriority.UseTextAlignment = false;
this.xrTableCell2.Text = "xrTableCell2";
this.xrTableCell2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell2.Weight = 0.94150470806252506D;
this.xrTableCell2.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.xrTableCell2_BeforePrint);
this.xrTableCell2.PreviewMouseMove += new DevExpress.XtraReports.UI.PreviewMouseEventHandler(this.xrTableCell2_PreviewMouseMove);
//
// xrTableCell3
//
this.xrTableCell3.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Paid]")
});
this.xrTableCell3.Multiline = true;
this.xrTableCell3.Name = "xrTableCell3";
this.xrTableCell3.StylePriority.UseTextAlignment = false;
this.xrTableCell3.Text = "xrTableCell3";
this.xrTableCell3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell3.TextFormatString = "{0:n2}";
this.xrTableCell3.Weight = 1.0136566947287768D;
//
// xrTableCell4
//
this.xrTableCell4.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "sumRecordNumber([PayerName])")
});
this.xrTableCell4.Multiline = true;
this.xrTableCell4.Name = "xrTableCell4";
this.xrTableCell4.StylePriority.UseTextAlignment = false;
xrSummary1.Running = DevExpress.XtraReports.UI.SummaryRunning.Report;
this.xrTableCell4.Summary = xrSummary1;
this.xrTableCell4.Text = "xrTableCell4";
this.xrTableCell4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell4.Weight = 0.29109514716461593D;
//
// xrTableCell5
//
this.xrTableCell5.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[RevenueOfficeName]")
});
this.xrTableCell5.Multiline = true;
this.xrTableCell5.Name = "xrTableCell5";
this.xrTableCell5.StylePriority.UseTextAlignment = false;
this.xrTableCell5.Text = "xrTableCell5";
this.xrTableCell5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell5.Weight = 0.86351194761738226D;
//
// xrTableCell6
//
this.xrTableCell6.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Income]")
});
this.xrTableCell6.Multiline = true;
this.xrTableCell6.Name = "xrTableCell6";
this.xrTableCell6.StylePriority.UseTextAlignment = false;
this.xrTableCell6.Text = "xrTableCell6";
this.xrTableCell6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell6.TextFormatString = "{0:n2}";
this.xrTableCell6.Weight = 1.0393783252499569D;
//
// xrTable2
//
this.xrTable2.Font = new System.Drawing.Font("Arial", 9.75F, System.Drawing.FontStyle.Bold);
this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(10.00001F, 144.7917F);
this.xrTable2.Name = "xrTable2";
this.xrTable2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow2
});
this.xrTable2.SizeF = new System.Drawing.SizeF(678.9999F, 25F);
this.xrTable2.StylePriority.UseFont = false;
//
// xrTableRow2
//
this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell7,
this.xrTableCell10,
this.xrTableCell8,
this.xrTableCell9,
this.xrTableCell11,
this.xrTableCell12
});
this.xrTableRow2.Name = "xrTableRow2";
this.xrTableRow2.Weight = 1D;
//
// xrTableCell7
//
this.xrTableCell7.Multiline = true;
this.xrTableCell7.Name = "xrTableCell7";
this.xrTableCell7.StylePriority.UseTextAlignment = false;
this.xrTableCell7.Text = "S/N";
this.xrTableCell7.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell7.Weight = 0.36848044863610141D;
//
// xrTableCell8
//
this.xrTableCell8.Multiline = true;
this.xrTableCell8.Name = "xrTableCell8";
this.xrTableCell8.StylePriority.UseTextAlignment = false;
this.xrTableCell8.Text = "STIN";
this.xrTableCell8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell8.Weight = 0.99919705190349117D;
//
// xrTableCell9
//
this.xrTableCell9.Multiline = true;
this.xrTableCell9.Name = "xrTableCell9";
this.xrTableCell9.StylePriority.UseTextAlignment = false;
this.xrTableCell9.Text = "Tax Office";
this.xrTableCell9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell9.Weight = 1.0930711282315624D;
//
// xrTableCell10
//
this.xrTableCell10.Multiline = true;
this.xrTableCell10.Name = "xrTableCell10";
this.xrTableCell10.StylePriority.UseTextAlignment = false;
this.xrTableCell10.Text = "Name";
this.xrTableCell10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell10.Weight = 2.98472067976657D;
//
// xrTableCell11
//
this.xrTableCell11.Multiline = true;
this.xrTableCell11.Name = "xrTableCell11";
this.xrTableCell11.StylePriority.UseTextAlignment = false;
this.xrTableCell11.Text = "Income";
this.xrTableCell11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell11.Weight = 1.3156885788665544D;
//
// xrTableCell12
//
this.xrTableCell12.Multiline = true;
this.xrTableCell12.Name = "xrTableCell12";
this.xrTableCell12.StylePriority.UseTextAlignment = false;
this.xrTableCell12.Text = "Tax Paid";
this.xrTableCell12.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell12.Weight = 1.2831303542412242D;
//
// GroupFooter1
//
this.GroupFooter1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrTable3
});
this.GroupFooter1.HeightF = 25F;
this.GroupFooter1.Name = "GroupFooter1";
//
// xrTable3
//
this.xrTable3.LocationFloat = new DevExpress.Utils.PointFloat(349.2927F, 0F);
this.xrTable3.Name = "xrTable3";
this.xrTable3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrTable3.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow3
});
this.xrTable3.SizeF = new System.Drawing.SizeF(339.7072F, 25F);
//
// xrTableRow3
//
this.xrTableRow3.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell13,
this.xrTableCell14,
this.xrTableCell15
});
this.xrTableRow3.Name = "xrTableRow3";
this.xrTableRow3.Weight = 1D;
//
// xrTableCell13
//
this.xrTableCell13.Multiline = true;
this.xrTableCell13.Name = "xrTableCell13";
this.xrTableCell13.Text = "Total";
this.xrTableCell13.Weight = 0.49299322668607365D;
//
// xrTableCell14
//
this.xrTableCell14.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "sumSum([Income])")
});
this.xrTableCell14.Multiline = true;
this.xrTableCell14.Name = "xrTableCell14";
xrSummary2.Running = DevExpress.XtraReports.UI.SummaryRunning.Report;
this.xrTableCell14.Summary = xrSummary2;
this.xrTableCell14.Text = "xrTableCell14";
this.xrTableCell14.TextFormatString = "{0:n2}";
this.xrTableCell14.Weight = 1.30301702061166D;
//
// xrTableCell15
//
this.xrTableCell15.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "sumSum([Paid])")
});
this.xrTableCell15.Multiline = true;
this.xrTableCell15.Name = "xrTableCell15";
xrSummary3.Running = DevExpress.XtraReports.UI.SummaryRunning.Report;
this.xrTableCell15.Summary = xrSummary3;
this.xrTableCell15.Text = "xrTableCell15";
this.xrTableCell15.TextFormatString = "{0:n2}";
this.xrTableCell15.Weight = 1.3718430394473153D;
//
// XtraRepTccLineYearSummary
//
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.TopMargin,
this.BottomMargin,
this.Detail,
this.GroupFooter1
});
this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
this.sqlDataSource1
});
this.DataMember = "ViewTccDetails";
this.DataSource = this.sqlDataSource1;
this.Font = new System.Drawing.Font("Arial", 9.75F);
this.Margins = new System.Drawing.Printing.Margins(100, 61, 170, 23);
this.Version = "19.2";
((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable3)).EndInit();
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
/// <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.XtraReports.UI.XRSummary xrSummary1 = new DevExpress.XtraReports.UI.XRSummary();
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.Group group1 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression6 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group2 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression7 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group3 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression8 = new DevExpress.DataAccess.Sql.ColumnExpression();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(XtraRepTCCGeneralSummaryTaxofficeChild));
DevExpress.XtraReports.UI.XRSummary xrSummary2 = new DevExpress.XtraReports.UI.XRSummary();
DevExpress.XtraReports.UI.XRSummary xrSummary3 = new DevExpress.XtraReports.UI.XRSummary();
this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand();
this.xrLabel9 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel10 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel11 = new DevExpress.XtraReports.UI.XRLabel();
this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand();
this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo();
this.Detail = new DevExpress.XtraReports.UI.DetailBand();
this.xrTable1 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell();
this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
this.xrTable2 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell9 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell10 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell7 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell();
this.ReportFooter = new DevExpress.XtraReports.UI.ReportFooterBand();
this.xrTable3 = new DevExpress.XtraReports.UI.XRTable();
this.xrTableRow3 = new DevExpress.XtraReports.UI.XRTableRow();
this.xrTableCell11 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell12 = new DevExpress.XtraReports.UI.XRTableCell();
this.xrTableCell13 = new DevExpress.XtraReports.UI.XRTableCell();
this.groupHeaderBand1 = new DevExpress.XtraReports.UI.GroupHeaderBand();
this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel();
((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// TopMargin
//
this.TopMargin.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrLabel9,
this.xrLabel10,
this.xrLabel11
});
this.TopMargin.HeightF = 136.4583F;
this.TopMargin.Name = "TopMargin";
//
// xrLabel9
//
this.xrLabel9.Font = new System.Drawing.Font("Arial Rounded MT Bold", 20F, System.Drawing.FontStyle.Bold);
this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(59.52725F, 15.83338F);
this.xrLabel9.Multiline = true;
this.xrLabel9.Name = "xrLabel9";
this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel9.SizeF = new System.Drawing.SizeF(524.1666F, 43.16666F);
this.xrLabel9.StylePriority.UseFont = false;
this.xrLabel9.StylePriority.UseTextAlignment = false;
this.xrLabel9.Text = "Tax Clearance Certificate Issued";
this.xrLabel9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
//
// xrLabel10
//
this.xrLabel10.Font = new System.Drawing.Font("Bahnschrift SemiLight", 14F, System.Drawing.FontStyle.Bold);
this.xrLabel10.LocationFloat = new DevExpress.Utils.PointFloat(130.3606F, 64.33331F);
this.xrLabel10.Multiline = true;
this.xrLabel10.Name = "xrLabel10";
this.xrLabel10.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel10.SizeF = new System.Drawing.SizeF(359.5832F, 30.66667F);
this.xrLabel10.StylePriority.UseFont = false;
this.xrLabel10.StylePriority.UseTextAlignment = false;
this.xrLabel10.Text = "Line Summary";
this.xrLabel10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
//
// xrLabel11
//
this.xrLabel11.Font = new System.Drawing.Font("Bahnschrift SemiLight", 14F, System.Drawing.FontStyle.Bold);
this.xrLabel11.LocationFloat = new DevExpress.Utils.PointFloat(98.00005F, 93.0417F);
this.xrLabel11.Multiline = true;
this.xrLabel11.Name = "xrLabel11";
this.xrLabel11.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel11.SizeF = new System.Drawing.SizeF(431.9022F, 30.66667F);
this.xrLabel11.StylePriority.UseFont = false;
this.xrLabel11.StylePriority.UseTextAlignment = false;
this.xrLabel11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
//
// BottomMargin
//
this.BottomMargin.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrPageInfo1
});
this.BottomMargin.HeightF = 27.08333F;
this.BottomMargin.Name = "BottomMargin";
//
// xrPageInfo1
//
this.xrPageInfo1.Font = new System.Drawing.Font("Calisto MT", 9.75F);
this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(550F, 0F);
this.xrPageInfo1.Name = "xrPageInfo1";
this.xrPageInfo1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrPageInfo1.SizeF = new System.Drawing.SizeF(100F, 23F);
this.xrPageInfo1.StylePriority.UseFont = false;
this.xrPageInfo1.TextFormatString = "Page {0} of {1}";
//
// Detail
//
this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrTable1
});
this.Detail.HeightF = 27.08333F;
this.Detail.Name = "Detail";
//
// xrTable1
//
this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(59.52725F, 2.000014F);
this.xrTable1.Name = "xrTable1";
this.xrTable1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow1
});
this.xrTable1.SizeF = new System.Drawing.SizeF(590.3061F, 25F);
//
// xrTableRow1
//
this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell5,
this.xrTableCell1,
this.xrTableCell2,
this.xrTableCell3,
this.xrTableCell4
});
this.xrTableRow1.Name = "xrTableRow1";
this.xrTableRow1.Weight = 1D;
//
// xrTableCell5
//
this.xrTableCell5.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "sumRecordNumber([PayerName])")
});
this.xrTableCell5.Multiline = true;
this.xrTableCell5.Name = "xrTableCell5";
this.xrTableCell5.StylePriority.UseTextAlignment = false;
xrSummary1.IgnoreNullValues = true;
xrSummary1.Running = DevExpress.XtraReports.UI.SummaryRunning.Report;
this.xrTableCell5.Summary = xrSummary1;
this.xrTableCell5.Text = "xrTableCell5";
this.xrTableCell5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell5.Weight = 0.3407233338993827D;
//
// xrTableCell1
//
this.xrTableCell1.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[PayerName]")
});
this.xrTableCell1.Multiline = true;
this.xrTableCell1.Name = "xrTableCell1";
this.xrTableCell1.StylePriority.UseTextAlignment = false;
this.xrTableCell1.Text = "xrTableCell1";
this.xrTableCell1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell1.Weight = 2.1655406673534516D;
//
// xrTableCell2
//
this.xrTableCell2.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Utin]")
});
this.xrTableCell2.Multiline = true;
this.xrTableCell2.Name = "xrTableCell2";
this.xrTableCell2.StylePriority.UseTextAlignment = false;
this.xrTableCell2.Text = "xrTableCell2";
this.xrTableCell2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell2.Weight = 0.8308932865131311D;
//
// xrTableCell3
//
this.xrTableCell3.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Income]")
});
this.xrTableCell3.Multiline = true;
this.xrTableCell3.Name = "xrTableCell3";
this.xrTableCell3.StylePriority.UseTextAlignment = false;
this.xrTableCell3.Text = "xrTableCell3";
this.xrTableCell3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell3.TextFormatString = "{0:n2}";
this.xrTableCell3.Weight = 1.1990232200779873D;
//
// xrTableCell4
//
this.xrTableCell4.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Paid]")
});
this.xrTableCell4.Multiline = true;
this.xrTableCell4.Name = "xrTableCell4";
this.xrTableCell4.StylePriority.UseTextAlignment = false;
this.xrTableCell4.Text = "xrTableCell4";
this.xrTableCell4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell4.TextFormatString = "{0:n2}";
this.xrTableCell4.Weight = 1.100977085097794D;
//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionName = "Registration2ConnectionString";
this.sqlDataSource1.Name = "sqlDataSource1";
columnExpression1.ColumnName = "Utin";
table1.MetaSerializable = "<Meta X=\"30\" Y=\"30\" Width=\"125\" Height=\"210\" />";
table1.Name = "ViewTccDetails";
columnExpression1.Table = table1;
column1.Expression = columnExpression1;
columnExpression2.ColumnName = "PayerName";
columnExpression2.Table = table1;
column2.Expression = columnExpression2;
column3.Alias = "Income";
columnExpression3.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Sum;
columnExpression3.ColumnName = "Income";
columnExpression3.Table = table1;
column3.Expression = columnExpression3;
column4.Alias = "Paid";
columnExpression4.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Sum;
columnExpression4.ColumnName = "Paid";
columnExpression4.Table = table1;
column4.Expression = columnExpression4;
columnExpression5.ColumnName = "RevenueOfficeName";
columnExpression5.Table = table1;
column5.Expression = columnExpression5;
selectQuery1.Columns.Add(column1);
selectQuery1.Columns.Add(column2);
selectQuery1.Columns.Add(column3);
selectQuery1.Columns.Add(column4);
selectQuery1.Columns.Add(column5);
columnExpression6.ColumnName = "Utin";
columnExpression6.Table = table1;
group1.Expression = columnExpression6;
columnExpression7.ColumnName = "PayerName";
columnExpression7.Table = table1;
group2.Expression = columnExpression7;
columnExpression8.ColumnName = "RevenueOfficeName";
columnExpression8.Table = table1;
group3.Expression = columnExpression8;
selectQuery1.Groups.Add(group1);
selectQuery1.Groups.Add(group2);
selectQuery1.Groups.Add(group3);
selectQuery1.Name = "ViewTccDetails";
selectQuery1.Tables.Add(table1);
this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1
});
this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable");
//
// xrTable2
//
this.xrTable2.Font = new System.Drawing.Font("Bahnschrift SemiBold SemiConden", 9.75F);
this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(49.52733F, 22.99999F);
this.xrTable2.Name = "xrTable2";
this.xrTable2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow2
});
this.xrTable2.SizeF = new System.Drawing.SizeF(590.4727F, 25F);
this.xrTable2.StylePriority.UseFont = false;
//
// xrTableRow2
//
this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell6,
this.xrTableCell9,
this.xrTableCell10,
this.xrTableCell7,
this.xrTableCell8
});
this.xrTableRow2.Name = "xrTableRow2";
this.xrTableRow2.Weight = 1D;
//
// xrTableCell6
//
this.xrTableCell6.Multiline = true;
this.xrTableCell6.Name = "xrTableCell6";
this.xrTableCell6.StylePriority.UseTextAlignment = false;
this.xrTableCell6.Text = "S/N";
this.xrTableCell6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell6.Weight = 0.32143715471862611D;
//
// xrTableCell9
//
this.xrTableCell9.Multiline = true;
this.xrTableCell9.Name = "xrTableCell9";
this.xrTableCell9.StylePriority.UseTextAlignment = false;
this.xrTableCell9.Text = "Name";
this.xrTableCell9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell9.Weight = 2.0429633715050688D;
//
// xrTableCell10
//
this.xrTableCell10.Multiline = true;
this.xrTableCell10.Name = "xrTableCell10";
this.xrTableCell10.StylePriority.UseTextAlignment = false;
this.xrTableCell10.Text = "STIN";
this.xrTableCell10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell10.Weight = 0.78386151153907813D;
//
// xrTableCell7
//
this.xrTableCell7.Multiline = true;
this.xrTableCell7.Name = "xrTableCell7";
this.xrTableCell7.StylePriority.UseTextAlignment = false;
this.xrTableCell7.Text = "Income";
this.xrTableCell7.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell7.Weight = 1.0001415660360435D;
//
// xrTableCell8
//
this.xrTableCell8.Multiline = true;
this.xrTableCell8.Name = "xrTableCell8";
this.xrTableCell8.StylePriority.UseTextAlignment = false;
this.xrTableCell8.Text = "Tax Paid";
this.xrTableCell8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell8.Weight = 1.171171189995424D;
//
// ReportFooter
//
this.ReportFooter.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrTable3
});
this.ReportFooter.HeightF = 25F;
this.ReportFooter.Name = "ReportFooter";
//
// xrTable3
//
this.xrTable3.Font = new System.Drawing.Font("Bahnschrift SemiBold SemiConden", 9.75F);
this.xrTable3.LocationFloat = new DevExpress.Utils.PointFloat(350F, 0F);
this.xrTable3.Name = "xrTable3";
this.xrTable3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F);
this.xrTable3.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] {
this.xrTableRow3
});
this.xrTable3.SizeF = new System.Drawing.SizeF(300F, 25F);
this.xrTable3.StylePriority.UseFont = false;
//
// xrTableRow3
//
this.xrTableRow3.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] {
this.xrTableCell11,
this.xrTableCell12,
this.xrTableCell13
});
this.xrTableRow3.Name = "xrTableRow3";
this.xrTableRow3.Weight = 1D;
//
// xrTableCell11
//
this.xrTableCell11.Multiline = true;
this.xrTableCell11.Name = "xrTableCell11";
this.xrTableCell11.StylePriority.UseTextAlignment = false;
this.xrTableCell11.Text = "Total";
this.xrTableCell11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
this.xrTableCell11.Weight = 0.58984283447265629D;
//
// xrTableCell12
//
this.xrTableCell12.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "sumSum([Income])")
});
this.xrTableCell12.Multiline = true;
this.xrTableCell12.Name = "xrTableCell12";
this.xrTableCell12.StylePriority.UseTextAlignment = false;
xrSummary2.IgnoreNullValues = true;
xrSummary2.Running = DevExpress.XtraReports.UI.SummaryRunning.Report;
this.xrTableCell12.Summary = xrSummary2;
this.xrTableCell12.Text = "xrTableCell12";
this.xrTableCell12.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell12.TextFormatString = "{0:n2}";
this.xrTableCell12.Weight = 1.2555810546875D;
//
// xrTableCell13
//
this.xrTableCell13.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "sumSum([Paid])")
});
this.xrTableCell13.Multiline = true;
this.xrTableCell13.Name = "xrTableCell13";
this.xrTableCell13.StylePriority.UseTextAlignment = false;
xrSummary3.IgnoreNullValues = true;
xrSummary3.Running = DevExpress.XtraReports.UI.SummaryRunning.Report;
this.xrTableCell13.Summary = xrSummary3;
this.xrTableCell13.Text = "xrTableCell13";
this.xrTableCell13.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
this.xrTableCell13.TextFormatString = "{0:n2}";
this.xrTableCell13.Weight = 1.1545761108398438D;
//
// groupHeaderBand1
//
this.groupHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrTable2,
this.xrLabel2,
this.xrLabel1
});
this.groupHeaderBand1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] {
new DevExpress.XtraReports.UI.GroupField("RevenueOfficeName", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending)
});
this.groupHeaderBand1.HeightF = 48.95833F;
this.groupHeaderBand1.Name = "groupHeaderBand1";
//
// xrLabel2
//
this.xrLabel2.Font = new System.Drawing.Font("Bahnschrift SemiBold SemiConden", 9.75F);
this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(19.16509F, 0F);
this.xrLabel2.Multiline = true;
this.xrLabel2.Name = "xrLabel2";
this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel2.SizeF = new System.Drawing.SizeF(76.04169F, 23F);
this.xrLabel2.StylePriority.UseFont = false;
this.xrLabel2.StylePriority.UseTextAlignment = false;
this.xrLabel2.Text = "Tax Office";
this.xrLabel2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
//
// xrLabel1
//
this.xrLabel1.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] {
new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[RevenueOfficeName]")
});
this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(145.8333F, 0F);
this.xrLabel1.Multiline = true;
this.xrLabel1.Name = "xrLabel1";
this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel1.SizeF = new System.Drawing.SizeF(145.8333F, 23F);
this.xrLabel1.StylePriority.UseTextAlignment = false;
this.xrLabel1.Text = "xrLabel1";
this.xrLabel1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
//
// XtraRepTCCGeneralSummaryTaxofficeChild
//
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.TopMargin,
this.BottomMargin,
this.Detail,
this.ReportFooter,
this.groupHeaderBand1
});
this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
this.sqlDataSource1
});
this.DataMember = "ViewTccDetails";
this.DataSource = this.sqlDataSource1;
this.Font = new System.Drawing.Font("Arial", 9.75F);
this.Margins = new System.Drawing.Printing.Margins(100, 100, 136, 27);
this.Version = "19.2";
((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.xrTable3)).EndInit();
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
/// <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.Group group1 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression11 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group2 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression12 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group3 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression13 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group4 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression14 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group5 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression15 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group6 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression16 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group7 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression17 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group8 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression18 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group9 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression19 = new DevExpress.DataAccess.Sql.ColumnExpression();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(XtraRepTrendAnalysis));
this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand();
this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand();
this.Detail = new DevExpress.XtraReports.UI.DetailBand();
this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
this.xrPivotGrid1 = new DevExpress.XtraReports.UI.XRPivotGrid();
this.fieldTaxAgentTIN = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField();
this.fieldOrganizationName = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField();
this.fieldAmount = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField();
this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo();
this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// TopMargin
//
this.TopMargin.Name = "TopMargin";
//
// BottomMargin
//
this.BottomMargin.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrPageInfo2,
this.xrPageInfo1
});
this.BottomMargin.HeightF = 23.33336F;
this.BottomMargin.Name = "BottomMargin";
//
// Detail
//
this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrPivotGrid1
});
this.Detail.HeightF = 94.37498F;
this.Detail.Name = "Detail";
//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionName = "Registration2ConnectionString";
this.sqlDataSource1.Name = "sqlDataSource1";
columnExpression1.ColumnName = "Period";
table1.MetaSerializable = "<Meta X=\"60\" Y=\"30\" Width=\"190\" Height=\"383\" />";
table1.Name = "ViewdefaulterAnalysis";
columnExpression1.Table = table1;
column1.Expression = columnExpression1;
columnExpression2.ColumnName = "Months";
columnExpression2.Table = table1;
column2.Expression = columnExpression2;
columnExpression3.ColumnName = "TaxYear";
columnExpression3.Table = table1;
column3.Expression = columnExpression3;
columnExpression4.ColumnName = "OrganizationName";
columnExpression4.Table = table1;
column4.Expression = columnExpression4;
columnExpression5.ColumnName = "TaxAgentTIN";
columnExpression5.Table = table1;
column5.Expression = columnExpression5;
columnExpression6.ColumnName = "RevenueCode";
columnExpression6.Table = table1;
column6.Expression = columnExpression6;
columnExpression7.ColumnName = "RevenueName";
columnExpression7.Table = table1;
column7.Expression = columnExpression7;
columnExpression8.ColumnName = "RevenueOfficeID";
columnExpression8.Table = table1;
column8.Expression = columnExpression8;
columnExpression9.ColumnName = "RevenueOfficeName";
columnExpression9.Table = table1;
column9.Expression = columnExpression9;
column10.Alias = "Amount";
columnExpression10.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Sum;
columnExpression10.ColumnName = "Amount";
columnExpression10.Table = table1;
column10.Expression = columnExpression10;
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);
columnExpression11.ColumnName = "Period";
columnExpression11.Table = table1;
group1.Expression = columnExpression11;
columnExpression12.ColumnName = "Months";
columnExpression12.Table = table1;
group2.Expression = columnExpression12;
columnExpression13.ColumnName = "TaxYear";
columnExpression13.Table = table1;
group3.Expression = columnExpression13;
columnExpression14.ColumnName = "OrganizationName";
columnExpression14.Table = table1;
group4.Expression = columnExpression14;
columnExpression15.ColumnName = "TaxAgentTIN";
columnExpression15.Table = table1;
group5.Expression = columnExpression15;
columnExpression16.ColumnName = "RevenueCode";
columnExpression16.Table = table1;
group6.Expression = columnExpression16;
columnExpression17.ColumnName = "RevenueName";
columnExpression17.Table = table1;
group7.Expression = columnExpression17;
columnExpression18.ColumnName = "RevenueOfficeID";
columnExpression18.Table = table1;
group8.Expression = columnExpression18;
columnExpression19.ColumnName = "RevenueOfficeName";
columnExpression19.Table = table1;
group9.Expression = columnExpression19;
selectQuery1.Groups.Add(group1);
selectQuery1.Groups.Add(group2);
selectQuery1.Groups.Add(group3);
selectQuery1.Groups.Add(group4);
selectQuery1.Groups.Add(group5);
selectQuery1.Groups.Add(group6);
selectQuery1.Groups.Add(group7);
selectQuery1.Groups.Add(group8);
selectQuery1.Groups.Add(group9);
selectQuery1.Name = "ViewdefaulterAnalysis";
selectQuery1.Tables.Add(table1);
this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1
});
this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable");
//
// xrPivotGrid1
//
this.xrPivotGrid1.Appearance.Cell.Font = new System.Drawing.Font("Tahoma", 8.25F);
this.xrPivotGrid1.Appearance.CustomTotalCell.Font = new System.Drawing.Font("Tahoma", 8.25F);
this.xrPivotGrid1.Appearance.FieldHeader.Font = new System.Drawing.Font("Tahoma", 8.25F);
this.xrPivotGrid1.Appearance.FieldValue.Font = new System.Drawing.Font("Tahoma", 8.25F);
this.xrPivotGrid1.Appearance.FieldValueGrandTotal.Font = new System.Drawing.Font("Tahoma", 8.25F);
this.xrPivotGrid1.Appearance.FieldValueTotal.Font = new System.Drawing.Font("Tahoma", 8.25F);
this.xrPivotGrid1.Appearance.GrandTotalCell.Font = new System.Drawing.Font("Tahoma", 8.25F);
this.xrPivotGrid1.Appearance.Lines.Font = new System.Drawing.Font("Tahoma", 8.25F);
this.xrPivotGrid1.Appearance.TotalCell.Font = new System.Drawing.Font("Tahoma", 8.25F);
this.xrPivotGrid1.DataMember = "ViewdefaulterAnalysis";
this.xrPivotGrid1.DataSource = this.sqlDataSource1;
this.xrPivotGrid1.Fields.AddRange(new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField[] {
this.fieldTaxAgentTIN,
this.fieldOrganizationName,
this.fieldAmount
});
this.xrPivotGrid1.LocationFloat = new DevExpress.Utils.PointFloat(9.999974F, 0.9999743F);
this.xrPivotGrid1.Name = "xrPivotGrid1";
this.xrPivotGrid1.OptionsPrint.PrintFilterHeaders = DevExpress.Utils.DefaultBoolean.False;
this.xrPivotGrid1.SizeF = new System.Drawing.SizeF(371.25F, 84.375F);
//
// fieldTaxAgentTIN
//
this.fieldTaxAgentTIN.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldTaxAgentTIN.AreaIndex = 0;
this.fieldTaxAgentTIN.Caption = "STIN";
this.fieldTaxAgentTIN.FieldName = "TaxAgentTIN";
this.fieldTaxAgentTIN.Name = "fieldTaxAgentTIN";
//
// fieldOrganizationName
//
this.fieldOrganizationName.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldOrganizationName.AreaIndex = 1;
this.fieldOrganizationName.Caption = "Organization";
this.fieldOrganizationName.FieldName = "OrganizationName";
this.fieldOrganizationName.Name = "fieldOrganizationName";
//
// fieldAmount
//
this.fieldAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldAmount.AreaIndex = 0;
this.fieldAmount.CellFormat.FormatString = "n2";
this.fieldAmount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldAmount.FieldName = "Amount";
this.fieldAmount.Name = "fieldAmount";
//
// xrPageInfo1
//
this.xrPageInfo1.Font = new System.Drawing.Font("Times New Roman", 7F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(10.00001F, 0F);
this.xrPageInfo1.Name = "xrPageInfo1";
this.xrPageInfo1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrPageInfo1.PageInfo = DevExpress.XtraPrinting.PageInfo.DateTime;
this.xrPageInfo1.SizeF = new System.Drawing.SizeF(309.375F, 23F);
this.xrPageInfo1.StylePriority.UseFont = false;
this.xrPageInfo1.StylePriority.UseTextAlignment = false;
this.xrPageInfo1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
this.xrPageInfo1.TextFormatString = "Printed Date: {0:dddd, MMMM d, yyyy}";
//
// xrPageInfo2
//
this.xrPageInfo2.Font = new System.Drawing.Font("Times New Roman", 7F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(800F, 0F);
this.xrPageInfo2.Name = "xrPageInfo2";
this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrPageInfo2.SizeF = new System.Drawing.SizeF(100F, 23F);
this.xrPageInfo2.StylePriority.UseFont = false;
this.xrPageInfo2.StylePriority.UseTextAlignment = false;
this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
this.xrPageInfo2.TextFormatString = "Page {0} of {1}";
//
// XtraRepTrendAnalysis
//
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.TopMargin,
this.BottomMargin,
this.Detail
});
this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
this.sqlDataSource1
});
this.DataMember = "ViewdefaulterAnalysis";
this.DataSource = this.sqlDataSource1;
this.Font = new System.Drawing.Font("Arial", 9.75F);
this.Landscape = true;
this.Margins = new System.Drawing.Printing.Margins(100, 100, 100, 23);
this.PageHeight = 850;
this.PageWidth = 1100;
this.Version = "20.2";
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
/// <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();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(XtraRepTrend));
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.Group group1 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression7 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group2 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression8 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group3 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression9 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group4 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression10 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Group group5 = new DevExpress.DataAccess.Sql.Group();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression11 = new DevExpress.DataAccess.Sql.ColumnExpression();
this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand();
this.xrlborghead = new DevExpress.XtraReports.UI.XRLabel();
this.xrlbsubHead = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel11 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel10 = new DevExpress.XtraReports.UI.XRLabel();
this.xrLabel9 = new DevExpress.XtraReports.UI.XRLabel();
this.xrPictureBox1 = new DevExpress.XtraReports.UI.XRPictureBox();
this.xrPictureBox2 = new DevExpress.XtraReports.UI.XRPictureBox();
this.xrPictureBox3 = new DevExpress.XtraReports.UI.XRPictureBox();
this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand();
this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo();
this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo();
this.Detail = new DevExpress.XtraReports.UI.DetailBand();
this.xrPivotGrid1 = new DevExpress.XtraReports.UI.XRPivotGrid();
this.fieldMonths = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField();
this.fieldTaxAgentTIN = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField();
this.fieldOrganizationName = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField();
this.fieldAmount = new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField();
this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// TopMargin
//
this.TopMargin.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrlborghead,
this.xrlbsubHead,
this.xrLabel11,
this.xrLabel10,
this.xrLabel9,
this.xrPictureBox1,
this.xrPictureBox2,
this.xrPictureBox3
});
this.TopMargin.HeightF = 185.4166F;
this.TopMargin.Name = "TopMargin";
//
// xrlborghead
//
this.xrlborghead.Font = new System.Drawing.Font("Arial Rounded MT Bold", 20F, System.Drawing.FontStyle.Bold);
this.xrlborghead.LocationFloat = new DevExpress.Utils.PointFloat(183.3606F, 0F);
this.xrlborghead.Multiline = true;
this.xrlborghead.Name = "xrlborghead";
this.xrlborghead.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrlborghead.SizeF = new System.Drawing.SizeF(517.5F, 35.50002F);
this.xrlborghead.StylePriority.UseFont = false;
this.xrlborghead.StylePriority.UseTextAlignment = false;
this.xrlborghead.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
//
// xrlbsubHead
//
this.xrlbsubHead.CanShrink = true;
this.xrlbsubHead.Font = new System.Drawing.Font("Arial Rounded MT Bold", 12F, System.Drawing.FontStyle.Bold);
this.xrlbsubHead.LocationFloat = new DevExpress.Utils.PointFloat(269.4738F, 35.50002F);
this.xrlbsubHead.Multiline = true;
this.xrlbsubHead.Name = "xrlbsubHead";
this.xrlbsubHead.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrlbsubHead.SizeF = new System.Drawing.SizeF(330.7916F, 37.58338F);
this.xrlbsubHead.StylePriority.UseFont = false;
this.xrlbsubHead.StylePriority.UseTextAlignment = false;
this.xrlbsubHead.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
//
// xrLabel11
//
this.xrLabel11.Font = new System.Drawing.Font("Bahnschrift SemiLight", 14F, System.Drawing.FontStyle.Bold);
this.xrLabel11.LocationFloat = new DevExpress.Utils.PointFloat(188.8189F, 146.9167F);
this.xrLabel11.Multiline = true;
this.xrLabel11.Name = "xrLabel11";
this.xrLabel11.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel11.SizeF = new System.Drawing.SizeF(512.0416F, 30.66667F);
this.xrLabel11.StylePriority.UseFont = false;
this.xrLabel11.StylePriority.UseTextAlignment = false;
this.xrLabel11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// xrLabel10
//
this.xrLabel10.Font = new System.Drawing.Font("Bahnschrift SemiLight", 14F, System.Drawing.FontStyle.Bold);
this.xrLabel10.LocationFloat = new DevExpress.Utils.PointFloat(222.1523F, 116.2501F);
this.xrLabel10.Multiline = true;
this.xrLabel10.Name = "xrLabel10";
this.xrLabel10.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel10.SizeF = new System.Drawing.SizeF(412.7082F, 30.66666F);
this.xrLabel10.StylePriority.UseFont = false;
this.xrLabel10.StylePriority.UseTextAlignment = false;
this.xrLabel10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// xrLabel9
//
this.xrLabel9.Font = new System.Drawing.Font("Arial Rounded MT Bold", 20F, System.Drawing.FontStyle.Bold);
this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(232.3189F, 73.0834F);
this.xrLabel9.Multiline = true;
this.xrLabel9.Name = "xrLabel9";
this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrLabel9.SizeF = new System.Drawing.SizeF(387.7083F, 43.16666F);
this.xrLabel9.StylePriority.UseFont = false;
this.xrLabel9.StylePriority.UseTextAlignment = false;
this.xrLabel9.Text = "Trend Analysis";
this.xrLabel9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter;
//
// xrPictureBox1
//
this.xrPictureBox1.ImageSource = new DevExpress.XtraPrinting.Drawing.ImageSource("img", resources.GetString("xrPictureBox1.ImageSource"));
this.xrPictureBox1.LocationFloat = new DevExpress.Utils.PointFloat(10.00001F, 10.875F);
this.xrPictureBox1.Name = "xrPictureBox1";
this.xrPictureBox1.SizeF = new System.Drawing.SizeF(97.91666F, 95.54173F);
this.xrPictureBox1.Sizing = DevExpress.XtraPrinting.ImageSizeMode.ZoomImage;
//
// xrPictureBox2
//
this.xrPictureBox2.ImageSource = new DevExpress.XtraPrinting.Drawing.ImageSource("img", resources.GetString("xrPictureBox2.ImageSource"));
this.xrPictureBox2.LocationFloat = new DevExpress.Utils.PointFloat(10.00001F, 10.875F);
this.xrPictureBox2.Name = "xrPictureBox2";
this.xrPictureBox2.SizeF = new System.Drawing.SizeF(97.91666F, 95.54173F);
this.xrPictureBox2.Sizing = DevExpress.XtraPrinting.ImageSizeMode.ZoomImage;
//
// xrPictureBox3
//
this.xrPictureBox3.ImageSource = new DevExpress.XtraPrinting.Drawing.ImageSource("img", resources.GetString("xrPictureBox3.ImageSource"));
this.xrPictureBox3.LocationFloat = new DevExpress.Utils.PointFloat(10.00001F, 10.875F);
this.xrPictureBox3.Name = "xrPictureBox3";
this.xrPictureBox3.SizeF = new System.Drawing.SizeF(97.91666F, 95.54173F);
this.xrPictureBox3.Sizing = DevExpress.XtraPrinting.ImageSizeMode.ZoomImage;
//
// BottomMargin
//
this.BottomMargin.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrPageInfo1,
this.xrPageInfo2
});
this.BottomMargin.HeightF = 25F;
this.BottomMargin.Name = "BottomMargin";
//
// xrPageInfo1
//
this.xrPageInfo1.Font = new System.Drawing.Font("Times New Roman", 7F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(72.45834F, 0F);
this.xrPageInfo1.Name = "xrPageInfo1";
this.xrPageInfo1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrPageInfo1.PageInfo = DevExpress.XtraPrinting.PageInfo.DateTime;
this.xrPageInfo1.SizeF = new System.Drawing.SizeF(309.375F, 23F);
this.xrPageInfo1.StylePriority.UseFont = false;
this.xrPageInfo1.TextFormatString = "Printed Date: {0:dddd, MMMM d, yyyy}";
//
// xrPageInfo2
//
this.xrPageInfo2.Font = new System.Drawing.Font("Times New Roman", 7F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))));
this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(792.6666F, 0F);
this.xrPageInfo2.Name = "xrPageInfo2";
this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
this.xrPageInfo2.SizeF = new System.Drawing.SizeF(100F, 23F);
this.xrPageInfo2.StylePriority.UseFont = false;
this.xrPageInfo2.TextFormatString = "Page {0} of {1}";
//
// Detail
//
this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
this.xrPivotGrid1
});
this.Detail.HeightF = 46.875F;
this.Detail.Name = "Detail";
this.Detail.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.Detail_BeforePrint);
//
// xrPivotGrid1
//
this.xrPivotGrid1.Appearance.Cell.Font = new System.Drawing.Font("Tahoma", 8.25F);
this.xrPivotGrid1.Appearance.CustomTotalCell.Font = new System.Drawing.Font("Tahoma", 8.25F);
this.xrPivotGrid1.Appearance.FieldHeader.Font = new System.Drawing.Font("Tahoma", 8.25F);
this.xrPivotGrid1.Appearance.FieldValue.Font = new System.Drawing.Font("Tahoma", 8.25F);
this.xrPivotGrid1.Appearance.FieldValueGrandTotal.Font = new System.Drawing.Font("Tahoma", 8.25F);
this.xrPivotGrid1.Appearance.FieldValueTotal.Font = new System.Drawing.Font("Tahoma", 8.25F);
this.xrPivotGrid1.Appearance.GrandTotalCell.Font = new System.Drawing.Font("Tahoma", 8.25F);
this.xrPivotGrid1.Appearance.Lines.Font = new System.Drawing.Font("Tahoma", 8.25F);
this.xrPivotGrid1.Appearance.TotalCell.Font = new System.Drawing.Font("Tahoma", 8.25F);
this.xrPivotGrid1.Fields.AddRange(new DevExpress.XtraReports.UI.PivotGrid.XRPivotGridField[] {
this.fieldMonths,
this.fieldTaxAgentTIN,
this.fieldOrganizationName,
this.fieldAmount
});
this.xrPivotGrid1.LocationFloat = new DevExpress.Utils.PointFloat(10.00004F, 0F);
this.xrPivotGrid1.Name = "xrPivotGrid1";
this.xrPivotGrid1.OptionsDataField.ColumnValueLineCount = 2;
this.xrPivotGrid1.OptionsPrint.FilterSeparatorBarPadding = 3;
this.xrPivotGrid1.OptionsPrint.PrintFilterHeaders = DevExpress.Utils.DefaultBoolean.False;
this.xrPivotGrid1.OptionsView.ColumnTotalsLocation = DevExpress.XtraPivotGrid.PivotTotalsLocation.Near;
this.xrPivotGrid1.OptionsView.ShowColumnHeaders = false;
this.xrPivotGrid1.OptionsView.ShowDataHeaders = false;
this.xrPivotGrid1.SizeF = new System.Drawing.SizeF(371.8333F, 45.83333F);
//
// fieldMonths
//
this.fieldMonths.Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
this.fieldMonths.AreaIndex = 0;
this.fieldMonths.FieldName = "Months";
this.fieldMonths.Name = "fieldMonths";
//
// fieldTaxAgentTIN
//
this.fieldTaxAgentTIN.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldTaxAgentTIN.AreaIndex = 0;
this.fieldTaxAgentTIN.Caption = "STIN";
this.fieldTaxAgentTIN.FieldName = "TaxAgentTIN";
this.fieldTaxAgentTIN.Name = "fieldTaxAgentTIN";
//
// fieldOrganizationName
//
this.fieldOrganizationName.Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
this.fieldOrganizationName.AreaIndex = 1;
this.fieldOrganizationName.Caption = "Organization";
this.fieldOrganizationName.FieldName = "OrganizationName";
this.fieldOrganizationName.Name = "fieldOrganizationName";
//
// fieldAmount
//
this.fieldAmount.Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
this.fieldAmount.AreaIndex = 0;
this.fieldAmount.Caption = "Amount";
this.fieldAmount.CellFormat.FormatString = "{0:n2}";
this.fieldAmount.CellFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
this.fieldAmount.ColumnValueLineCount = 2;
this.fieldAmount.FieldName = "Amount";
this.fieldAmount.Name = "fieldAmount";
//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionName = "Registration2ConnectionString";
this.sqlDataSource1.Name = "sqlDataSource1";
columnExpression1.ColumnName = "OrganizationName";
table1.MetaSerializable = "<Meta X=\"30\" Y=\"30\" Width=\"125\" Height=\"203\" />";
table1.Name = "vwTrend";
columnExpression1.Table = table1;
column1.Expression = columnExpression1;
columnExpression2.ColumnName = "TaxAgentTIN";
columnExpression2.Table = table1;
column2.Expression = columnExpression2;
columnExpression3.ColumnName = "RevenueOfficeID";
columnExpression3.Table = table1;
column3.Expression = columnExpression3;
columnExpression4.ColumnName = "RevenueOfficeName";
columnExpression4.Table = table1;
column4.Expression = columnExpression4;
columnExpression5.ColumnName = "Months";
columnExpression5.Table = table1;
column5.Expression = columnExpression5;
column6.Alias = "Amount";
columnExpression6.Aggregate = DevExpress.DataAccess.Sql.AggregationType.Sum;
columnExpression6.ColumnName = "Amount";
columnExpression6.Table = table1;
column6.Expression = columnExpression6;
selectQuery1.Columns.Add(column1);
selectQuery1.Columns.Add(column2);
selectQuery1.Columns.Add(column3);
selectQuery1.Columns.Add(column4);
selectQuery1.Columns.Add(column5);
selectQuery1.Columns.Add(column6);
columnExpression7.ColumnName = "OrganizationName";
columnExpression7.Table = table1;
group1.Expression = columnExpression7;
columnExpression8.ColumnName = "TaxAgentTIN";
columnExpression8.Table = table1;
group2.Expression = columnExpression8;
columnExpression9.ColumnName = "RevenueOfficeID";
columnExpression9.Table = table1;
group3.Expression = columnExpression9;
columnExpression10.ColumnName = "RevenueOfficeName";
columnExpression10.Table = table1;
group4.Expression = columnExpression10;
columnExpression11.ColumnName = "Months";
columnExpression11.Table = table1;
group5.Expression = columnExpression11;
selectQuery1.Groups.Add(group1);
selectQuery1.Groups.Add(group2);
selectQuery1.Groups.Add(group3);
selectQuery1.Groups.Add(group4);
selectQuery1.Groups.Add(group5);
selectQuery1.Name = "vwTrend";
selectQuery1.Tables.Add(table1);
this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1
});
this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable");
//
// XtraRepTrend
//
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
this.TopMargin,
this.BottomMargin,
this.Detail
});
this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
this.sqlDataSource1
});
this.DataMember = "vwTrend";
this.DataSource = this.sqlDataSource1;
this.Font = new System.Drawing.Font("Arial", 9.75F);
this.Landscape = true;
this.Margins = new System.Drawing.Printing.Margins(100, 100, 185, 25);
this.PageHeight = 850;
this.PageWidth = 1100;
this.Version = "20.2";
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
