851 lines
55 KiB
C#
851 lines
55 KiB
C#
namespace EnVisage.Reports
|
|
{
|
|
partial class ResourceAvailability
|
|
{
|
|
#region Component Designer generated code
|
|
/// <summary>
|
|
/// Required method for telerik Reporting designer support - do not modify
|
|
/// the contents of this method with the code editor.
|
|
/// </summary>
|
|
private void InitializeComponent()
|
|
{
|
|
Telerik.Reporting.Drawing.FormattingRule formattingRule1 = new Telerik.Reporting.Drawing.FormattingRule();
|
|
Telerik.Reporting.Group group1 = new Telerik.Reporting.Group();
|
|
Telerik.Reporting.Group group2 = new Telerik.Reporting.Group();
|
|
Telerik.Reporting.Group group3 = new Telerik.Reporting.Group();
|
|
Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter();
|
|
Telerik.Reporting.ReportParameter reportParameter2 = new Telerik.Reporting.ReportParameter();
|
|
Telerik.Reporting.ReportParameter reportParameter3 = new Telerik.Reporting.ReportParameter();
|
|
Telerik.Reporting.ReportParameter reportParameter4 = new Telerik.Reporting.ReportParameter();
|
|
Telerik.Reporting.ReportParameter reportParameter5 = new Telerik.Reporting.ReportParameter();
|
|
Telerik.Reporting.ReportParameter reportParameter6 = new Telerik.Reporting.ReportParameter();
|
|
Telerik.Reporting.ReportParameter reportParameter7 = new Telerik.Reporting.ReportParameter();
|
|
Telerik.Reporting.ReportParameter reportParameter8 = new Telerik.Reporting.ReportParameter();
|
|
Telerik.Reporting.ReportParameter reportParameter9 = new Telerik.Reporting.ReportParameter();
|
|
Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule();
|
|
this.groupFooterSection2 = new Telerik.Reporting.GroupFooterSection();
|
|
this.textBox12 = new Telerik.Reporting.TextBox();
|
|
this.textBox17 = new Telerik.Reporting.TextBox();
|
|
this.textBox18 = new Telerik.Reporting.TextBox();
|
|
this.textBox20 = new Telerik.Reporting.TextBox();
|
|
this.textBox21 = new Telerik.Reporting.TextBox();
|
|
this.textBox38 = new Telerik.Reporting.TextBox();
|
|
this.groupHeaderSection2 = new Telerik.Reporting.GroupHeaderSection();
|
|
this.textBox3 = new Telerik.Reporting.TextBox();
|
|
this.groupFooterSection = new Telerik.Reporting.GroupFooterSection();
|
|
this.textBox23 = new Telerik.Reporting.TextBox();
|
|
this.textBox25 = new Telerik.Reporting.TextBox();
|
|
this.textBox26 = new Telerik.Reporting.TextBox();
|
|
this.textBox27 = new Telerik.Reporting.TextBox();
|
|
this.textBox28 = new Telerik.Reporting.TextBox();
|
|
this.textBox37 = new Telerik.Reporting.TextBox();
|
|
this.groupHeaderSection = new Telerik.Reporting.GroupHeaderSection();
|
|
this.textBox22 = new Telerik.Reporting.TextBox();
|
|
this.groupFooterSection1 = new Telerik.Reporting.GroupFooterSection();
|
|
this.groupHeaderSection1 = new Telerik.Reporting.GroupHeaderSection();
|
|
this.textBox8 = new Telerik.Reporting.TextBox();
|
|
this.textBox7 = new Telerik.Reporting.TextBox();
|
|
this.textBox13 = new Telerik.Reporting.TextBox();
|
|
this.textBox14 = new Telerik.Reporting.TextBox();
|
|
this.textBox16 = new Telerik.Reporting.TextBox();
|
|
this.textBox35 = new Telerik.Reporting.TextBox();
|
|
this.DataSource2 = new Telerik.Reporting.ObjectDataSource();
|
|
this.sqlDataSource2 = new Telerik.Reporting.SqlDataSource();
|
|
this.sqlDataSource3 = new Telerik.Reporting.SqlDataSource();
|
|
this.DataSource3 = new Telerik.Reporting.ObjectDataSource();
|
|
this.DataSource4 = new Telerik.Reporting.ObjectDataSource();
|
|
this.sqlDataSource1 = new Telerik.Reporting.SqlDataSource();
|
|
this.detail = new Telerik.Reporting.DetailSection();
|
|
this.textBox4 = new Telerik.Reporting.TextBox();
|
|
this.textBox6 = new Telerik.Reporting.TextBox();
|
|
this.textBox5 = new Telerik.Reporting.TextBox();
|
|
this.textBox9 = new Telerik.Reporting.TextBox();
|
|
this.textBox10 = new Telerik.Reporting.TextBox();
|
|
this.textBox36 = new Telerik.Reporting.TextBox();
|
|
this.pageFooterSection1 = new Telerik.Reporting.PageFooterSection();
|
|
this.textBox34 = new Telerik.Reporting.TextBox();
|
|
this.textBox1 = new Telerik.Reporting.TextBox();
|
|
this.textBox2 = new Telerik.Reporting.TextBox();
|
|
this.reportHeaderSection1 = new Telerik.Reporting.ReportHeaderSection();
|
|
this.textBox11 = new Telerik.Reporting.TextBox();
|
|
this.textBox15 = new Telerik.Reporting.TextBox();
|
|
this.textBox19 = new Telerik.Reporting.TextBox();
|
|
this.textBox24 = new Telerik.Reporting.TextBox();
|
|
this.textBox30 = new Telerik.Reporting.TextBox();
|
|
this.textBox40 = new Telerik.Reporting.TextBox();
|
|
this.textBox41 = new Telerik.Reporting.TextBox();
|
|
this.textBox42 = new Telerik.Reporting.TextBox();
|
|
this.textBox43 = new Telerik.Reporting.TextBox();
|
|
this.pageHeaderSection1 = new Telerik.Reporting.PageHeaderSection();
|
|
this.reportFooterSection1 = new Telerik.Reporting.ReportFooterSection();
|
|
this.textBox29 = new Telerik.Reporting.TextBox();
|
|
this.textBox31 = new Telerik.Reporting.TextBox();
|
|
this.textBox32 = new Telerik.Reporting.TextBox();
|
|
this.textBox33 = new Telerik.Reporting.TextBox();
|
|
this.textBox39 = new Telerik.Reporting.TextBox();
|
|
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
|
|
//
|
|
// groupFooterSection2
|
|
//
|
|
this.groupFooterSection2.Height = Telerik.Reporting.Drawing.Unit.Inch(0.20003938674926758D);
|
|
this.groupFooterSection2.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
|
|
this.textBox12,
|
|
this.textBox17,
|
|
this.textBox18,
|
|
this.textBox20,
|
|
this.textBox21,
|
|
this.textBox38});
|
|
this.groupFooterSection2.Name = "groupFooterSection2";
|
|
this.groupFooterSection2.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
|
|
//
|
|
// textBox12
|
|
//
|
|
this.textBox12.Format = "{0:N2}";
|
|
this.textBox12.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.8000001907348633D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
|
|
this.textBox12.Name = "textBox12";
|
|
this.textBox12.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2998018264770508D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox12.Style.Font.Bold = true;
|
|
this.textBox12.Style.Font.Italic = false;
|
|
this.textBox12.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
|
|
this.textBox12.Value = "= Sum(Fields.AllocatedHours)";
|
|
//
|
|
// textBox17
|
|
//
|
|
this.textBox17.Format = "{0}";
|
|
this.textBox17.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.40007877349853516D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
|
|
this.textBox17.Name = "textBox17";
|
|
this.textBox17.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.7001187801361084D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox17.Style.Font.Bold = true;
|
|
this.textBox17.Style.Font.Italic = false;
|
|
this.textBox17.Value = "= Fields.ExpenditureCategory";
|
|
//
|
|
// textBox18
|
|
//
|
|
this.textBox18.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(0D));
|
|
this.textBox18.Name = "textBox18";
|
|
this.textBox18.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.39996063709259033D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox18.Style.Font.Bold = true;
|
|
this.textBox18.Style.Font.Italic = false;
|
|
this.textBox18.Value = "Total";
|
|
//
|
|
// textBox20
|
|
//
|
|
this.textBox20.Format = "{0:N2}";
|
|
this.textBox20.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.1000003814697266D), Telerik.Reporting.Drawing.Unit.Inch(0D));
|
|
this.textBox20.Name = "textBox20";
|
|
this.textBox20.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.299999475479126D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox20.Style.Font.Bold = true;
|
|
this.textBox20.Style.Font.Italic = false;
|
|
this.textBox20.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
|
|
this.textBox20.Value = "= Sum(Fields.NonProjectTimeHours)";
|
|
//
|
|
// textBox21
|
|
//
|
|
this.textBox21.Format = "{0:N2}";
|
|
this.textBox21.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(6.40625D), Telerik.Reporting.Drawing.Unit.Inch(0D));
|
|
this.textBox21.Name = "textBox21";
|
|
this.textBox21.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.1999998092651367D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox21.Style.Font.Bold = true;
|
|
this.textBox21.Style.Font.Italic = false;
|
|
this.textBox21.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
|
|
this.textBox21.Value = "= Sum(Fields.ResourceAvailability)";
|
|
//
|
|
// textBox38
|
|
//
|
|
this.textBox38.Format = "{0:N2}";
|
|
this.textBox38.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.1002762317657471D), Telerik.Reporting.Drawing.Unit.Inch(0D));
|
|
this.textBox38.Name = "textBox38";
|
|
this.textBox38.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.6998026967048645D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox38.Style.Font.Bold = true;
|
|
this.textBox38.Style.Font.Italic = false;
|
|
this.textBox38.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
|
|
this.textBox38.Value = "= Sum(Fields.AvailableHours)";
|
|
//
|
|
// groupHeaderSection2
|
|
//
|
|
this.groupHeaderSection2.Height = Telerik.Reporting.Drawing.Unit.Inch(0.20007880032062531D);
|
|
this.groupHeaderSection2.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
|
|
this.textBox3});
|
|
this.groupHeaderSection2.Name = "groupHeaderSection2";
|
|
//
|
|
// textBox3
|
|
//
|
|
this.textBox3.Format = "{0}";
|
|
this.textBox3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(7.8837074397597462E-05D));
|
|
this.textBox3.Name = "textBox3";
|
|
this.textBox3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(7.3621659278869629D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox3.Style.Font.Bold = true;
|
|
this.textBox3.Style.Font.Italic = true;
|
|
this.textBox3.Value = "= Fields.ExpenditureCategory";
|
|
//
|
|
// groupFooterSection
|
|
//
|
|
this.groupFooterSection.Height = Telerik.Reporting.Drawing.Unit.Inch(0.25208315253257751D);
|
|
this.groupFooterSection.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
|
|
this.textBox23,
|
|
this.textBox25,
|
|
this.textBox26,
|
|
this.textBox27,
|
|
this.textBox28,
|
|
this.textBox37});
|
|
this.groupFooterSection.Name = "groupFooterSection";
|
|
this.groupFooterSection.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
|
|
//
|
|
// textBox23
|
|
//
|
|
this.textBox23.Format = "{0:N2}";
|
|
this.textBox23.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(6.4000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0D));
|
|
this.textBox23.Name = "textBox23";
|
|
this.textBox23.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.1999998092651367D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox23.Style.Font.Bold = true;
|
|
this.textBox23.Style.Font.Italic = false;
|
|
this.textBox23.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
|
|
this.textBox23.Value = "= Sum(Fields.ResourceAvailability)";
|
|
//
|
|
// textBox25
|
|
//
|
|
this.textBox25.Format = "{0:N2}";
|
|
this.textBox25.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.1001186370849609D), Telerik.Reporting.Drawing.Unit.Inch(0D));
|
|
this.textBox25.Name = "textBox25";
|
|
this.textBox25.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2998812198638916D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox25.Style.Font.Bold = true;
|
|
this.textBox25.Style.Font.Italic = false;
|
|
this.textBox25.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
|
|
this.textBox25.Value = "= Sum(Fields.NonProjectTimeHours)";
|
|
//
|
|
// textBox26
|
|
//
|
|
this.textBox26.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(0D));
|
|
this.textBox26.Name = "textBox26";
|
|
this.textBox26.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.39996063709259033D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox26.Style.Font.Bold = true;
|
|
this.textBox26.Style.Font.Italic = false;
|
|
this.textBox26.Value = "Total";
|
|
//
|
|
// textBox27
|
|
//
|
|
this.textBox27.Format = "{0}";
|
|
this.textBox27.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.40007910132408142D), Telerik.Reporting.Drawing.Unit.Inch(0D));
|
|
this.textBox27.Name = "textBox27";
|
|
this.textBox27.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.7000000476837158D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox27.Style.Font.Bold = true;
|
|
this.textBox27.Style.Font.Italic = false;
|
|
this.textBox27.Value = "= Fields.TeamName";
|
|
//
|
|
// textBox28
|
|
//
|
|
this.textBox28.Format = "{0:N2}";
|
|
this.textBox28.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.8000001907348633D), Telerik.Reporting.Drawing.Unit.Inch(0D));
|
|
this.textBox28.Name = "textBox28";
|
|
this.textBox28.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2998018264770508D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox28.Style.Font.Bold = true;
|
|
this.textBox28.Style.Font.Italic = false;
|
|
this.textBox28.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
|
|
this.textBox28.Value = "= Sum(Fields.AllocatedHours)";
|
|
//
|
|
// textBox37
|
|
//
|
|
this.textBox37.Format = "{0:N2}";
|
|
this.textBox37.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.1002762317657471D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
|
|
this.textBox37.Name = "textBox37";
|
|
this.textBox37.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.6998026967048645D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox37.Style.Font.Bold = true;
|
|
this.textBox37.Style.Font.Italic = false;
|
|
this.textBox37.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
|
|
this.textBox37.Value = "= Sum(Fields.AvailableHours)";
|
|
//
|
|
// groupHeaderSection
|
|
//
|
|
this.groupHeaderSection.Height = Telerik.Reporting.Drawing.Unit.Inch(0.20007880032062531D);
|
|
this.groupHeaderSection.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
|
|
this.textBox22});
|
|
this.groupHeaderSection.Name = "groupHeaderSection";
|
|
//
|
|
// textBox22
|
|
//
|
|
this.textBox22.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.30000004172325134D), Telerik.Reporting.Drawing.Unit.Inch(7.8837074397597462E-05D));
|
|
this.textBox22.Name = "textBox22";
|
|
this.textBox22.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(7.0622053146362305D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox22.Style.Font.Bold = true;
|
|
this.textBox22.Value = "= Fields.TeamName";
|
|
//
|
|
// groupFooterSection1
|
|
//
|
|
this.groupFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.0520833320915699D);
|
|
this.groupFooterSection1.Name = "groupFooterSection1";
|
|
//
|
|
// groupHeaderSection1
|
|
//
|
|
this.groupHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.20007865130901337D);
|
|
this.groupHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
|
|
this.textBox8,
|
|
this.textBox7,
|
|
this.textBox13,
|
|
this.textBox14,
|
|
this.textBox16,
|
|
this.textBox35});
|
|
this.groupHeaderSection1.Name = "groupHeaderSection1";
|
|
this.groupHeaderSection1.PrintOnEveryPage = true;
|
|
//
|
|
// textBox8
|
|
//
|
|
this.textBox8.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.9000790119171143D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
|
|
this.textBox8.Name = "textBox8";
|
|
this.textBox8.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2000001668930054D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox8.Style.Font.Bold = true;
|
|
this.textBox8.Value = "First Name";
|
|
//
|
|
// textBox7
|
|
//
|
|
this.textBox7.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.70000004768371582D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
|
|
this.textBox7.Name = "textBox7";
|
|
this.textBox7.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2000001668930054D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox7.Style.Font.Bold = true;
|
|
this.textBox7.Value = "Last Name";
|
|
//
|
|
// textBox13
|
|
//
|
|
this.textBox13.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.8000001907348633D), Telerik.Reporting.Drawing.Unit.Inch(0D));
|
|
this.textBox13.Name = "textBox13";
|
|
this.textBox13.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2999213933944702D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox13.Style.Font.Bold = true;
|
|
this.textBox13.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
|
|
this.textBox13.Value = "Project Allocation";
|
|
//
|
|
// textBox14
|
|
//
|
|
this.textBox14.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.1000003814697266D), Telerik.Reporting.Drawing.Unit.Inch(7.8678131103515625E-05D));
|
|
this.textBox14.Name = "textBox14";
|
|
this.textBox14.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2999995946884155D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox14.Style.Font.Bold = true;
|
|
this.textBox14.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
|
|
this.textBox14.Value = "Non-project Time";
|
|
//
|
|
// textBox16
|
|
//
|
|
this.textBox16.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(6.4000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0D));
|
|
this.textBox16.Name = "textBox16";
|
|
this.textBox16.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.1999998092651367D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox16.Style.Font.Bold = true;
|
|
this.textBox16.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
|
|
this.textBox16.Value = "Available Hours";
|
|
//
|
|
// textBox35
|
|
//
|
|
this.textBox35.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.1001186370849609D), Telerik.Reporting.Drawing.Unit.Inch(7.8837074397597462E-05D));
|
|
this.textBox35.Name = "textBox35";
|
|
this.textBox35.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.69980275630950928D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox35.Style.Font.Bold = true;
|
|
this.textBox35.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
|
|
this.textBox35.Value = "Capacity";
|
|
//
|
|
// DataSource2
|
|
//
|
|
this.DataSource2.DataMember = "Pers";
|
|
this.DataSource2.DataSource = typeof(EnVisage.Reports.Utils);
|
|
this.DataSource2.Name = "DataSource2";
|
|
//
|
|
// sqlDataSource2
|
|
//
|
|
this.sqlDataSource2.ConnectionString = "DefaultConnection";
|
|
this.sqlDataSource2.Name = "sqlDataSource2";
|
|
this.sqlDataSource2.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
|
|
new Telerik.Reporting.SqlDataSourceParameter("@StartDate", System.Data.DbType.DateTime, "= Parameters.StartDate.Value"),
|
|
new Telerik.Reporting.SqlDataSourceParameter("@EndDate", System.Data.DbType.DateTime, "= Parameters.EndDate.Value")});
|
|
this.sqlDataSource2.SelectCommand = "select distinct Id, Name from dbo.VW_ResourceTeams where (TeamEndDate is null or " +
|
|
"not(TeamEndDate < @StartDate)) and not(TeamStartDate > @EndDate)";
|
|
//
|
|
// sqlDataSource3
|
|
//
|
|
this.sqlDataSource3.ConnectionString = "DefaultConnection";
|
|
this.sqlDataSource3.Name = "sqlDataSource3";
|
|
this.sqlDataSource3.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
|
|
new Telerik.Reporting.SqlDataSourceParameter("@StartDate", System.Data.DbType.DateTime, "= Parameters.StartDate.Value"),
|
|
new Telerik.Reporting.SqlDataSourceParameter("@EndDate", System.Data.DbType.DateTime, "= Parameters.EndDate.Value")});
|
|
this.sqlDataSource3.SelectCommand =
|
|
"select Id, Name, TeamId from VW_ResourceExpenditureCategoryWithSuperEC " +
|
|
"where ((TeamEndDate is null) or (TeamEndDate >= @StartDate)) and (TeamStartDate <= @EndDate)";
|
|
//
|
|
// DataSource3
|
|
//
|
|
this.DataSource3.DataMember = "SortColumn";
|
|
this.DataSource3.DataSource = typeof(EnVisage.Reports.Utils);
|
|
this.DataSource3.Name = "DataSource3";
|
|
//
|
|
// DataSource4
|
|
//
|
|
this.DataSource4.DataMember = "SortColumnDirection";
|
|
this.DataSource4.DataSource = typeof(EnVisage.Reports.Utils);
|
|
this.DataSource4.Name = "DataSource4";
|
|
//
|
|
// sqlDataSource1
|
|
//
|
|
this.sqlDataSource1.CalculatedFields.AddRange(new Telerik.Reporting.CalculatedField[] {
|
|
new Telerik.Reporting.CalculatedField("Percent Availability", typeof(double), "= (Fields.AvailableHours/(Fields.AllocatedHours+ Fields.AvailableHours+ Fields.No" +
|
|
"nProjectTimeHours))")});
|
|
this.sqlDataSource1.ConnectionString = "DefaultConnection";
|
|
this.sqlDataSource1.Name = "sqlDataSource1";
|
|
this.sqlDataSource1.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
|
|
new Telerik.Reporting.SqlDataSourceParameter("@StartDate", System.Data.DbType.DateTime, "= Parameters.StartDate.Value"),
|
|
new Telerik.Reporting.SqlDataSourceParameter("@EndDate", System.Data.DbType.DateTime, "= Parameters.EndDate.Value"),
|
|
new Telerik.Reporting.SqlDataSourceParameter("@Per", System.Data.DbType.String, "= Parameters.Per"),
|
|
new Telerik.Reporting.SqlDataSourceParameter("@AvailableHours", System.Data.DbType.String, "= Parameters.AvailableHours"),
|
|
new Telerik.Reporting.SqlDataSourceParameter("@DisregardNPTime", System.Data.DbType.Boolean, "= Parameters.DisregardNPTime")});
|
|
this.sqlDataSource1.SelectCommand = "select * from dbo.resourceAvailability_f(@StartDate, @EndDate, @Per, @AvailableHo" +
|
|
"urs, @DisregardNPTime)";
|
|
//
|
|
// detail
|
|
//
|
|
formattingRule1.Filters.Add(new Telerik.Reporting.Filter("=RowNumber()%2", Telerik.Reporting.FilterOperator.Equal, "1"));
|
|
formattingRule1.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(181)))), ((int)(((byte)(216)))), ((int)(((byte)(230)))));
|
|
this.detail.ConditionalFormatting.AddRange(new Telerik.Reporting.Drawing.FormattingRule[] {
|
|
formattingRule1});
|
|
this.detail.Height = Telerik.Reporting.Drawing.Unit.Inch(0.20007872581481934D);
|
|
this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
|
|
this.textBox4,
|
|
this.textBox6,
|
|
this.textBox5,
|
|
this.textBox9,
|
|
this.textBox10,
|
|
this.textBox36});
|
|
this.detail.Name = "detail";
|
|
//
|
|
// textBox4
|
|
//
|
|
this.textBox4.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.70011860132217407D), Telerik.Reporting.Drawing.Unit.Inch(7.8678131103515625E-05D));
|
|
this.textBox4.Name = "textBox4";
|
|
this.textBox4.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2000001668930054D), Telerik.Reporting.Drawing.Unit.Inch(0.20000004768371582D));
|
|
this.textBox4.Style.BackgroundColor = System.Drawing.Color.Empty;
|
|
this.textBox4.Value = "= Fields.LastName";
|
|
//
|
|
// textBox6
|
|
//
|
|
this.textBox6.Format = "{0:N2}";
|
|
this.textBox6.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(6.40625D), Telerik.Reporting.Drawing.Unit.Inch(7.8757606388535351E-05D));
|
|
this.textBox6.Name = "textBox6";
|
|
this.textBox6.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.1999998092651367D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox6.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
|
|
this.textBox6.Value = "= Fields.ResourceAvailability";
|
|
//
|
|
// textBox5
|
|
//
|
|
this.textBox5.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.9001976251602173D), Telerik.Reporting.Drawing.Unit.Inch(0D));
|
|
this.textBox5.Name = "textBox5";
|
|
this.textBox5.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.1999999284744263D), Telerik.Reporting.Drawing.Unit.Inch(0.20000004768371582D));
|
|
this.textBox5.Value = "= Fields.FirstName";
|
|
//
|
|
// textBox9
|
|
//
|
|
this.textBox9.Format = "{0:N2}";
|
|
this.textBox9.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.8000001907348633D), Telerik.Reporting.Drawing.Unit.Inch(0D));
|
|
this.textBox9.Name = "textBox9";
|
|
this.textBox9.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2998018264770508D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox9.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
|
|
this.textBox9.Value = "= Fields.AllocatedHours";
|
|
//
|
|
// textBox10
|
|
//
|
|
this.textBox10.Format = "{0:N2}";
|
|
this.textBox10.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.0998806953430176D), Telerik.Reporting.Drawing.Unit.Inch(0D));
|
|
this.textBox10.Name = "textBox10";
|
|
this.textBox10.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.3001194000244141D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox10.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
|
|
this.textBox10.Value = "= Fields.NonProjectTimeHours";
|
|
//
|
|
// textBox36
|
|
//
|
|
this.textBox36.Format = "{0:N2}";
|
|
this.textBox36.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.1002762317657471D), Telerik.Reporting.Drawing.Unit.Inch(0D));
|
|
this.textBox36.Name = "textBox36";
|
|
this.textBox36.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.69964504241943359D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox36.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
|
|
this.textBox36.Value = "= Fields.AvailableHours";
|
|
//
|
|
// pageFooterSection1
|
|
//
|
|
this.pageFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.39543977379798889D);
|
|
this.pageFooterSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
|
|
this.textBox34,
|
|
this.textBox1});
|
|
this.pageFooterSection1.Name = "pageFooterSection1";
|
|
//
|
|
// textBox34
|
|
//
|
|
this.textBox34.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9339065551757812E-05D), Telerik.Reporting.Drawing.Unit.Inch(0.19536082446575165D));
|
|
this.textBox34.Name = "textBox34";
|
|
this.textBox34.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.0999608039855957D), Telerik.Reporting.Drawing.Unit.Inch(0.20000004768371582D));
|
|
this.textBox34.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Left;
|
|
this.textBox34.Value = "=Now()";
|
|
//
|
|
// textBox1
|
|
//
|
|
this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(6.3999996185302734D), Telerik.Reporting.Drawing.Unit.Inch(0.19536113739013672D));
|
|
this.textBox1.Name = "textBox1";
|
|
this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2000001668930054D), Telerik.Reporting.Drawing.Unit.Inch(0.19999980926513672D));
|
|
this.textBox1.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
|
|
this.textBox1.Value = "=\"Page \"+PageNumber+\" of \" + PageCount";
|
|
//
|
|
// textBox2
|
|
//
|
|
this.textBox2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.8110237121582031D), Telerik.Reporting.Drawing.Unit.Inch(0.74488192796707153D));
|
|
this.textBox2.Name = "textBox2";
|
|
this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(3.9370079040527344D), Telerik.Reporting.Drawing.Unit.Inch(0.40000000596046448D));
|
|
this.textBox2.Style.Font.Bold = true;
|
|
this.textBox2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(15D);
|
|
this.textBox2.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
|
|
this.textBox2.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
|
|
this.textBox2.Value = "Resource Availability Report";
|
|
//
|
|
// reportHeaderSection1
|
|
//
|
|
this.reportHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(1.3811813592910767D);
|
|
this.reportHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
|
|
this.textBox2,
|
|
this.textBox11,
|
|
this.textBox15,
|
|
this.textBox19,
|
|
this.textBox24,
|
|
this.textBox30,
|
|
this.textBox40,
|
|
this.textBox41,
|
|
this.textBox42,
|
|
this.textBox43});
|
|
this.reportHeaderSection1.Name = "reportHeaderSection1";
|
|
//
|
|
// textBox11
|
|
//
|
|
this.textBox11.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(3.9339065551757812E-05D));
|
|
this.textBox11.Name = "textBox11";
|
|
this.textBox11.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.78736221790313721D), Telerik.Reporting.Drawing.Unit.Inch(0.23622052371501923D));
|
|
this.textBox11.Style.Font.Bold = true;
|
|
this.textBox11.Value = "Start Date: ";
|
|
//
|
|
// textBox15
|
|
//
|
|
this.textBox15.Format = "{0:d}";
|
|
this.textBox15.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.787480354309082D), Telerik.Reporting.Drawing.Unit.Inch(3.9339065551757812E-05D));
|
|
this.textBox15.Name = "textBox15";
|
|
this.textBox15.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.1811023950576782D), Telerik.Reporting.Drawing.Unit.Inch(0.23622052371501923D));
|
|
this.textBox15.Value = "= Parameters.StartDate.Value";
|
|
//
|
|
// textBox19
|
|
//
|
|
this.textBox19.Format = "{0:d}";
|
|
this.textBox19.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.78740161657333374D), Telerik.Reporting.Drawing.Unit.Inch(0.2363385409116745D));
|
|
this.textBox19.Name = "textBox19";
|
|
this.textBox19.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.1811023950576782D), Telerik.Reporting.Drawing.Unit.Inch(0.23622052371501923D));
|
|
this.textBox19.Value = "= Parameters.EndDate.Value";
|
|
//
|
|
// textBox24
|
|
//
|
|
this.textBox24.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(0.2363385409116745D));
|
|
this.textBox24.Name = "textBox24";
|
|
this.textBox24.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.78728348016738892D), Telerik.Reporting.Drawing.Unit.Inch(0.23622052371501923D));
|
|
this.textBox24.Style.Font.Bold = true;
|
|
this.textBox24.Value = "End Date: ";
|
|
//
|
|
// textBox30
|
|
//
|
|
this.textBox30.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(0.472637802362442D));
|
|
this.textBox30.Name = "textBox30";
|
|
this.textBox30.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.4959448575973511D), Telerik.Reporting.Drawing.Unit.Inch(0.23622052371501923D));
|
|
this.textBox30.Style.Font.Bold = true;
|
|
this.textBox30.Value = "Minimum Availability:";
|
|
//
|
|
// textBox40
|
|
//
|
|
this.textBox40.Format = "{0:N2}";
|
|
this.textBox40.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.4960631132125855D), Telerik.Reporting.Drawing.Unit.Inch(0.472637802362442D));
|
|
this.textBox40.Name = "textBox40";
|
|
this.textBox40.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.0236612558364868D), Telerik.Reporting.Drawing.Unit.Inch(0.23622052371501923D));
|
|
this.textBox40.Value = "= Parameters.AvailableHours.Value";
|
|
//
|
|
// textBox41
|
|
//
|
|
this.textBox41.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(0.70893716812133789D));
|
|
this.textBox41.Name = "textBox41";
|
|
this.textBox41.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.39992126822471619D), Telerik.Reporting.Drawing.Unit.Inch(0.23622052371501923D));
|
|
this.textBox41.Style.Font.Bold = true;
|
|
this.textBox41.Value = "Per:";
|
|
//
|
|
// textBox42
|
|
//
|
|
this.textBox42.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.40007910132408142D), Telerik.Reporting.Drawing.Unit.Inch(0.70893716812133789D));
|
|
this.textBox42.Name = "textBox42";
|
|
this.textBox42.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.0236612558364868D), Telerik.Reporting.Drawing.Unit.Inch(0.23622052371501923D));
|
|
this.textBox42.Value = "= IIF(Parameters.Per = 0, \'Total\', IIF(Parameters.Per = 1, \'Month\', \'Week\'))";
|
|
//
|
|
// textBox43
|
|
//
|
|
this.textBox43.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.9291338920593262D), Telerik.Reporting.Drawing.Unit.Inch(1.144960880279541D));
|
|
this.textBox43.Name = "textBox43";
|
|
this.textBox43.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(3.7031497955322266D), Telerik.Reporting.Drawing.Unit.Inch(0.23622052371501923D));
|
|
this.textBox43.Value = "Note: This report does not take into consideration holidays";
|
|
//
|
|
// pageHeaderSection1
|
|
//
|
|
this.pageHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D);
|
|
this.pageHeaderSection1.Name = "pageHeaderSection1";
|
|
//
|
|
// reportFooterSection1
|
|
//
|
|
this.reportFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.20003938674926758D);
|
|
this.reportFooterSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
|
|
this.textBox29,
|
|
this.textBox31,
|
|
this.textBox32,
|
|
this.textBox33,
|
|
this.textBox39});
|
|
this.reportFooterSection1.Name = "reportFooterSection1";
|
|
this.reportFooterSection1.Style.BackgroundColor = System.Drawing.Color.Transparent;
|
|
this.reportFooterSection1.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
|
|
this.reportFooterSection1.Style.BorderWidth.Top = Telerik.Reporting.Drawing.Unit.Point(2D);
|
|
//
|
|
// textBox29
|
|
//
|
|
this.textBox29.Format = "{0:N2}";
|
|
this.textBox29.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(6.40625D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
|
|
this.textBox29.Name = "textBox29";
|
|
this.textBox29.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.1999998092651367D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox29.Style.Font.Bold = true;
|
|
this.textBox29.Style.Font.Italic = false;
|
|
this.textBox29.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
|
|
this.textBox29.Value = "= Sum(Fields.ResourceAvailability)";
|
|
//
|
|
// textBox31
|
|
//
|
|
this.textBox31.Format = "{0:N2}";
|
|
this.textBox31.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.1064872741699219D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
|
|
this.textBox31.Name = "textBox31";
|
|
this.textBox31.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.293513298034668D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox31.Style.Font.Bold = true;
|
|
this.textBox31.Style.Font.Italic = false;
|
|
this.textBox31.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
|
|
this.textBox31.Value = "= Sum(Fields.NonProjectTimeHours)";
|
|
//
|
|
// textBox32
|
|
//
|
|
this.textBox32.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
|
|
this.textBox32.Name = "textBox32";
|
|
this.textBox32.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.39996063709259033D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox32.Style.Font.Bold = true;
|
|
this.textBox32.Style.Font.Italic = false;
|
|
this.textBox32.Value = "Total";
|
|
//
|
|
// textBox33
|
|
//
|
|
this.textBox33.Format = "{0:N2}";
|
|
this.textBox33.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.8000001907348633D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
|
|
this.textBox33.Name = "textBox33";
|
|
this.textBox33.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2998018264770508D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox33.Style.Font.Bold = true;
|
|
this.textBox33.Style.Font.Italic = false;
|
|
this.textBox33.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
|
|
this.textBox33.Value = "= Sum(Fields.AllocatedHours)";
|
|
//
|
|
// textBox39
|
|
//
|
|
this.textBox39.Format = "{0:N2}";
|
|
this.textBox39.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.1002762317657471D), Telerik.Reporting.Drawing.Unit.Inch(0D));
|
|
this.textBox39.Name = "textBox39";
|
|
this.textBox39.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.6998026967048645D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
|
|
this.textBox39.Style.Font.Bold = true;
|
|
this.textBox39.Style.Font.Italic = false;
|
|
this.textBox39.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
|
|
this.textBox39.Value = "= Sum(Fields.AvailableHours)";
|
|
//
|
|
// ResourceAvailability
|
|
//
|
|
this.DataSource = this.sqlDataSource1;
|
|
this.Filters.Add(new Telerik.Reporting.Filter("=IIF(Parameters.ExpenditureCategory.Value is null OR Parameters.ExpenditureCatego" +
|
|
"ry.Value.length = 0, true, Fields.ExpenditureCategoryId In Parameters.Expenditur" +
|
|
"eCategory.Value)", Telerik.Reporting.FilterOperator.Equal, "=True"));
|
|
this.Filters.Add(new Telerik.Reporting.Filter("=IIF(Parameters.Team.Value is null OR Parameters.Team.Value.length = 0, true, Fi" +
|
|
"elds.TeamId In Parameters.Team.Value)", Telerik.Reporting.FilterOperator.Equal, "=True"));
|
|
this.Filters.Add(new Telerik.Reporting.Filter("=IIF(Parameters.StartDate>Parameters.EndDate, true, 0)", Telerik.Reporting.FilterOperator.Equal, "=FALSE"));
|
|
group1.GroupFooter = this.groupFooterSection2;
|
|
group1.GroupHeader = this.groupHeaderSection2;
|
|
group1.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.ExpenditureCategoryId"));
|
|
group1.Name = "Expedinture Category";
|
|
group1.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.ExpenditureCategory", Telerik.Reporting.SortDirection.Asc));
|
|
group2.GroupFooter = this.groupFooterSection;
|
|
group2.GroupHeader = this.groupHeaderSection;
|
|
group2.Groupings.Add(new Telerik.Reporting.Grouping("= Fields.TeamId"));
|
|
group2.Name = "group";
|
|
group2.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.TeamName", Telerik.Reporting.SortDirection.Asc));
|
|
group3.GroupFooter = this.groupFooterSection1;
|
|
group3.GroupHeader = this.groupHeaderSection1;
|
|
group3.Name = "group1";
|
|
this.Groups.AddRange(new Telerik.Reporting.Group[] {
|
|
group1,
|
|
group2,
|
|
group3});
|
|
this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
|
|
this.groupHeaderSection2,
|
|
this.groupFooterSection2,
|
|
this.groupHeaderSection,
|
|
this.groupFooterSection,
|
|
this.groupHeaderSection1,
|
|
this.groupFooterSection1,
|
|
this.detail,
|
|
this.pageFooterSection1,
|
|
this.reportHeaderSection1,
|
|
this.pageHeaderSection1,
|
|
this.reportFooterSection1});
|
|
this.Name = "ResourceAvailability";
|
|
this.PageSettings.Landscape = true;
|
|
this.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Inch(1D), Telerik.Reporting.Drawing.Unit.Inch(1D), Telerik.Reporting.Drawing.Unit.Inch(1D), Telerik.Reporting.Drawing.Unit.Inch(1D));
|
|
this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter;
|
|
reportParameter1.AllowBlank = false;
|
|
reportParameter1.Name = "StartDate";
|
|
reportParameter1.Text = "Start Date";
|
|
reportParameter1.Type = Telerik.Reporting.ReportParameterType.DateTime;
|
|
reportParameter1.Visible = true;
|
|
reportParameter2.AllowBlank = false;
|
|
reportParameter2.Name = "EndDate";
|
|
reportParameter2.Text = "End Date";
|
|
reportParameter2.Type = Telerik.Reporting.ReportParameterType.DateTime;
|
|
reportParameter2.Visible = true;
|
|
reportParameter3.AllowNull = true;
|
|
reportParameter3.Name = "AvailableHours";
|
|
reportParameter3.Text = "Minimum Availability ";
|
|
reportParameter3.Type = Telerik.Reporting.ReportParameterType.Float;
|
|
reportParameter3.Value = "";
|
|
reportParameter3.Visible = true;
|
|
reportParameter4.AvailableValues.DataSource = this.DataSource2;
|
|
reportParameter4.AvailableValues.DisplayMember = "Item1";
|
|
reportParameter4.AvailableValues.ValueMember = "Item2";
|
|
reportParameter4.Name = "Per";
|
|
reportParameter4.Text = "Per";
|
|
reportParameter4.Type = Telerik.Reporting.ReportParameterType.Integer;
|
|
reportParameter4.Value = "0";
|
|
reportParameter4.Visible = true;
|
|
reportParameter5.AllowNull = true;
|
|
reportParameter5.AvailableValues.DataSource = this.sqlDataSource2;
|
|
reportParameter5.AvailableValues.DisplayMember = "= Fields.Name";
|
|
reportParameter5.AvailableValues.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Name", Telerik.Reporting.SortDirection.Asc));
|
|
reportParameter5.AvailableValues.ValueMember = "= Fields.Id";
|
|
reportParameter5.MultiValue = true;
|
|
reportParameter5.Name = "Team";
|
|
reportParameter5.Text = "Teams";
|
|
reportParameter5.Value = "";
|
|
reportParameter5.Visible = true;
|
|
reportParameter6.AllowNull = true;
|
|
reportParameter6.AvailableValues.DataSource = this.sqlDataSource3;
|
|
reportParameter6.AvailableValues.DisplayMember = "= Fields.Name";
|
|
reportParameter6.AvailableValues.Filters.Add(new Telerik.Reporting.Filter("=IIF(Parameters.Team.Value is null OR Parameters.Team.Value.length = 0, true, Fi" +
|
|
"elds.TeamId In Parameters.Team.Value)", Telerik.Reporting.FilterOperator.Equal, "=True"));
|
|
reportParameter6.AvailableValues.Sortings.Add(new Telerik.Reporting.Sorting("= Fields.Name", Telerik.Reporting.SortDirection.Asc));
|
|
reportParameter6.AvailableValues.ValueMember = "= Fields.Id";
|
|
reportParameter6.MultiValue = true;
|
|
reportParameter6.Name = "ExpenditureCategory";
|
|
reportParameter6.Text = "Expenditure Categories";
|
|
reportParameter6.Value = "";
|
|
reportParameter6.Visible = true;
|
|
reportParameter7.Name = "DisregardNPTime";
|
|
reportParameter7.Text = "Disregard Non-Project Time";
|
|
reportParameter7.Type = Telerik.Reporting.ReportParameterType.Boolean;
|
|
reportParameter7.Value = false;
|
|
reportParameter7.Visible = true;
|
|
reportParameter8.AvailableValues.DataSource = this.DataSource3;
|
|
reportParameter8.AvailableValues.DisplayMember = "Item1";
|
|
reportParameter8.AvailableValues.ValueMember = "Item2";
|
|
reportParameter8.Name = "SortColumn";
|
|
reportParameter8.Text = "Sort Column";
|
|
reportParameter8.Value = "LastName";
|
|
reportParameter8.Visible = true;
|
|
reportParameter9.AvailableValues.DataSource = this.DataSource4;
|
|
reportParameter9.AvailableValues.DisplayMember = "Item1";
|
|
reportParameter9.AvailableValues.ValueMember = "Item2";
|
|
reportParameter9.Name = "SortColumnDirection";
|
|
reportParameter9.Text = "Sort Column Direction";
|
|
reportParameter9.Type = Telerik.Reporting.ReportParameterType.Integer;
|
|
reportParameter9.Value = "0";
|
|
reportParameter9.Visible = true;
|
|
this.ReportParameters.Add(reportParameter1);
|
|
this.ReportParameters.Add(reportParameter2);
|
|
this.ReportParameters.Add(reportParameter3);
|
|
this.ReportParameters.Add(reportParameter4);
|
|
this.ReportParameters.Add(reportParameter5);
|
|
this.ReportParameters.Add(reportParameter6);
|
|
this.ReportParameters.Add(reportParameter7);
|
|
this.ReportParameters.Add(reportParameter8);
|
|
this.ReportParameters.Add(reportParameter9);
|
|
this.Sortings.Add(new Telerik.Reporting.Sorting("= IIF(Parameters.SortColumnDirection.Value = 0, Fields(Parameters.SortColumn.Valu" +
|
|
"e), false)", Telerik.Reporting.SortDirection.Asc));
|
|
this.Sortings.Add(new Telerik.Reporting.Sorting("= IIF(Parameters.SortColumnDirection.Value = 1, Fields(Parameters.SortColumn.Valu" +
|
|
"e), false)", Telerik.Reporting.SortDirection.Desc));
|
|
styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
|
|
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextItemBase)),
|
|
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.HtmlTextBox))});
|
|
styleRule1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(2D);
|
|
styleRule1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D);
|
|
this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] {
|
|
styleRule1});
|
|
this.Width = Telerik.Reporting.Drawing.Unit.Inch(7.6062493324279785D);
|
|
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
|
|
|
|
}
|
|
#endregion
|
|
private Telerik.Reporting.DetailSection detail;
|
|
private Telerik.Reporting.PageFooterSection pageFooterSection1;
|
|
private Telerik.Reporting.SqlDataSource sqlDataSource1;
|
|
private Telerik.Reporting.SqlDataSource sqlDataSource2;
|
|
private Telerik.Reporting.SqlDataSource sqlDataSource3;
|
|
Telerik.Reporting.ObjectDataSource DataSource2;
|
|
Telerik.Reporting.ObjectDataSource DataSource3;
|
|
Telerik.Reporting.ObjectDataSource DataSource4;
|
|
private Telerik.Reporting.TextBox textBox2;
|
|
private Telerik.Reporting.TextBox textBox1;
|
|
private Telerik.Reporting.TextBox textBox3;
|
|
private Telerik.Reporting.TextBox textBox4;
|
|
private Telerik.Reporting.TextBox textBox6;
|
|
private Telerik.Reporting.TextBox textBox5;
|
|
private Telerik.Reporting.ReportHeaderSection reportHeaderSection1;
|
|
private Telerik.Reporting.PageHeaderSection pageHeaderSection1;
|
|
private Telerik.Reporting.TextBox textBox7;
|
|
private Telerik.Reporting.TextBox textBox8;
|
|
private Telerik.Reporting.GroupHeaderSection groupHeaderSection1;
|
|
private Telerik.Reporting.GroupFooterSection groupFooterSection1;
|
|
private Telerik.Reporting.TextBox textBox9;
|
|
private Telerik.Reporting.TextBox textBox10;
|
|
private Telerik.Reporting.GroupHeaderSection groupHeaderSection2;
|
|
private Telerik.Reporting.GroupFooterSection groupFooterSection2;
|
|
private Telerik.Reporting.TextBox textBox12;
|
|
private Telerik.Reporting.TextBox textBox13;
|
|
private Telerik.Reporting.TextBox textBox14;
|
|
private Telerik.Reporting.TextBox textBox16;
|
|
private Telerik.Reporting.TextBox textBox17;
|
|
private Telerik.Reporting.TextBox textBox18;
|
|
private Telerik.Reporting.TextBox textBox20;
|
|
private Telerik.Reporting.TextBox textBox21;
|
|
private Telerik.Reporting.GroupHeaderSection groupHeaderSection;
|
|
private Telerik.Reporting.TextBox textBox22;
|
|
private Telerik.Reporting.GroupFooterSection groupFooterSection;
|
|
private Telerik.Reporting.TextBox textBox23;
|
|
private Telerik.Reporting.TextBox textBox25;
|
|
private Telerik.Reporting.TextBox textBox26;
|
|
private Telerik.Reporting.TextBox textBox27;
|
|
private Telerik.Reporting.TextBox textBox28;
|
|
private Telerik.Reporting.ReportFooterSection reportFooterSection1;
|
|
private Telerik.Reporting.TextBox textBox29;
|
|
private Telerik.Reporting.TextBox textBox31;
|
|
private Telerik.Reporting.TextBox textBox32;
|
|
private Telerik.Reporting.TextBox textBox33;
|
|
private Telerik.Reporting.TextBox textBox34;
|
|
private Telerik.Reporting.TextBox textBox38;
|
|
private Telerik.Reporting.TextBox textBox37;
|
|
private Telerik.Reporting.TextBox textBox35;
|
|
private Telerik.Reporting.TextBox textBox36;
|
|
private Telerik.Reporting.TextBox textBox39;
|
|
private Telerik.Reporting.TextBox textBox11;
|
|
private Telerik.Reporting.TextBox textBox15;
|
|
private Telerik.Reporting.TextBox textBox19;
|
|
private Telerik.Reporting.TextBox textBox24;
|
|
private Telerik.Reporting.TextBox textBox30;
|
|
private Telerik.Reporting.TextBox textBox40;
|
|
private Telerik.Reporting.TextBox textBox41;
|
|
private Telerik.Reporting.TextBox textBox42;
|
|
private Telerik.Reporting.TextBox textBox43;
|
|
}
|
|
} |