521 lines
25 KiB
C#
521 lines
25 KiB
C#
using System;
|
|
using DevExpress.XtraReports.UI;
|
|
//using DevExpress.XtraReports.Parameters;
|
|
//using DevExpress.XtraEditors;
|
|
//using DevExpress.XtraEditors.Controls;
|
|
//using DevExpress.XtraReports.Extensions;
|
|
//using EnVisage.Code.BLL.Reports;
|
|
|
|
/// <summary>
|
|
/// Summary description for XtraReport2
|
|
/// </summary>
|
|
public class XtraReport2 : ReportBase
|
|
{
|
|
private XRLabel xrLabel8;
|
|
private XRLabel xrLabel7;
|
|
private XRLabel xrLabel6;
|
|
private XRLabel xrLabel5;
|
|
private DevExpress.DataAccess.Sql.SqlDataSource sqlDataSource1;
|
|
private PageHeaderBand PageHeader;
|
|
private XRLabel xrLabel4;
|
|
private XRLabel xrLabel3;
|
|
private XRLabel xrLabel2;
|
|
private XRLabel xrLabel1;
|
|
private XRControlStyle PageHeaderRow;
|
|
private GroupHeaderBand GroupHeader1;
|
|
private XRLabel xrLabel9;
|
|
private XRControlStyle TeamRow;
|
|
private GroupFooterBand GroupFooter1;
|
|
private XRLabel xrLabel10;
|
|
private DevExpress.XtraReports.Parameters.Parameter Team;
|
|
private DevExpress.XtraReports.Parameters.Parameter StartDate;
|
|
private DevExpress.XtraReports.Parameters.Parameter EndDate;
|
|
private CalculatedField _parameterTeam;
|
|
private XRPanel xrPanel1;
|
|
private XRLabel xrLabel14;
|
|
private XRLabel xrLabel13;
|
|
private XRLabel xrLabel12;
|
|
private XRLabel xrLabel11;
|
|
private XRLabel xrLabel19;
|
|
private XRLabel xrLabel18;
|
|
private XRLabel xrLabel17;
|
|
private XRLabel xrLabel16;
|
|
private XRLabel xrLabel15;
|
|
private CalculatedField ExpenseRevenue;
|
|
private XRCheckBox xrCheckBox1;
|
|
private DevExpress.XtraReports.Parameters.Parameter Cost;
|
|
|
|
/// <summary>
|
|
/// Required designer variable.
|
|
/// </summary>
|
|
private System.ComponentModel.IContainer components = null;
|
|
|
|
public XtraReport2()
|
|
{
|
|
InitializeComponent();
|
|
//
|
|
// TODO: Add constructor logic here
|
|
//
|
|
}
|
|
|
|
/// <summary>
|
|
/// Clean up any resources being used.
|
|
/// </summary>
|
|
/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
|
|
protected override void Dispose(bool disposing)
|
|
{
|
|
if (disposing && (components != null))
|
|
{
|
|
components.Dispose();
|
|
}
|
|
base.Dispose(disposing);
|
|
//List<CriteriaOperator> operators = new List<CriteriaOperator>();
|
|
//if (true)
|
|
//{
|
|
// operators.Add(new BinaryOperator("ProjectedRevenue", ProjectedRevenue, BinaryOperatorType.GreaterOrEqual));
|
|
//}
|
|
|
|
}
|
|
|
|
#region Designer generated code
|
|
|
|
/// <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.CustomSqlQuery customSqlQuery1 = new DevExpress.DataAccess.Sql.CustomSqlQuery();
|
|
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(XtraReport2));
|
|
DevExpress.XtraReports.UI.XRSummary xrSummary1 = new DevExpress.XtraReports.UI.XRSummary();
|
|
DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings1 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings();
|
|
this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
|
|
this.PageHeader = new DevExpress.XtraReports.UI.PageHeaderBand();
|
|
this.xrLabel19 = new DevExpress.XtraReports.UI.XRLabel();
|
|
this.xrLabel18 = new DevExpress.XtraReports.UI.XRLabel();
|
|
this.xrLabel17 = new DevExpress.XtraReports.UI.XRLabel();
|
|
this.xrLabel16 = new DevExpress.XtraReports.UI.XRLabel();
|
|
this.xrLabel15 = new DevExpress.XtraReports.UI.XRLabel();
|
|
this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel();
|
|
this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel();
|
|
this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel();
|
|
this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel();
|
|
this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel();
|
|
this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel();
|
|
this.xrLabel7 = new DevExpress.XtraReports.UI.XRLabel();
|
|
this.xrLabel8 = new DevExpress.XtraReports.UI.XRLabel();
|
|
this.PageHeaderRow = new DevExpress.XtraReports.UI.XRControlStyle();
|
|
this.GroupHeader1 = new DevExpress.XtraReports.UI.GroupHeaderBand();
|
|
this.xrLabel9 = new DevExpress.XtraReports.UI.XRLabel();
|
|
this.TeamRow = new DevExpress.XtraReports.UI.XRControlStyle();
|
|
this.GroupFooter1 = new DevExpress.XtraReports.UI.GroupFooterBand();
|
|
this.xrPanel1 = new DevExpress.XtraReports.UI.XRPanel();
|
|
this.xrLabel10 = new DevExpress.XtraReports.UI.XRLabel();
|
|
this.Team = new DevExpress.XtraReports.Parameters.Parameter();
|
|
this.StartDate = new DevExpress.XtraReports.Parameters.Parameter();
|
|
this.EndDate = new DevExpress.XtraReports.Parameters.Parameter();
|
|
this._parameterTeam = new DevExpress.XtraReports.UI.CalculatedField();
|
|
this.xrLabel11 = new DevExpress.XtraReports.UI.XRLabel();
|
|
this.xrLabel12 = new DevExpress.XtraReports.UI.XRLabel();
|
|
this.ExpenseRevenue = new DevExpress.XtraReports.UI.CalculatedField();
|
|
this.xrLabel13 = new DevExpress.XtraReports.UI.XRLabel();
|
|
this.xrLabel14 = new DevExpress.XtraReports.UI.XRLabel();
|
|
this.xrCheckBox1 = new DevExpress.XtraReports.UI.XRCheckBox();
|
|
this.Cost = new DevExpress.XtraReports.Parameters.Parameter();
|
|
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
|
|
//
|
|
// Detail
|
|
//
|
|
this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
|
|
this.xrCheckBox1,
|
|
this.xrLabel14,
|
|
this.xrLabel13,
|
|
this.xrLabel12,
|
|
this.xrLabel11,
|
|
this.xrLabel8,
|
|
this.xrLabel7,
|
|
this.xrLabel6,
|
|
this.xrLabel5});
|
|
this.Detail.HeightF = 23F;
|
|
//
|
|
// sqlDataSource1
|
|
//
|
|
this.sqlDataSource1.ConnectionName = "DefaultConnection";
|
|
this.sqlDataSource1.Name = "sqlDataSource1";
|
|
customSqlQuery1.Name = "CustomSqlQuery";
|
|
customSqlQuery1.Sql = resources.GetString("customSqlQuery1.Sql");
|
|
this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
|
|
customSqlQuery1});
|
|
this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable");
|
|
//
|
|
// PageHeader
|
|
//
|
|
this.PageHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
|
|
this.xrLabel19,
|
|
this.xrLabel18,
|
|
this.xrLabel17,
|
|
this.xrLabel16,
|
|
this.xrLabel15,
|
|
this.xrLabel4,
|
|
this.xrLabel3,
|
|
this.xrLabel2,
|
|
this.xrLabel1});
|
|
this.PageHeader.HeightF = 25F;
|
|
this.PageHeader.Name = "PageHeader";
|
|
this.PageHeader.StyleName = "PageHeaderRow";
|
|
//
|
|
// xrLabel19
|
|
//
|
|
this.xrLabel19.LocationFloat = new DevExpress.Utils.PointFloat(986.4581F, 0F);
|
|
this.xrLabel19.Name = "xrLabel19";
|
|
this.xrLabel19.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
|
|
this.xrLabel19.Scripts.OnBeforePrint = "HeaderCell_BeforePrint";
|
|
this.xrLabel19.SizeF = new System.Drawing.SizeF(315.5421F, 23F);
|
|
this.xrLabel19.Tag = "ScenarioName";
|
|
this.xrLabel19.Text = "Scenario";
|
|
//
|
|
// xrLabel18
|
|
//
|
|
this.xrLabel18.LocationFloat = new DevExpress.Utils.PointFloat(855.2082F, 0F);
|
|
this.xrLabel18.Name = "xrLabel18";
|
|
this.xrLabel18.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
|
|
this.xrLabel18.Scripts.OnBeforePrint = "HeaderCell_BeforePrint";
|
|
this.xrLabel18.SizeF = new System.Drawing.SizeF(131.25F, 23F);
|
|
this.xrLabel18.Tag = "ExpenseRevenue";
|
|
this.xrLabel18.Text = "Expense/Revenue";
|
|
//
|
|
// xrLabel17
|
|
//
|
|
this.xrLabel17.LocationFloat = new DevExpress.Utils.PointFloat(755.2083F, 0F);
|
|
this.xrLabel17.Name = "xrLabel17";
|
|
this.xrLabel17.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
|
|
this.xrLabel17.Scripts.OnBeforePrint = "HeaderCell_BeforePrint";
|
|
this.xrLabel17.SizeF = new System.Drawing.SizeF(99.99994F, 23F);
|
|
this.xrLabel17.Tag = "IsRevenueGenerating";
|
|
this.xrLabel17.Text = "Is Revenue";
|
|
//
|
|
// xrLabel16
|
|
//
|
|
this.xrLabel16.LocationFloat = new DevExpress.Utils.PointFloat(658.3333F, 0F);
|
|
this.xrLabel16.Name = "xrLabel16";
|
|
this.xrLabel16.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
|
|
this.xrLabel16.Scripts.OnBeforePrint = "HeaderCell_BeforePrint";
|
|
this.xrLabel16.SizeF = new System.Drawing.SizeF(96.875F, 23F);
|
|
this.xrLabel16.Tag = "Priority";
|
|
this.xrLabel16.Text = "Priority";
|
|
//
|
|
// xrLabel15
|
|
//
|
|
this.xrLabel15.LocationFloat = new DevExpress.Utils.PointFloat(558.3333F, 0F);
|
|
this.xrLabel15.Name = "xrLabel15";
|
|
this.xrLabel15.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
|
|
this.xrLabel15.Scripts.OnBeforePrint = "HeaderCell_BeforePrint";
|
|
this.xrLabel15.SizeF = new System.Drawing.SizeF(100F, 23F);
|
|
this.xrLabel15.Tag = "Deadline";
|
|
this.xrLabel15.Text = "Deadline";
|
|
//
|
|
// xrLabel4
|
|
//
|
|
this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(458.3333F, 0F);
|
|
this.xrLabel4.Name = "xrLabel4";
|
|
this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
|
|
this.xrLabel4.Scripts.OnBeforePrint = "HeaderCell_BeforePrint";
|
|
this.xrLabel4.SizeF = new System.Drawing.SizeF(99.99991F, 23F);
|
|
this.xrLabel4.Tag = "BUDirectCosts";
|
|
this.xrLabel4.Text = "BU Cost";
|
|
//
|
|
// xrLabel3
|
|
//
|
|
this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(355.2083F, 0F);
|
|
this.xrLabel3.Name = "xrLabel3";
|
|
this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
|
|
this.xrLabel3.Scripts.OnBeforePrint = "HeaderCell_BeforePrint";
|
|
this.xrLabel3.SizeF = new System.Drawing.SizeF(103.1251F, 23F);
|
|
this.xrLabel3.Tag = "EndDate";
|
|
this.xrLabel3.Text = "End Date";
|
|
//
|
|
// xrLabel2
|
|
//
|
|
this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(258.3333F, 0F);
|
|
this.xrLabel2.Name = "xrLabel2";
|
|
this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
|
|
this.xrLabel2.Scripts.OnBeforePrint = "HeaderCell_BeforePrint";
|
|
this.xrLabel2.SizeF = new System.Drawing.SizeF(96.875F, 23F);
|
|
this.xrLabel2.Tag = "StartDate";
|
|
this.xrLabel2.Text = "Start Date";
|
|
//
|
|
// xrLabel1
|
|
//
|
|
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.Scripts.OnBeforePrint = "HeaderCell_BeforePrint";
|
|
this.xrLabel1.SizeF = new System.Drawing.SizeF(258.3333F, 23F);
|
|
this.xrLabel1.Text = "Team/Project";
|
|
//
|
|
// xrLabel5
|
|
//
|
|
this.xrLabel5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
|
|
new DevExpress.XtraReports.UI.XRBinding("Text", null, "CustomSqlQuery.ProjectFullName")});
|
|
this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
|
|
this.xrLabel5.Name = "xrLabel5";
|
|
this.xrLabel5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
|
|
this.xrLabel5.SizeF = new System.Drawing.SizeF(258.3333F, 23F);
|
|
this.xrLabel5.Text = "xrLabel5";
|
|
//
|
|
// xrLabel6
|
|
//
|
|
this.xrLabel6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
|
|
new DevExpress.XtraReports.UI.XRBinding("Text", null, "CustomSqlQuery.StartDate", "{0:MM/dd/yyyy}")});
|
|
this.xrLabel6.LocationFloat = new DevExpress.Utils.PointFloat(258.3333F, 0F);
|
|
this.xrLabel6.Name = "xrLabel6";
|
|
this.xrLabel6.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
|
|
this.xrLabel6.SizeF = new System.Drawing.SizeF(100F, 23F);
|
|
//
|
|
// xrLabel7
|
|
//
|
|
this.xrLabel7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
|
|
new DevExpress.XtraReports.UI.XRBinding("Text", null, "CustomSqlQuery.EndDate", "{0:MM/dd/yyyy}")});
|
|
this.xrLabel7.LocationFloat = new DevExpress.Utils.PointFloat(358.3333F, 0F);
|
|
this.xrLabel7.Name = "xrLabel7";
|
|
this.xrLabel7.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
|
|
this.xrLabel7.SizeF = new System.Drawing.SizeF(100F, 23F);
|
|
//
|
|
// xrLabel8
|
|
//
|
|
this.xrLabel8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
|
|
new DevExpress.XtraReports.UI.XRBinding("Text", null, "CustomSqlQuery.BUDirectCosts", "{0:$0.00}")});
|
|
this.xrLabel8.LocationFloat = new DevExpress.Utils.PointFloat(458.3333F, 0F);
|
|
this.xrLabel8.Name = "xrLabel8";
|
|
this.xrLabel8.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
|
|
this.xrLabel8.SizeF = new System.Drawing.SizeF(100F, 23F);
|
|
//
|
|
// PageHeaderRow
|
|
//
|
|
this.PageHeaderRow.BackColor = System.Drawing.Color.DarkGray;
|
|
this.PageHeaderRow.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(204)));
|
|
this.PageHeaderRow.Name = "PageHeaderRow";
|
|
this.PageHeaderRow.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
|
|
//
|
|
// GroupHeader1
|
|
//
|
|
this.GroupHeader1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
|
|
this.xrLabel9});
|
|
this.GroupHeader1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] {
|
|
new DevExpress.XtraReports.UI.GroupField("TeamName", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending)});
|
|
this.GroupHeader1.HeightF = 23F;
|
|
this.GroupHeader1.Name = "GroupHeader1";
|
|
//
|
|
// xrLabel9
|
|
//
|
|
this.xrLabel9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
|
|
new DevExpress.XtraReports.UI.XRBinding("Text", null, "CustomSqlQuery.TeamName")});
|
|
this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
|
|
this.xrLabel9.Name = "xrLabel9";
|
|
this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
|
|
this.xrLabel9.SizeF = new System.Drawing.SizeF(900F, 23F);
|
|
this.xrLabel9.StyleName = "TeamRow";
|
|
this.xrLabel9.Text = "xrLabel9";
|
|
//
|
|
// TeamRow
|
|
//
|
|
this.TeamRow.BackColor = System.Drawing.Color.MediumTurquoise;
|
|
this.TeamRow.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top)
|
|
| DevExpress.XtraPrinting.BorderSide.Right)
|
|
| DevExpress.XtraPrinting.BorderSide.Bottom)));
|
|
this.TeamRow.Name = "TeamRow";
|
|
this.TeamRow.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
|
|
//
|
|
// GroupFooter1
|
|
//
|
|
this.GroupFooter1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
|
|
this.xrPanel1});
|
|
this.GroupFooter1.HeightF = 23.95833F;
|
|
this.GroupFooter1.Name = "GroupFooter1";
|
|
this.GroupFooter1.StyleName = "TeamRow";
|
|
//
|
|
// xrPanel1
|
|
//
|
|
this.xrPanel1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
|
|
this.xrLabel10});
|
|
this.xrPanel1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
|
|
this.xrPanel1.Name = "xrPanel1";
|
|
this.xrPanel1.SizeF = new System.Drawing.SizeF(900.0001F, 23.95833F);
|
|
//
|
|
// xrLabel10
|
|
//
|
|
this.xrLabel10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
|
|
new DevExpress.XtraReports.UI.XRBinding("Text", null, "CustomSqlQuery.BUDirectCosts")});
|
|
this.xrLabel10.LocationFloat = new DevExpress.Utils.PointFloat(458.3333F, 0F);
|
|
this.xrLabel10.Name = "xrLabel10";
|
|
this.xrLabel10.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
|
|
this.xrLabel10.SizeF = new System.Drawing.SizeF(100F, 23F);
|
|
xrSummary1.Running = DevExpress.XtraReports.UI.SummaryRunning.Group;
|
|
this.xrLabel10.Summary = xrSummary1;
|
|
this.xrLabel10.Text = "xrLabel10";
|
|
//
|
|
// Team
|
|
//
|
|
dynamicListLookUpSettings1.DataAdapter = null;
|
|
dynamicListLookUpSettings1.DataMember = "CustomSqlQuery";
|
|
dynamicListLookUpSettings1.DataSource = this.sqlDataSource1;
|
|
dynamicListLookUpSettings1.DisplayMember = "TeamName";
|
|
dynamicListLookUpSettings1.ValueMember = "TeamId";
|
|
this.Team.LookUpSettings = dynamicListLookUpSettings1;
|
|
this.Team.MultiValue = true;
|
|
this.Team.Name = "Team";
|
|
this.Team.Type = typeof(System.Guid);
|
|
//
|
|
// StartDate
|
|
//
|
|
this.StartDate.Description = "Start Date";
|
|
this.StartDate.Name = "StartDate";
|
|
this.StartDate.Type = typeof(System.DateTime);
|
|
//
|
|
// EndDate
|
|
//
|
|
this.EndDate.Description = "End Date";
|
|
this.EndDate.Name = "EndDate";
|
|
this.EndDate.Type = typeof(System.DateTime);
|
|
//
|
|
// _parameterTeam
|
|
//
|
|
this._parameterTeam.DataMember = "CustomSqlQuery";
|
|
this._parameterTeam.DisplayName = "Parameter - Team";
|
|
this._parameterTeam.Expression = "[Parameters.Team]";
|
|
this._parameterTeam.FieldType = DevExpress.XtraReports.UI.FieldType.Guid;
|
|
this._parameterTeam.Name = "_parameterTeam";
|
|
//
|
|
// xrLabel11
|
|
//
|
|
this.xrLabel11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
|
|
new DevExpress.XtraReports.UI.XRBinding("Text", null, "CustomSqlQuery.Deadline")});
|
|
this.xrLabel11.LocationFloat = new DevExpress.Utils.PointFloat(558.3333F, 0F);
|
|
this.xrLabel11.Name = "xrLabel11";
|
|
this.xrLabel11.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
|
|
this.xrLabel11.SizeF = new System.Drawing.SizeF(100F, 23F);
|
|
this.xrLabel11.Text = "xrLabel11";
|
|
//
|
|
// xrLabel12
|
|
//
|
|
this.xrLabel12.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
|
|
new DevExpress.XtraReports.UI.XRBinding("Text", null, "CustomSqlQuery.Priority")});
|
|
this.xrLabel12.LocationFloat = new DevExpress.Utils.PointFloat(658.3333F, 0F);
|
|
this.xrLabel12.Name = "xrLabel12";
|
|
this.xrLabel12.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
|
|
this.xrLabel12.SizeF = new System.Drawing.SizeF(100F, 23F);
|
|
this.xrLabel12.Text = "xrLabel12";
|
|
//
|
|
// ExpenseRevenue
|
|
//
|
|
this.ExpenseRevenue.DataMember = "CustomSqlQuery";
|
|
this.ExpenseRevenue.Expression = "Iif([IsRevenueGenerating], [ProjectedRevenue] ,[ProjectedExpense] )";
|
|
this.ExpenseRevenue.Name = "ExpenseRevenue";
|
|
//
|
|
// xrLabel13
|
|
//
|
|
this.xrLabel13.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
|
|
new DevExpress.XtraReports.UI.XRBinding("Text", null, "CustomSqlQuery.ExpenseRevenue")});
|
|
this.xrLabel13.LocationFloat = new DevExpress.Utils.PointFloat(858.3332F, 0F);
|
|
this.xrLabel13.Name = "xrLabel13";
|
|
this.xrLabel13.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
|
|
this.xrLabel13.SizeF = new System.Drawing.SizeF(128.125F, 23F);
|
|
this.xrLabel13.Text = "xrLabel13";
|
|
//
|
|
// xrLabel14
|
|
//
|
|
this.xrLabel14.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
|
|
new DevExpress.XtraReports.UI.XRBinding("Text", null, "CustomSqlQuery.ScenarioName")});
|
|
this.xrLabel14.LocationFloat = new DevExpress.Utils.PointFloat(986.4582F, 0F);
|
|
this.xrLabel14.Name = "xrLabel14";
|
|
this.xrLabel14.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
|
|
this.xrLabel14.SizeF = new System.Drawing.SizeF(315.5419F, 23F);
|
|
this.xrLabel14.Text = "xrLabel14";
|
|
//
|
|
// xrCheckBox1
|
|
//
|
|
this.xrCheckBox1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
|
|
new DevExpress.XtraReports.UI.XRBinding("CheckState", null, "CustomSqlQuery.IsRevenueGenerating"),
|
|
new DevExpress.XtraReports.UI.XRBinding("Text", null, "CustomSqlQuery.IsRevenueGenerating")});
|
|
this.xrCheckBox1.LocationFloat = new DevExpress.Utils.PointFloat(758.3333F, 0F);
|
|
this.xrCheckBox1.Name = "xrCheckBox1";
|
|
this.xrCheckBox1.SizeF = new System.Drawing.SizeF(100F, 23F);
|
|
//
|
|
// Cost
|
|
//
|
|
this.Cost.Description = "BU Direct Cost";
|
|
this.Cost.Name = "Cost";
|
|
this.Cost.Type = typeof(decimal);
|
|
this.Cost.ValueInfo = "0";
|
|
//
|
|
// XtraReport2
|
|
//
|
|
this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
|
|
this.Detail,
|
|
this.TopMargin,
|
|
this.BottomMargin,
|
|
this.ReportHeader,
|
|
this.PageHeader,
|
|
this.GroupHeader1,
|
|
this.GroupFooter1});
|
|
this.CalculatedFields.AddRange(new DevExpress.XtraReports.UI.CalculatedField[] {
|
|
this._parameterTeam,
|
|
this.ExpenseRevenue});
|
|
this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
|
|
this.sqlDataSource1});
|
|
this.DataMember = "CustomSqlQuery";
|
|
this.DataSource = this.sqlDataSource1;
|
|
this.FilterString = "[Priority] = 1";
|
|
this.Margins = new System.Drawing.Printing.Margins(99, 99, 100, 100);
|
|
this.Parameters.AddRange(new DevExpress.XtraReports.Parameters.Parameter[] {
|
|
this.@__RPT_BASE_PARAM_SORT_FIELD,
|
|
this.@__RPT_BASE_PARAM_SORT_DIR,
|
|
this.Team,
|
|
this.StartDate,
|
|
this.EndDate,
|
|
this.Cost});
|
|
this.RequestParameters = false;
|
|
this.Scripts.OnBeforePrint = "ReportBase_BeforePrint";
|
|
this.Scripts.OnDataSourceDemanded = "ReportBase_DataSourceDemanded";
|
|
this.ScriptsSource = resources.GetString("$this.ScriptsSource");
|
|
this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] {
|
|
this.PageHeaderRow,
|
|
this.TeamRow});
|
|
this.Version = "15.1";
|
|
this.ParametersRequestBeforeShow += new System.EventHandler<DevExpress.XtraReports.Parameters.ParametersRequestEventArgs>(this.XtraReport2_ParametersRequestBeforeShow);
|
|
this.Controls.SetChildIndex(this.GroupFooter1, 0);
|
|
this.Controls.SetChildIndex(this.GroupHeader1, 0);
|
|
this.Controls.SetChildIndex(this.PageHeader, 0);
|
|
this.Controls.SetChildIndex(this.ReportHeader, 0);
|
|
this.Controls.SetChildIndex(this.BottomMargin, 0);
|
|
this.Controls.SetChildIndex(this.TopMargin, 0);
|
|
this.Controls.SetChildIndex(this.Detail, 0);
|
|
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
|
|
|
|
}
|
|
|
|
private void XtraReport2_DataSourceDemanded(object sender, EventArgs e)
|
|
{
|
|
|
|
}
|
|
|
|
#endregion
|
|
|
|
private void XtraReport2_ParametersRequestBeforeShow(object sender, DevExpress.XtraReports.Parameters.ParametersRequestEventArgs e)
|
|
{
|
|
//ReportDesignExtension.RegisterExtension(new CustomReportExtension(), "XtraReport2");
|
|
//ReportDesignExtension.AssociateReportWithExtension(this, "XtraReport2");
|
|
|
|
//foreach (ParameterInfo info in e.ParametersInformation)
|
|
//{
|
|
// if (info.Parameter.Name == "StartDate")
|
|
// {
|
|
// info.Editor = new DevExpress.XtraEditors.DateEdit();
|
|
// info.Parameter.Type = typeof(object);
|
|
// info.Parameter.Value = null;
|
|
// }
|
|
//}
|
|
}
|
|
}
|