/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
DevExpress.DashboardCommon.CalculatedField calculatedField1 = new DevExpress.DashboardCommon.CalculatedField();
DevExpress.DashboardCommon.CalculatedField calculatedField2 = new DevExpress.DashboardCommon.CalculatedField();
DevExpress.DashboardCommon.CalculatedField calculatedField3 = new DevExpress.DashboardCommon.CalculatedField();
DevExpress.DashboardCommon.CalculatedField calculatedField4 = new DevExpress.DashboardCommon.CalculatedField();
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.Table table2 = new DevExpress.DataAccess.Sql.Table();
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.Table table3 = new DevExpress.DataAccess.Sql.Table();
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.Table table4 = new DevExpress.DataAccess.Sql.Table();
DevExpress.DataAccess.Sql.Column column8 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression8 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Table table5 = 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 table6 = new DevExpress.DataAccess.Sql.Table();
DevExpress.DataAccess.Sql.Column column10 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression10 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column11 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression11 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.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.DataAccess.Sql.Join join4 = new DevExpress.DataAccess.Sql.Join();
DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo4 = new DevExpress.DataAccess.Sql.RelationColumnInfo();
DevExpress.DataAccess.Sql.Join join5 = new DevExpress.DataAccess.Sql.Join();
DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo5 = new DevExpress.DataAccess.Sql.RelationColumnInfo();
DevExpress.DataAccess.Sql.Table table7 = new DevExpress.DataAccess.Sql.Table();
DevExpress.DataAccess.Sql.Join join6 = new DevExpress.DataAccess.Sql.Join();
DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo6 = new DevExpress.DataAccess.Sql.RelationColumnInfo();
DevExpress.DataAccess.Sql.Table table8 = new DevExpress.DataAccess.Sql.Table();
DevExpress.DataAccess.Sql.Join join7 = new DevExpress.DataAccess.Sql.Join();
DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo7 = new DevExpress.DataAccess.Sql.RelationColumnInfo();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(dash_ent_rtm_eval));
DevExpress.DashboardCommon.Measure measure1 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Measure measure2 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Dimension dimension1 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Dimension dimension2 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Gauge gauge1 = new DevExpress.DashboardCommon.Gauge();
DevExpress.DashboardCommon.Dimension dimension3 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Dimension dimension4 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Dimension dimension5 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Measure measure3 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Measure measure4 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Measure measure5 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Measure measure6 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Card card1 = new DevExpress.DashboardCommon.Card();
DevExpress.DashboardCommon.CardStretchedLayoutTemplate cardStretchedLayoutTemplate1 = new DevExpress.DashboardCommon.CardStretchedLayoutTemplate();
DevExpress.DashboardCommon.Measure measure7 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Measure measure8 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Card card2 = new DevExpress.DashboardCommon.Card();
DevExpress.DashboardCommon.CardStretchedLayoutTemplate cardStretchedLayoutTemplate2 = new DevExpress.DashboardCommon.CardStretchedLayoutTemplate();
DevExpress.DashboardCommon.Dimension dimension6 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Measure measure9 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Dimension dimension7 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup1 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup2 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem1 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem2 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup3 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem3 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem4 = new DevExpress.DashboardCommon.DashboardLayoutItem();
this.dashboardSqlDataSource1 = new DevExpress.DashboardCommon.DashboardSqlDataSource();
this.gaugeDashboardItem1 = new DevExpress.DashboardCommon.GaugeDashboardItem();
this.treeViewDashboardItem1 = new DevExpress.DashboardCommon.TreeViewDashboardItem();
this.cardDashboardItem1 = new DevExpress.DashboardCommon.CardDashboardItem();
this.textBoxDashboardItem1 = new DevExpress.DashboardCommon.TextBoxDashboardItem();
((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.treeViewDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension4)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension5)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure4)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.cardDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure5)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure6)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure7)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure8)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension6)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure9)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension7)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.textBoxDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// dashboardSqlDataSource1
//
calculatedField1.DataMember = "rc_rtm_criteria";
calculatedField1.Expression = "CountDistinct([eval_responseID])";
calculatedField1.Name = "countdistinct_eval_responseid";
calculatedField2.DataMember = "rc_rtm_criteria";
calculatedField2.Expression = "CountDistinct([res_itemID])";
calculatedField2.Name = "countdistinct_res_itemID";
calculatedField3.DataMember = "rc_rtm_criteria";
calculatedField3.Expression = "CountDistinct([ch_title])";
calculatedField3.Name = "countdistinct_ch_title";
calculatedField4.DataMember = "rc_rtm_criteria";
calculatedField4.Expression = "CountDistinct([src_title])";
calculatedField4.Name = "countdistinct_src_title";
this.dashboardSqlDataSource1.CalculatedFields.AddRange(new DevExpress.DashboardCommon.CalculatedField[] {
calculatedField1,
calculatedField2,
calculatedField3,
calculatedField4
});
this.dashboardSqlDataSource1.ComponentName = "dashboardSqlDataSource1";
this.dashboardSqlDataSource1.ConnectionName = "DevDB";
this.dashboardSqlDataSource1.Name = "SQL Data Source 1";
columnExpression1.ColumnName = "ch_title";
table1.MetaSerializable = "<Meta X=\"340\" Y=\"30\" Width=\"125\" Height=\"134\" />";
table1.Name = "rc_rtm_checklists";
columnExpression1.Table = table1;
column1.Expression = columnExpression1;
columnExpression2.ColumnName = "ch_deleted";
columnExpression2.Table = table1;
column2.Expression = columnExpression2;
columnExpression3.ColumnName = "src_title";
table2.MetaSerializable = "<Meta X=\"30\" Y=\"30\" Width=\"125\" Height=\"248\" />";
table2.Name = "rc_rtm_criteria";
columnExpression3.Table = table2;
column3.Expression = columnExpression3;
columnExpression4.ColumnName = "src_deleted";
columnExpression4.Table = table2;
column4.Expression = columnExpression4;
columnExpression5.ColumnName = "bo_name";
table3.MetaSerializable = "<Meta X=\"185\" Y=\"30\" Width=\"125\" Height=\"153\" />";
table3.Name = "rc_rtm_objectives";
columnExpression5.Table = table3;
column5.Expression = columnExpression5;
columnExpression6.ColumnName = "bo_deleted";
columnExpression6.Table = table3;
column6.Expression = columnExpression6;
columnExpression7.ColumnName = "res_itemID";
table4.MetaSerializable = "<Meta X=\"260\" Y=\"420\" Width=\"125\" Height=\"191\" />";
table4.Name = "rc_responses";
columnExpression7.Table = table4;
column7.Expression = columnExpression7;
columnExpression8.ColumnName = "eval_responseID";
table5.MetaSerializable = "<Meta X=\"450\" Y=\"400\" Width=\"125\" Height=\"210\" />";
table5.Name = "rc_evaluation";
columnExpression8.Table = table5;
column8.Expression = columnExpression8;
column9.Alias = "rc_projects_1_pro_name";
columnExpression9.ColumnName = "pro_name";
table6.Alias = "rc_projects_1";
table6.MetaSerializable = "<Meta X=\"760\" Y=\"30\" Width=\"125\" Height=\"362\" />";
table6.Name = "rc_projects";
columnExpression9.Table = table6;
column9.Expression = columnExpression9;
columnExpression10.ColumnName = "pro_color";
columnExpression10.Table = table6;
column10.Expression = columnExpression10;
columnExpression11.ColumnName = "pro_description";
columnExpression11.Table = table6;
column11.Expression = columnExpression11;
selectQuery1.Columns.Add(column1);
selectQuery1.Columns.Add(column2);
selectQuery1.Columns.Add(column3);
selectQuery1.Columns.Add(column4);
selectQuery1.Columns.Add(column5);
selectQuery1.Columns.Add(column6);
selectQuery1.Columns.Add(column7);
selectQuery1.Columns.Add(column8);
selectQuery1.Columns.Add(column9);
selectQuery1.Columns.Add(column10);
selectQuery1.Columns.Add(column11);
selectQuery1.Distinct = true;
selectQuery1.FilterString = "[rc_rtm_checklists.ch_deleted] = \'0\'";
selectQuery1.GroupFilterString = "";
selectQuery1.Name = "rc_rtm_criteria";
relationColumnInfo1.NestedKeyColumn = "bo_id";
relationColumnInfo1.ParentKeyColumn = "src_objective";
join1.KeyColumns.Add(relationColumnInfo1);
join1.Nested = table3;
join1.Parent = table2;
relationColumnInfo2.NestedKeyColumn = "ch_id";
relationColumnInfo2.ParentKeyColumn = "bo_checklist";
join2.KeyColumns.Add(relationColumnInfo2);
join2.Nested = table1;
join2.Parent = table3;
relationColumnInfo3.NestedKeyColumn = "res_itemID";
relationColumnInfo3.ParentKeyColumn = "src_id";
join3.KeyColumns.Add(relationColumnInfo3);
join3.Nested = table4;
join3.Parent = table2;
join3.Type = DevExpress.Xpo.DB.JoinType.LeftOuter;
relationColumnInfo4.NestedKeyColumn = "eval_responseID";
relationColumnInfo4.ParentKeyColumn = "res_id";
join4.KeyColumns.Add(relationColumnInfo4);
join4.Nested = table5;
join4.Parent = table4;
join4.Type = DevExpress.Xpo.DB.JoinType.LeftOuter;
relationColumnInfo5.NestedKeyColumn = "act_checklist";
relationColumnInfo5.ParentKeyColumn = "ch_id";
join5.KeyColumns.Add(relationColumnInfo5);
table7.MetaSerializable = "<Meta X=\"605\" Y=\"30\" Width=\"125\" Height=\"134\" />";
table7.Name = "rc_rtm_active";
join5.Nested = table7;
join5.Parent = table1;
relationColumnInfo6.NestedKeyColumn = "pro_ID";
relationColumnInfo6.ParentKeyColumn = "res_projectID";
join6.KeyColumns.Add(relationColumnInfo6);
table8.MetaSerializable = "<Meta X=\"410\" Y=\"670\" Width=\"125\" Height=\"362\" />";
table8.Name = "rc_projects";
join6.Nested = table8;
join6.Parent = table4;
join6.Type = DevExpress.Xpo.DB.JoinType.LeftOuter;
relationColumnInfo7.NestedKeyColumn = "pro_ID";
relationColumnInfo7.ParentKeyColumn = "act_projectID";
join7.KeyColumns.Add(relationColumnInfo7);
join7.Nested = table6;
join7.Parent = table7;
selectQuery1.Relations.Add(join1);
selectQuery1.Relations.Add(join2);
selectQuery1.Relations.Add(join3);
selectQuery1.Relations.Add(join4);
selectQuery1.Relations.Add(join5);
selectQuery1.Relations.Add(join6);
selectQuery1.Relations.Add(join7);
selectQuery1.Tables.Add(table2);
selectQuery1.Tables.Add(table3);
selectQuery1.Tables.Add(table1);
selectQuery1.Tables.Add(table4);
selectQuery1.Tables.Add(table5);
selectQuery1.Tables.Add(table7);
selectQuery1.Tables.Add(table8);
selectQuery1.Tables.Add(table6);
this.dashboardSqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1
});
this.dashboardSqlDataSource1.ResultSchemaSerializable = resources.GetString("dashboardSqlDataSource1.ResultSchemaSerializable");
//
// gaugeDashboardItem1
//
this.gaugeDashboardItem1.ComponentName = "gaugeDashboardItem1";
measure1.DataMember = "countdistinct_src_title";
measure1.Name = "# of Checklist Items";
measure2.DataMember = "countdistinct_res_itemID";
measure2.Name = "# of Responses";
dimension1.DataMember = "rc_projects_1_pro_name";
dimension1.Name = "Project name";
dimension2.DataMember = "ch_title";
dimension2.Name = "Checklist Title";
this.gaugeDashboardItem1.DataItemRepository.Clear();
this.gaugeDashboardItem1.DataItemRepository.Add(measure1, "DataItem0");
this.gaugeDashboardItem1.DataItemRepository.Add(measure2, "DataItem1");
this.gaugeDashboardItem1.DataItemRepository.Add(dimension1, "DataItem2");
this.gaugeDashboardItem1.DataItemRepository.Add(dimension2, "DataItem3");
this.gaugeDashboardItem1.DataMember = "rc_rtm_criteria";
this.gaugeDashboardItem1.DataSource = this.dashboardSqlDataSource1;
gauge1.DeltaOptions.ResultIndicationThresholdType = DevExpress.DashboardCommon.DeltaIndicationThresholdType.Absolute;
gauge1.DeltaOptions.ValueType = DevExpress.DashboardCommon.DeltaValueType.ActualValue;
gauge1.AddDataItem("TargetValue", measure1);
gauge1.AddDataItem("ActualValue", measure2);
this.gaugeDashboardItem1.Gauges.AddRange(new DevExpress.DashboardCommon.Gauge[] {
gauge1
});
this.gaugeDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
this.gaugeDashboardItem1.InteractivityOptions.IsDrillDownEnabled = true;
this.gaugeDashboardItem1.Name = "# of Responses Vs. # of Checklist Items";
this.gaugeDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension1,
dimension2
});
this.gaugeDashboardItem1.ShowCaption = true;
this.gaugeDashboardItem1.ViewType = DevExpress.DashboardCommon.GaugeViewType.LinearVertical;
//
// treeViewDashboardItem1
//
this.treeViewDashboardItem1.ComponentName = "treeViewDashboardItem1";
dimension3.DataMember = "rc_projects_1_pro_name";
dimension3.Name = "Project name";
dimension4.DataMember = "ch_title";
dimension4.Name = "Checklist Title";
dimension5.DataMember = "src_title";
dimension5.Name = "Checklist Item Title";
measure3.DataMember = "countdistinct_src_title";
measure3.Name = "count of Checklist Items";
measure4.DataMember = "countdistinct_ch_title";
measure4.Name = "Count of checklist Title";
this.treeViewDashboardItem1.DataItemRepository.Clear();
this.treeViewDashboardItem1.DataItemRepository.Add(dimension3, "DataItem0");
this.treeViewDashboardItem1.DataItemRepository.Add(dimension4, "DataItem1");
this.treeViewDashboardItem1.DataItemRepository.Add(dimension5, "DataItem2");
this.treeViewDashboardItem1.DataItemRepository.Add(measure3, "DataItem3");
this.treeViewDashboardItem1.DataItemRepository.Add(measure4, "DataItem4");
this.treeViewDashboardItem1.DataMember = "rc_rtm_criteria";
this.treeViewDashboardItem1.DataSource = this.dashboardSqlDataSource1;
this.treeViewDashboardItem1.EnableSearch = true;
this.treeViewDashboardItem1.FilterDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension3,
dimension4,
dimension5
});
this.treeViewDashboardItem1.HiddenMeasures.AddRange(new DevExpress.DashboardCommon.Measure[] {
measure3,
measure4
});
this.treeViewDashboardItem1.InteractivityOptions.IgnoreMasterFilters = true;
this.treeViewDashboardItem1.Name = "Data Selector";
this.treeViewDashboardItem1.ShowCaption = true;
//
// cardDashboardItem1
//
measure5.DataMember = "countdistinct_res_itemID";
measure5.Name = "Count of Responses";
measure6.DataMember = "countdistinct_src_title";
measure6.Name = "Count of Checklist Items";
cardStretchedLayoutTemplate1.BottomValue1.DimensionIndex = 0;
cardStretchedLayoutTemplate1.BottomValue1.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.PercentVariation;
cardStretchedLayoutTemplate1.BottomValue1.Visible = true;
cardStretchedLayoutTemplate1.BottomValue2.DimensionIndex = 0;
cardStretchedLayoutTemplate1.BottomValue2.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.AbsoluteVariation;
cardStretchedLayoutTemplate1.BottomValue2.Visible = true;
cardStretchedLayoutTemplate1.DeltaIndicator.Visible = true;
cardStretchedLayoutTemplate1.MainValue.DimensionIndex = 0;
cardStretchedLayoutTemplate1.MainValue.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.Title;
cardStretchedLayoutTemplate1.MainValue.Visible = true;
cardStretchedLayoutTemplate1.Sparkline.Visible = true;
cardStretchedLayoutTemplate1.SubValue.DimensionIndex = 0;
cardStretchedLayoutTemplate1.SubValue.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.Subtitle;
cardStretchedLayoutTemplate1.SubValue.Visible = true;
cardStretchedLayoutTemplate1.TopValue.DimensionIndex = 0;
cardStretchedLayoutTemplate1.TopValue.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.ActualValue;
cardStretchedLayoutTemplate1.TopValue.Visible = true;
card1.LayoutTemplate = cardStretchedLayoutTemplate1;
card1.AddDataItem("ActualValue", measure5);
card1.AddDataItem("TargetValue", measure6);
measure7.DataMember = "countdistinct_eval_responseid";
measure7.Name = "Count of Evaluations";
measure8.DataMember = "countdistinct_src_title";
measure8.Name = "Count of Checklist Items";
cardStretchedLayoutTemplate2.BottomValue1.DimensionIndex = 0;
cardStretchedLayoutTemplate2.BottomValue1.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.PercentVariation;
cardStretchedLayoutTemplate2.BottomValue1.Visible = true;
cardStretchedLayoutTemplate2.BottomValue2.DimensionIndex = 0;
cardStretchedLayoutTemplate2.BottomValue2.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.AbsoluteVariation;
cardStretchedLayoutTemplate2.BottomValue2.Visible = true;
cardStretchedLayoutTemplate2.DeltaIndicator.Visible = true;
cardStretchedLayoutTemplate2.MainValue.DimensionIndex = 0;
cardStretchedLayoutTemplate2.MainValue.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.Title;
cardStretchedLayoutTemplate2.MainValue.Visible = true;
cardStretchedLayoutTemplate2.Sparkline.Visible = true;
cardStretchedLayoutTemplate2.SubValue.DimensionIndex = 0;
cardStretchedLayoutTemplate2.SubValue.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.Subtitle;
cardStretchedLayoutTemplate2.SubValue.Visible = true;
cardStretchedLayoutTemplate2.TopValue.DimensionIndex = 0;
cardStretchedLayoutTemplate2.TopValue.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.ActualValue;
cardStretchedLayoutTemplate2.TopValue.Visible = true;
card2.LayoutTemplate = cardStretchedLayoutTemplate2;
card2.AddDataItem("ActualValue", measure7);
card2.AddDataItem("TargetValue", measure8);
this.cardDashboardItem1.Cards.AddRange(new DevExpress.DashboardCommon.Card[] {
card1,
card2
});
this.cardDashboardItem1.ComponentName = "cardDashboardItem1";
dimension6.DataMember = "rc_projects_1_pro_name";
dimension6.Name = "Project Name";
measure9.DataMember = "countdistinct_res_itemID";
measure9.Name = "Count of Responses";
dimension7.DataMember = "ch_title";
dimension7.Name = "Checklist Title";
this.cardDashboardItem1.DataItemRepository.Clear();
this.cardDashboardItem1.DataItemRepository.Add(dimension6, "DataItem0");
this.cardDashboardItem1.DataItemRepository.Add(measure9, "DataItem2");
this.cardDashboardItem1.DataItemRepository.Add(measure7, "DataItem3");
this.cardDashboardItem1.DataItemRepository.Add(measure5, "DataItem1");
this.cardDashboardItem1.DataItemRepository.Add(dimension7, "DataItem4");
this.cardDashboardItem1.DataItemRepository.Add(measure6, "DataItem5");
this.cardDashboardItem1.DataItemRepository.Add(measure8, "DataItem6");
this.cardDashboardItem1.DataMember = "rc_rtm_criteria";
this.cardDashboardItem1.DataSource = this.dashboardSqlDataSource1;
this.cardDashboardItem1.HiddenMeasures.AddRange(new DevExpress.DashboardCommon.Measure[] {
measure9
});
this.cardDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
this.cardDashboardItem1.InteractivityOptions.IsDrillDownEnabled = true;
this.cardDashboardItem1.Name = "";
this.cardDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension6,
dimension7
});
this.cardDashboardItem1.ShowCaption = true;
//
// textBoxDashboardItem1
//
this.textBoxDashboardItem1.ComponentName = "textBoxDashboardItem1";
this.textBoxDashboardItem1.DataItemRepository.Clear();
this.textBoxDashboardItem1.InnerRtf = resources.GetString("textBoxDashboardItem1.InnerRtf");
this.textBoxDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
this.textBoxDashboardItem1.Name = "Text Box 1";
this.textBoxDashboardItem1.ShowCaption = false;
//
// dash_ent_rtm_eval
//
this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] {
this.dashboardSqlDataSource1
});
this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] {
this.gaugeDashboardItem1,
this.treeViewDashboardItem1,
this.cardDashboardItem1,
this.textBoxDashboardItem1
});
dashboardLayoutItem1.DashboardItem = this.treeViewDashboardItem1;
dashboardLayoutItem1.Weight = 30.592105263157894D;
dashboardLayoutItem2.DashboardItem = this.textBoxDashboardItem1;
dashboardLayoutItem2.Weight = 69.40789473684211D;
dashboardLayoutGroup2.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
dashboardLayoutItem1,
dashboardLayoutItem2
});
dashboardLayoutGroup2.DashboardItem = null;
dashboardLayoutGroup2.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical;
dashboardLayoutGroup2.Weight = 19.068934646374217D;
dashboardLayoutItem3.DashboardItem = this.gaugeDashboardItem1;
dashboardLayoutItem3.Weight = 50D;
dashboardLayoutItem4.DashboardItem = this.cardDashboardItem1;
dashboardLayoutItem4.Weight = 50D;
dashboardLayoutGroup3.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
dashboardLayoutItem3,
dashboardLayoutItem4
});
dashboardLayoutGroup3.DashboardItem = null;
dashboardLayoutGroup3.Weight = 80.931065353625783D;
dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
dashboardLayoutGroup2,
dashboardLayoutGroup3
});
dashboardLayoutGroup1.DashboardItem = null;
this.LayoutRoot = dashboardLayoutGroup1;
this.Title.ShowMasterFilterState = false;
this.Title.Text = "RTM Item Metric";
((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure1)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure2)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension3)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension4)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension5)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure3)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure4)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.treeViewDashboardItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure5)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure6)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure7)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure8)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension6)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure9)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension7)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.cardDashboardItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.textBoxDashboardItem1)).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()
{
DevExpress.DashboardCommon.Dimension dimension1 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Dimension dimension2 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Measure measure1 = new DevExpress.DashboardCommon.Measure();
DevExpress.DataAccess.Sql.CustomSqlQuery customSqlQuery1 = new DevExpress.DataAccess.Sql.CustomSqlQuery();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(dash_ent_workflow));
DevExpress.DashboardCommon.Dimension dimension3 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Dimension dimension4 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Dimension dimension5 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Dimension dimension6 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Dimension dimension7 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn1 = new DevExpress.DashboardCommon.GridDimensionColumn();
DevExpress.DashboardCommon.Dimension dimension8 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn2 = new DevExpress.DashboardCommon.GridDimensionColumn();
DevExpress.DashboardCommon.Dimension dimension9 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn3 = new DevExpress.DashboardCommon.GridDimensionColumn();
DevExpress.DashboardCommon.Dimension dimension10 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn4 = new DevExpress.DashboardCommon.GridDimensionColumn();
DevExpress.DashboardCommon.Dimension dimension11 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn5 = new DevExpress.DashboardCommon.GridDimensionColumn();
DevExpress.DashboardCommon.Dimension dimension12 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn6 = new DevExpress.DashboardCommon.GridDimensionColumn();
DevExpress.DashboardCommon.Dimension dimension13 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn7 = new DevExpress.DashboardCommon.GridDimensionColumn();
DevExpress.DashboardCommon.Dimension dimension14 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn8 = new DevExpress.DashboardCommon.GridDimensionColumn();
DevExpress.DashboardCommon.Measure measure2 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Dimension dimension15 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Gauge gauge1 = new DevExpress.DashboardCommon.Gauge();
DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup1 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup2 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem1 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem2 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem3 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem4 = new DevExpress.DashboardCommon.DashboardLayoutItem();
this.pieDashboardItem1 = new DevExpress.DashboardCommon.PieDashboardItem();
this.dashboardSqlDataSource1 = new DevExpress.DashboardCommon.DashboardSqlDataSource();
this.treeViewDashboardItem1 = new DevExpress.DashboardCommon.TreeViewDashboardItem();
this.gridDashboardItem1 = new DevExpress.DashboardCommon.GridDashboardItem();
this.gaugeDashboardItem1 = new DevExpress.DashboardCommon.GaugeDashboardItem();
((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.treeViewDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension4)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension5)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension6)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension7)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension8)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension9)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension10)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension11)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension12)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension13)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension14)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension15)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// pieDashboardItem1
//
dimension1.DataMember = "Status";
this.pieDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension1
});
this.pieDashboardItem1.ComponentName = "pieDashboardItem1";
dimension2.DataMember = "Worker";
measure1.DataMember = "Status";
measure1.SummaryType = DevExpress.DashboardCommon.SummaryType.CountDistinct;
this.pieDashboardItem1.DataItemRepository.Clear();
this.pieDashboardItem1.DataItemRepository.Add(dimension2, "DataItem0");
this.pieDashboardItem1.DataItemRepository.Add(dimension1, "DataItem2");
this.pieDashboardItem1.DataItemRepository.Add(measure1, "DataItem3");
this.pieDashboardItem1.DataMember = "Query";
this.pieDashboardItem1.DataSource = this.dashboardSqlDataSource1;
this.pieDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
this.pieDashboardItem1.Name = "Workflow Activities by users";
this.pieDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension2
});
this.pieDashboardItem1.ShowCaption = true;
this.pieDashboardItem1.Values.AddRange(new DevExpress.DashboardCommon.Measure[] {
measure1
});
//
// dashboardSqlDataSource1
//
this.dashboardSqlDataSource1.ComponentName = "dashboardSqlDataSource1";
this.dashboardSqlDataSource1.ConnectionName = "DevDB";
this.dashboardSqlDataSource1.Name = "SQL Data Source 1";
customSqlQuery1.Name = "Query";
customSqlQuery1.Sql = resources.GetString("customSqlQuery1.Sql");
this.dashboardSqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
customSqlQuery1
});
this.dashboardSqlDataSource1.ResultSchemaSerializable = resources.GetString("dashboardSqlDataSource1.ResultSchemaSerializable");
//
// treeViewDashboardItem1
//
this.treeViewDashboardItem1.ComponentName = "treeViewDashboardItem1";
dimension3.DataMember = "Project Name";
dimension4.DataMember = "Worker";
dimension5.DataMember = "Item";
dimension6.DataMember = "Status";
this.treeViewDashboardItem1.DataItemRepository.Clear();
this.treeViewDashboardItem1.DataItemRepository.Add(dimension3, "DataItem0");
this.treeViewDashboardItem1.DataItemRepository.Add(dimension4, "DataItem1");
this.treeViewDashboardItem1.DataItemRepository.Add(dimension5, "DataItem2");
this.treeViewDashboardItem1.DataItemRepository.Add(dimension6, "DataItem3");
this.treeViewDashboardItem1.DataMember = "Query";
this.treeViewDashboardItem1.DataSource = this.dashboardSqlDataSource1;
this.treeViewDashboardItem1.FilterDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension3,
dimension4,
dimension6,
dimension5
});
this.treeViewDashboardItem1.InteractivityOptions.IgnoreMasterFilters = true;
this.treeViewDashboardItem1.Name = "Project selector";
this.treeViewDashboardItem1.ShowCaption = true;
//
// gridDashboardItem1
//
dimension7.DataMember = "Project Name";
gridDimensionColumn1.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridDimensionColumn1.AddDataItem("Dimension", dimension7);
dimension8.DataMember = "Item";
gridDimensionColumn2.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridDimensionColumn2.AddDataItem("Dimension", dimension8);
dimension9.DataMember = "Unique Id";
gridDimensionColumn3.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridDimensionColumn3.AddDataItem("Dimension", dimension9);
dimension10.DataMember = "Title";
gridDimensionColumn4.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridDimensionColumn4.AddDataItem("Dimension", dimension10);
dimension11.DataMember = "Status";
gridDimensionColumn5.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridDimensionColumn5.AddDataItem("Dimension", dimension11);
dimension12.DataMember = "Date";
dimension12.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.DayMonthYear;
dimension12.Name = "Assigned Date";
gridDimensionColumn6.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridDimensionColumn6.AddDataItem("Dimension", dimension12);
dimension13.DataMember = "DueDate";
dimension13.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.DayMonthYear;
dimension13.Name = "DueDate";
dimension13.SortOrder = DevExpress.DashboardCommon.DimensionSortOrder.Descending;
gridDimensionColumn7.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridDimensionColumn7.AddDataItem("Dimension", dimension13);
dimension14.DataMember = "Worker";
dimension14.Name = "Assigned to";
gridDimensionColumn8.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridDimensionColumn8.AddDataItem("Dimension", dimension14);
this.gridDashboardItem1.Columns.AddRange(new DevExpress.DashboardCommon.GridColumnBase[] {
gridDimensionColumn1,
gridDimensionColumn2,
gridDimensionColumn3,
gridDimensionColumn4,
gridDimensionColumn5,
gridDimensionColumn6,
gridDimensionColumn7,
gridDimensionColumn8
});
this.gridDashboardItem1.ComponentName = "gridDashboardItem1";
this.gridDashboardItem1.DataItemRepository.Clear();
this.gridDashboardItem1.DataItemRepository.Add(dimension7, "DataItem0");
this.gridDashboardItem1.DataItemRepository.Add(dimension8, "DataItem1");
this.gridDashboardItem1.DataItemRepository.Add(dimension9, "DataItem2");
this.gridDashboardItem1.DataItemRepository.Add(dimension10, "DataItem3");
this.gridDashboardItem1.DataItemRepository.Add(dimension11, "DataItem4");
this.gridDashboardItem1.DataItemRepository.Add(dimension12, "DataItem5");
this.gridDashboardItem1.DataItemRepository.Add(dimension13, "DataItem6");
this.gridDashboardItem1.DataItemRepository.Add(dimension14, "DataItem7");
this.gridDashboardItem1.DataMember = "Query";
this.gridDashboardItem1.DataSource = this.dashboardSqlDataSource1;
this.gridDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
this.gridDashboardItem1.Name = "Items assigned to users by project";
this.gridDashboardItem1.ShowCaption = true;
//
// gaugeDashboardItem1
//
this.gaugeDashboardItem1.ComponentName = "gaugeDashboardItem1";
measure2.DataMember = "Item";
measure2.SummaryType = DevExpress.DashboardCommon.SummaryType.Count;
dimension15.DataMember = "Worker";
this.gaugeDashboardItem1.DataItemRepository.Clear();
this.gaugeDashboardItem1.DataItemRepository.Add(measure2, "DataItem0");
this.gaugeDashboardItem1.DataItemRepository.Add(dimension15, "DataItem1");
this.gaugeDashboardItem1.DataMember = "Query";
this.gaugeDashboardItem1.DataSource = this.dashboardSqlDataSource1;
gauge1.AddDataItem("ActualValue", measure2);
this.gaugeDashboardItem1.Gauges.AddRange(new DevExpress.DashboardCommon.Gauge[] {
gauge1
});
this.gaugeDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
this.gaugeDashboardItem1.Name = "Count of workflow items per user";
this.gaugeDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension15
});
this.gaugeDashboardItem1.ShowCaption = true;
//
// dash_ent_workflow
//
this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] {
this.dashboardSqlDataSource1
});
this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] {
this.pieDashboardItem1,
this.gridDashboardItem1,
this.treeViewDashboardItem1,
this.gaugeDashboardItem1
});
dashboardLayoutItem1.DashboardItem = this.pieDashboardItem1;
dashboardLayoutItem1.Weight = 42.942942942942942D;
dashboardLayoutItem2.DashboardItem = this.gaugeDashboardItem1;
dashboardLayoutItem2.Weight = 42.942942942942942D;
dashboardLayoutItem3.DashboardItem = this.treeViewDashboardItem1;
dashboardLayoutItem3.Weight = 14.114114114114114D;
dashboardLayoutGroup2.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
dashboardLayoutItem1,
dashboardLayoutItem2,
dashboardLayoutItem3
});
dashboardLayoutGroup2.DashboardItem = null;
dashboardLayoutGroup2.Weight = 50.060901339829478D;
dashboardLayoutItem4.DashboardItem = this.gridDashboardItem1;
dashboardLayoutItem4.Weight = 49.939098660170522D;
dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
dashboardLayoutGroup2,
dashboardLayoutItem4
});
dashboardLayoutGroup1.DashboardItem = null;
dashboardLayoutGroup1.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical;
this.LayoutRoot = dashboardLayoutGroup1;
this.Title.Text = "Dashboard";
((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension3)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension4)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension5)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension6)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.treeViewDashboardItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension7)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension8)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension9)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension10)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension11)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension12)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension13)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension14)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure2)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension15)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem1)).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()
{
DevExpress.DashboardCommon.Dimension dimension1 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Measure measure1 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Dimension dimension2 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DataAccess.Sql.CustomSqlQuery customSqlQuery1 = new DevExpress.DataAccess.Sql.CustomSqlQuery();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(dash_pro_workflow_allUsers));
DevExpress.DashboardCommon.Dimension dimension3 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Measure measure2 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Gauge gauge1 = new DevExpress.DashboardCommon.Gauge();
DevExpress.DashboardCommon.Dimension dimension4 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn1 = new DevExpress.DashboardCommon.GridDimensionColumn();
DevExpress.DashboardCommon.Dimension dimension5 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn2 = new DevExpress.DashboardCommon.GridDimensionColumn();
DevExpress.DashboardCommon.Dimension dimension6 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn3 = new DevExpress.DashboardCommon.GridDimensionColumn();
DevExpress.DashboardCommon.Dimension dimension7 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn4 = new DevExpress.DashboardCommon.GridDimensionColumn();
DevExpress.DashboardCommon.Dimension dimension8 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn5 = new DevExpress.DashboardCommon.GridDimensionColumn();
DevExpress.DashboardCommon.Dimension dimension9 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn6 = new DevExpress.DashboardCommon.GridDimensionColumn();
DevExpress.DashboardCommon.Dimension dimension10 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn7 = new DevExpress.DashboardCommon.GridDimensionColumn();
DevExpress.DashboardCommon.Dimension dimension11 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.GridDimensionColumn gridDimensionColumn8 = new DevExpress.DashboardCommon.GridDimensionColumn();
DevExpress.DashboardCommon.Dimension dimension12 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Dimension dimension13 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Dimension dimension14 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Dimension dimension15 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup1 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup2 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem1 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem2 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem3 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem4 = new DevExpress.DashboardCommon.DashboardLayoutItem();
this.pieDashboardItem1 = new DevExpress.DashboardCommon.PieDashboardItem();
this.dashboardSqlDataSource1 = new DevExpress.DashboardCommon.DashboardSqlDataSource();
this.gaugeDashboardItem1 = new DevExpress.DashboardCommon.GaugeDashboardItem();
this.gridDashboardItem1 = new DevExpress.DashboardCommon.GridDashboardItem();
this.treeViewDashboardItem1 = new DevExpress.DashboardCommon.TreeViewDashboardItem();
((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension4)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension5)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension6)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension7)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension8)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension9)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension10)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension11)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.treeViewDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension12)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension13)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension14)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension15)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// pieDashboardItem1
//
dimension1.DataMember = "Status";
this.pieDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension1
});
this.pieDashboardItem1.ComponentName = "pieDashboardItem1";
measure1.DataMember = "Status";
measure1.SummaryType = DevExpress.DashboardCommon.SummaryType.CountDistinct;
dimension2.DataMember = "UserName";
this.pieDashboardItem1.DataItemRepository.Clear();
this.pieDashboardItem1.DataItemRepository.Add(dimension1, "DataItem0");
this.pieDashboardItem1.DataItemRepository.Add(measure1, "DataItem1");
this.pieDashboardItem1.DataItemRepository.Add(dimension2, "DataItem2");
this.pieDashboardItem1.DataMember = "Query";
this.pieDashboardItem1.DataSource = this.dashboardSqlDataSource1;
this.pieDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
this.pieDashboardItem1.InteractivityOptions.IsDrillDownEnabled = true;
this.pieDashboardItem1.Name = "Workflow Status activities of users";
this.pieDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension2
});
this.pieDashboardItem1.ShowCaption = true;
this.pieDashboardItem1.Values.AddRange(new DevExpress.DashboardCommon.Measure[] {
measure1
});
//
// dashboardSqlDataSource1
//
this.dashboardSqlDataSource1.ComponentName = "dashboardSqlDataSource1";
this.dashboardSqlDataSource1.ConnectionName = "DevDB";
this.dashboardSqlDataSource1.Name = "SQL Data Source 1";
customSqlQuery1.Name = "Query";
customSqlQuery1.Sql = resources.GetString("customSqlQuery1.Sql");
this.dashboardSqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
customSqlQuery1
});
this.dashboardSqlDataSource1.ResultSchemaSerializable = resources.GetString("dashboardSqlDataSource1.ResultSchemaSerializable");
//
// gaugeDashboardItem1
//
this.gaugeDashboardItem1.ComponentName = "gaugeDashboardItem1";
dimension3.DataMember = "UserName";
measure2.DataMember = "RC_ID";
measure2.SummaryType = DevExpress.DashboardCommon.SummaryType.Count;
this.gaugeDashboardItem1.DataItemRepository.Clear();
this.gaugeDashboardItem1.DataItemRepository.Add(dimension3, "DataItem0");
this.gaugeDashboardItem1.DataItemRepository.Add(measure2, "DataItem1");
this.gaugeDashboardItem1.DataMember = "Query";
this.gaugeDashboardItem1.DataSource = this.dashboardSqlDataSource1;
gauge1.AddDataItem("ActualValue", measure2);
this.gaugeDashboardItem1.Gauges.AddRange(new DevExpress.DashboardCommon.Gauge[] {
gauge1
});
this.gaugeDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
this.gaugeDashboardItem1.InteractivityOptions.IsDrillDownEnabled = true;
this.gaugeDashboardItem1.Name = "Count of workflow items per user";
this.gaugeDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension3
});
this.gaugeDashboardItem1.ShowCaption = true;
//
// gridDashboardItem1
//
dimension4.DataMember = "pro_name";
gridDimensionColumn1.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridDimensionColumn1.AddDataItem("Dimension", dimension4);
dimension5.DataMember = "RC_ID";
gridDimensionColumn2.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridDimensionColumn2.AddDataItem("Dimension", dimension5);
dimension6.DataMember = "RC_NAME";
gridDimensionColumn3.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridDimensionColumn3.AddDataItem("Dimension", dimension6);
dimension7.DataMember = "RC_TYPE";
gridDimensionColumn4.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridDimensionColumn4.AddDataItem("Dimension", dimension7);
dimension8.DataMember = "Status";
gridDimensionColumn5.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridDimensionColumn5.AddDataItem("Dimension", dimension8);
dimension9.DataMember = "Date";
gridDimensionColumn6.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridDimensionColumn6.AddDataItem("Dimension", dimension9);
dimension10.DataMember = "DueDate";
gridDimensionColumn7.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridDimensionColumn7.AddDataItem("Dimension", dimension10);
dimension11.DataMember = "UserName";
gridDimensionColumn8.WidthType = DevExpress.DashboardCommon.GridColumnFixedWidthType.Weight;
gridDimensionColumn8.AddDataItem("Dimension", dimension11);
this.gridDashboardItem1.Columns.AddRange(new DevExpress.DashboardCommon.GridColumnBase[] {
gridDimensionColumn1,
gridDimensionColumn2,
gridDimensionColumn3,
gridDimensionColumn4,
gridDimensionColumn5,
gridDimensionColumn6,
gridDimensionColumn7,
gridDimensionColumn8
});
this.gridDashboardItem1.ComponentName = "gridDashboardItem1";
this.gridDashboardItem1.DataItemRepository.Clear();
this.gridDashboardItem1.DataItemRepository.Add(dimension4, "DataItem0");
this.gridDashboardItem1.DataItemRepository.Add(dimension5, "DataItem1");
this.gridDashboardItem1.DataItemRepository.Add(dimension6, "DataItem2");
this.gridDashboardItem1.DataItemRepository.Add(dimension7, "DataItem3");
this.gridDashboardItem1.DataItemRepository.Add(dimension8, "DataItem4");
this.gridDashboardItem1.DataItemRepository.Add(dimension9, "DataItem5");
this.gridDashboardItem1.DataItemRepository.Add(dimension10, "DataItem6");
this.gridDashboardItem1.DataItemRepository.Add(dimension11, "DataItem7");
this.gridDashboardItem1.DataMember = "Query";
this.gridDashboardItem1.DataSource = this.dashboardSqlDataSource1;
this.gridDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
this.gridDashboardItem1.Name = "Items assigned to users";
this.gridDashboardItem1.ShowCaption = true;
//
// treeViewDashboardItem1
//
this.treeViewDashboardItem1.ComponentName = "treeViewDashboardItem1";
dimension12.DataMember = "pro_name";
dimension12.GroupChildValues = true;
dimension13.DataMember = "Status";
dimension14.DataMember = "UserName";
dimension15.DataMember = "RC_ID";
this.treeViewDashboardItem1.DataItemRepository.Clear();
this.treeViewDashboardItem1.DataItemRepository.Add(dimension12, "DataItem1");
this.treeViewDashboardItem1.DataItemRepository.Add(dimension13, "DataItem2");
this.treeViewDashboardItem1.DataItemRepository.Add(dimension14, "DataItem3");
this.treeViewDashboardItem1.DataItemRepository.Add(dimension15, "DataItem4");
this.treeViewDashboardItem1.DataMember = "Query";
this.treeViewDashboardItem1.DataSource = this.dashboardSqlDataSource1;
this.treeViewDashboardItem1.FilterDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension12,
dimension13,
dimension14,
dimension15
});
this.treeViewDashboardItem1.InteractivityOptions.IgnoreMasterFilters = true;
this.treeViewDashboardItem1.Name = "Data Selector";
this.treeViewDashboardItem1.ShowCaption = true;
//
// dash_pro_workflow_allUsers
//
this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] {
this.dashboardSqlDataSource1
});
this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] {
this.pieDashboardItem1,
this.gaugeDashboardItem1,
this.gridDashboardItem1,
this.treeViewDashboardItem1
});
dashboardLayoutItem1.DashboardItem = this.pieDashboardItem1;
dashboardLayoutItem1.Weight = 27.477477477477478D;
dashboardLayoutItem2.DashboardItem = this.treeViewDashboardItem1;
dashboardLayoutItem2.Weight = 10.51051051051051D;
dashboardLayoutItem3.DashboardItem = this.gaugeDashboardItem1;
dashboardLayoutItem3.Weight = 62.012012012012015D;
dashboardLayoutGroup2.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
dashboardLayoutItem1,
dashboardLayoutItem2,
dashboardLayoutItem3
});
dashboardLayoutGroup2.DashboardItem = null;
dashboardLayoutGroup2.Weight = 50.060901339829478D;
dashboardLayoutItem4.DashboardItem = this.gridDashboardItem1;
dashboardLayoutItem4.Weight = 49.939098660170522D;
dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
dashboardLayoutGroup2,
dashboardLayoutItem4
});
dashboardLayoutGroup1.DashboardItem = null;
dashboardLayoutGroup1.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical;
this.LayoutRoot = dashboardLayoutGroup1;
this.Title.ImageUrl = "https://readycert.net/images/logo.png";
this.Title.ShowMasterFilterState = false;
this.Title.Text = "Project Workflow Dashboard";
this.CustomParameters += new DevExpress.DashboardCommon.CustomParametersEventHandler(this.dash_pro_workflow_allUsers_CustomParameters);
((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure1)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension3)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension4)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension5)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension6)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension7)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension8)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension9)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension10)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension11)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gridDashboardItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension12)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension13)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension14)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension15)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.treeViewDashboardItem1)).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()
{
DevExpress.DashboardCommon.Measure measure1 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Measure measure2 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Card card1 = new DevExpress.DashboardCommon.Card();
DevExpress.DashboardCommon.CardStretchedLayoutTemplate cardStretchedLayoutTemplate1 = new DevExpress.DashboardCommon.CardStretchedLayoutTemplate();
DevExpress.DashboardCommon.Dimension dimension1 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Dimension dimension2 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Measure measure3 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Measure measure4 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Dimension dimension3 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.ChartPane chartPane1 = new DevExpress.DashboardCommon.ChartPane();
DevExpress.DashboardCommon.SimpleSeries simpleSeries1 = new DevExpress.DashboardCommon.SimpleSeries();
DevExpress.DashboardCommon.SimpleSeries simpleSeries2 = new DevExpress.DashboardCommon.SimpleSeries();
DevExpress.DashboardCommon.ChartPane chartPane2 = new DevExpress.DashboardCommon.ChartPane();
DevExpress.DashboardCommon.Dimension dimension4 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Measure measure5 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Measure measure6 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Gauge gauge1 = new DevExpress.DashboardCommon.Gauge();
DevExpress.DashboardCommon.Measure measure7 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Measure measure8 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Gauge gauge2 = new DevExpress.DashboardCommon.Gauge();
DevExpress.DashboardCommon.Measure measure9 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Gauge gauge3 = new DevExpress.DashboardCommon.Gauge();
DevExpress.DashboardCommon.CalculatedField calculatedField1 = new DevExpress.DashboardCommon.CalculatedField();
DevExpress.DataAccess.ConnectionParameters.MsSqlConnectionParameters msSqlConnectionParameters1 = new DevExpress.DataAccess.ConnectionParameters.MsSqlConnectionParameters();
DevExpress.DataAccess.Sql.StoredProcQuery storedProcQuery1 = new DevExpress.DataAccess.Sql.StoredProcQuery();
DevExpress.DataAccess.Sql.QueryParameter queryParameter1 = new DevExpress.DataAccess.Sql.QueryParameter();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Dashboard_principal));
DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup1 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup2 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem1 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup3 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem2 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem3 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem4 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup4 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem5 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem6 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardParameter dashboardParameter1 = new DevExpress.DashboardCommon.DashboardParameter();
this.cardDashboardItem1 = new DevExpress.DashboardCommon.CardDashboardItem();
this.chartDashboardItem1 = new DevExpress.DashboardCommon.ChartDashboardItem();
this.listBoxDashboardItem1 = new DevExpress.DashboardCommon.ListBoxDashboardItem();
this.gaugeDashboardItem2 = new DevExpress.DashboardCommon.GaugeDashboardItem();
this.gaugeDashboardItem1 = new DevExpress.DashboardCommon.GaugeDashboardItem();
this.gaugeDashboardItem3 = new DevExpress.DashboardCommon.GaugeDashboardItem();
this.dashboardSqlDataSource1 = new DevExpress.DashboardCommon.DashboardSqlDataSource();
((System.ComponentModel.ISupportInitialize)(this.cardDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure4)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.listBoxDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension4)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure5)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure6)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure7)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure8)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure9)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// cardDashboardItem1
//
measure1.DataMember = "VALORPRESUPUESTADO";
measure1.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Number;
measure1.NumericFormat.IncludeGroupSeparator = true;
measure1.NumericFormat.Unit = DevExpress.DashboardCommon.DataItemNumericUnit.Ones;
measure2.DataMember = "VALOREJECUTADO";
measure2.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Number;
measure2.NumericFormat.IncludeGroupSeparator = true;
measure2.NumericFormat.Unit = DevExpress.DashboardCommon.DataItemNumericUnit.Ones;
card1.AbsoluteVariationNumericFormat.IncludeGroupSeparator = true;
card1.AbsoluteVariationNumericFormat.Unit = DevExpress.DashboardCommon.DataItemNumericUnit.Ones;
cardStretchedLayoutTemplate1.BottomValue1.DimensionIndex = 0;
cardStretchedLayoutTemplate1.BottomValue1.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.PercentVariation;
cardStretchedLayoutTemplate1.BottomValue1.Visible = true;
cardStretchedLayoutTemplate1.BottomValue2.DimensionIndex = 0;
cardStretchedLayoutTemplate1.BottomValue2.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.AbsoluteVariation;
cardStretchedLayoutTemplate1.BottomValue2.Visible = true;
cardStretchedLayoutTemplate1.DeltaIndicator.Visible = true;
cardStretchedLayoutTemplate1.MainValue.DimensionIndex = 0;
cardStretchedLayoutTemplate1.MainValue.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.Title;
cardStretchedLayoutTemplate1.MainValue.Visible = true;
cardStretchedLayoutTemplate1.Sparkline.Visible = true;
cardStretchedLayoutTemplate1.SubValue.DimensionIndex = 0;
cardStretchedLayoutTemplate1.SubValue.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.Subtitle;
cardStretchedLayoutTemplate1.SubValue.Visible = true;
cardStretchedLayoutTemplate1.TopValue.DimensionIndex = 0;
cardStretchedLayoutTemplate1.TopValue.ValueType = DevExpress.DashboardCommon.CardRowDataElementType.ActualValue;
cardStretchedLayoutTemplate1.TopValue.Visible = true;
card1.LayoutTemplate = cardStretchedLayoutTemplate1;
card1.SparklineOptions.ViewType = DevExpress.DashboardCommon.SparklineViewType.Area;
card1.AddDataItem("ActualValue", measure1);
card1.AddDataItem("TargetValue", measure2);
this.cardDashboardItem1.Cards.AddRange(new DevExpress.DashboardCommon.Card[] {
card1
});
this.cardDashboardItem1.ComponentName = "cardDashboardItem1";
dimension1.DataMember = "DESCRIPCION";
this.cardDashboardItem1.DataItemRepository.Clear();
this.cardDashboardItem1.DataItemRepository.Add(measure1, "DataItem2");
this.cardDashboardItem1.DataItemRepository.Add(measure2, "DataItem1");
this.cardDashboardItem1.DataItemRepository.Add(dimension1, "DataItem0");
this.cardDashboardItem1.DataMember = "SP_KPI_PRINCIPAL";
this.cardDashboardItem1.DataSource = this.dashboardSqlDataSource1;
this.cardDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
this.cardDashboardItem1.Name = "Desviación Acumulada por Item de Costo";
this.cardDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension1
});
this.cardDashboardItem1.ShowCaption = true;
//
// chartDashboardItem1
//
dimension2.DataMember = "PERIODO";
this.chartDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension2
});
this.chartDashboardItem1.AxisX.EnableZooming = true;
this.chartDashboardItem1.AxisX.TitleVisible = true;
this.chartDashboardItem1.ComponentName = "chartDashboardItem1";
measure3.DataMember = "VALOREJECUTADO";
measure3.Name = "Ejecutado";
measure3.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Number;
measure3.NumericFormat.IncludeGroupSeparator = true;
measure3.NumericFormat.Unit = DevExpress.DashboardCommon.DataItemNumericUnit.Ones;
measure4.DataMember = "VALORPRESUPUESTADO";
measure4.Name = "Presupuestado";
measure4.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Number;
measure4.NumericFormat.IncludeGroupSeparator = true;
measure4.NumericFormat.Unit = DevExpress.DashboardCommon.DataItemNumericUnit.Ones;
dimension3.DataMember = "DESCRIPCION";
dimension3.Name = "Item de Costo";
this.chartDashboardItem1.DataItemRepository.Clear();
this.chartDashboardItem1.DataItemRepository.Add(measure3, "DataItem1");
this.chartDashboardItem1.DataItemRepository.Add(measure4, "DataItem2");
this.chartDashboardItem1.DataItemRepository.Add(dimension2, "DataItem0");
this.chartDashboardItem1.DataItemRepository.Add(dimension3, "DataItem3");
this.chartDashboardItem1.DataMember = "SP_KPI_PRINCIPAL";
this.chartDashboardItem1.DataSource = this.dashboardSqlDataSource1;
this.chartDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
this.chartDashboardItem1.Legend.InsidePosition = DevExpress.DashboardCommon.ChartLegendInsidePosition.BottomRightVertical;
this.chartDashboardItem1.Legend.OutsidePosition = DevExpress.DashboardCommon.ChartLegendOutsidePosition.TopLeftHorizontal;
this.chartDashboardItem1.Name = "Resumen Desviación Mensual";
chartPane1.Name = "Panel 1";
chartPane1.PrimaryAxisY.AlwaysShowZeroLevel = true;
chartPane1.PrimaryAxisY.ShowGridLines = true;
chartPane1.PrimaryAxisY.TitleVisible = true;
chartPane1.SecondaryAxisY.AlwaysShowZeroLevel = true;
chartPane1.SecondaryAxisY.ShowGridLines = false;
chartPane1.SecondaryAxisY.TitleVisible = true;
simpleSeries1.SeriesType = DevExpress.DashboardCommon.SimpleSeriesType.Line;
simpleSeries1.AddDataItem("Value", measure3);
simpleSeries2.SeriesType = DevExpress.DashboardCommon.SimpleSeriesType.Line;
simpleSeries2.AddDataItem("Value", measure4);
chartPane1.Series.AddRange(new DevExpress.DashboardCommon.ChartSeries[] {
simpleSeries1,
simpleSeries2
});
chartPane2.Name = "Panel 2";
chartPane2.PrimaryAxisY.AlwaysShowZeroLevel = true;
chartPane2.PrimaryAxisY.ShowGridLines = true;
chartPane2.PrimaryAxisY.TitleVisible = true;
chartPane2.SecondaryAxisY.AlwaysShowZeroLevel = true;
chartPane2.SecondaryAxisY.ShowGridLines = false;
chartPane2.SecondaryAxisY.TitleVisible = true;
this.chartDashboardItem1.Panes.AddRange(new DevExpress.DashboardCommon.ChartPane[] {
chartPane1,
chartPane2
});
this.chartDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension3
});
this.chartDashboardItem1.ShowCaption = true;
//
// listBoxDashboardItem1
//
this.listBoxDashboardItem1.ComponentName = "listBoxDashboardItem1";
dimension4.DataMember = "DESCRIPCION";
this.listBoxDashboardItem1.DataItemRepository.Clear();
this.listBoxDashboardItem1.DataItemRepository.Add(dimension4, "DataItem0");
this.listBoxDashboardItem1.DataMember = "SP_KPI_PRINCIPAL";
this.listBoxDashboardItem1.DataSource = this.dashboardSqlDataSource1;
this.listBoxDashboardItem1.FilterDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension4
});
this.listBoxDashboardItem1.InteractivityOptions.IgnoreMasterFilters = true;
this.listBoxDashboardItem1.Name = "Item de Costo";
this.listBoxDashboardItem1.ShowCaption = true;
//
// gaugeDashboardItem2
//
this.gaugeDashboardItem2.ComponentName = "gaugeDashboardItem2";
measure5.DataMember = "PRESUPUESTOTOTAL";
measure5.SummaryType = DevExpress.DashboardCommon.SummaryType.Average;
measure6.DataMember = "VALOREJECUTADO";
this.gaugeDashboardItem2.DataItemRepository.Clear();
this.gaugeDashboardItem2.DataItemRepository.Add(measure5, "DataItem0");
this.gaugeDashboardItem2.DataItemRepository.Add(measure6, "DataItem1");
this.gaugeDashboardItem2.DataMember = "SP_KPI_PRINCIPAL";
this.gaugeDashboardItem2.DataSource = this.dashboardSqlDataSource1;
gauge1.DeltaOptions.ResultIndicationThresholdType = DevExpress.DashboardCommon.DeltaIndicationThresholdType.Absolute;
gauge1.Name = " Saldo";
gauge1.AddDataItem("ActualValue", measure5);
gauge1.AddDataItem("TargetValue", measure6);
this.gaugeDashboardItem2.Gauges.AddRange(new DevExpress.DashboardCommon.Gauge[] {
gauge1
});
this.gaugeDashboardItem2.InteractivityOptions.IgnoreMasterFilters = false;
this.gaugeDashboardItem2.Name = "Presupuesto Restante";
this.gaugeDashboardItem2.ShowCaption = true;
this.gaugeDashboardItem2.ViewType = DevExpress.DashboardCommon.GaugeViewType.CircularHalf;
//
// gaugeDashboardItem1
//
this.gaugeDashboardItem1.ComponentName = "gaugeDashboardItem1";
measure7.DataMember = "VALOREJECUTADO";
measure7.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Number;
measure7.NumericFormat.IncludeGroupSeparator = true;
measure7.NumericFormat.Unit = DevExpress.DashboardCommon.DataItemNumericUnit.Ones;
measure8.DataMember = "PRESUPUESTOTOTAL";
measure8.SummaryType = DevExpress.DashboardCommon.SummaryType.Average;
this.gaugeDashboardItem1.DataItemRepository.Clear();
this.gaugeDashboardItem1.DataItemRepository.Add(measure7, "DataItem1");
this.gaugeDashboardItem1.DataItemRepository.Add(measure8, "DataItem0");
this.gaugeDashboardItem1.DataMember = "SP_KPI_PRINCIPAL";
this.gaugeDashboardItem1.DataSource = this.dashboardSqlDataSource1;
gauge2.DeltaOptions.ValueType = DevExpress.DashboardCommon.DeltaValueType.ActualValue;
gauge2.Name = "Ejecutado";
gauge2.AddDataItem("ActualValue", measure7);
gauge2.AddDataItem("TargetValue", measure8);
this.gaugeDashboardItem1.Gauges.AddRange(new DevExpress.DashboardCommon.Gauge[] {
gauge2
});
this.gaugeDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
this.gaugeDashboardItem1.Name = "Presupuesto ejecutado";
this.gaugeDashboardItem1.ShowCaption = true;
this.gaugeDashboardItem1.ViewType = DevExpress.DashboardCommon.GaugeViewType.CircularHalf;
//
// gaugeDashboardItem3
//
this.gaugeDashboardItem3.ComponentName = "gaugeDashboardItem3";
measure9.DataMember = "porcentajedeejecucion";
measure9.Name = "Porcentaje de Ejecución";
measure9.NumericFormat.FormatType = DevExpress.DashboardCommon.DataItemNumericFormatType.Percent;
measure9.NumericFormat.IncludeGroupSeparator = true;
measure9.NumericFormat.Unit = DevExpress.DashboardCommon.DataItemNumericUnit.Ones;
this.gaugeDashboardItem3.DataItemRepository.Clear();
this.gaugeDashboardItem3.DataItemRepository.Add(measure9, "DataItem0");
this.gaugeDashboardItem3.DataMember = "SP_KPI_PRINCIPAL";
this.gaugeDashboardItem3.DataSource = this.dashboardSqlDataSource1;
gauge3.Maximum = 100D;
gauge3.Minimum = 0D;
gauge3.Name = " ";
gauge3.AddDataItem("TargetValue", measure9);
this.gaugeDashboardItem3.Gauges.AddRange(new DevExpress.DashboardCommon.Gauge[] {
gauge3
});
this.gaugeDashboardItem3.InteractivityOptions.IgnoreMasterFilters = false;
this.gaugeDashboardItem3.Name = "Porcentaje de Ejecución de Presupuesto";
this.gaugeDashboardItem3.ShowCaption = true;
this.gaugeDashboardItem3.ViewType = DevExpress.DashboardCommon.GaugeViewType.CircularHalf;
//
// dashboardSqlDataSource1
//
calculatedField1.DataMember = "SP_KPI_PRINCIPAL";
calculatedField1.Expression = "Sum([VALOREJECUTADO]) / (Avg([PRESUPUESTOTOTAL]) - Sum([VALOREJECUTADO]))";
calculatedField1.Name = "porcentajedeejecucion";
this.dashboardSqlDataSource1.CalculatedFields.AddRange(new DevExpress.DashboardCommon.CalculatedField[] {
calculatedField1
});
this.dashboardSqlDataSource1.ComponentName = "dashboardSqlDataSource1";
this.dashboardSqlDataSource1.ConnectionName = "localhost_PRESUPUESTO_Connection";
msSqlConnectionParameters1.AuthorizationType = DevExpress.DataAccess.ConnectionParameters.MsSqlAuthorizationType.SqlServer;
msSqlConnectionParameters1.DatabaseName = "PRESUPUESTO";
msSqlConnectionParameters1.ServerName = "181.176.187.68\\BDNISIRA";
this.dashboardSqlDataSource1.ConnectionParameters = msSqlConnectionParameters1;
this.dashboardSqlDataSource1.Name = "Origen de datos SQL 1";
storedProcQuery1.Name = "SP_KPI_PRINCIPAL";
queryParameter1.Name = "@IDMONEDA";
queryParameter1.Type = typeof(string);
queryParameter1.ValueInfo = "02";
storedProcQuery1.Parameters.Add(queryParameter1);
storedProcQuery1.StoredProcName = "SP_KPI_PRINCIPAL";
this.dashboardSqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
storedProcQuery1
});
this.dashboardSqlDataSource1.ResultSchemaSerializable = resources.GetString("dashboardSqlDataSource1.ResultSchemaSerializable");
//
// Dashboard2
//
this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] {
this.dashboardSqlDataSource1
});
this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] {
this.cardDashboardItem1,
this.chartDashboardItem1,
this.listBoxDashboardItem1,
this.gaugeDashboardItem2,
this.gaugeDashboardItem1,
this.gaugeDashboardItem3
});
dashboardLayoutItem1.DashboardItem = this.chartDashboardItem1;
dashboardLayoutItem1.Weight = 77.162629757785467D;
dashboardLayoutItem2.DashboardItem = this.gaugeDashboardItem3;
dashboardLayoutItem2.Weight = 35.379061371841154D;
dashboardLayoutItem3.DashboardItem = this.gaugeDashboardItem2;
dashboardLayoutItem3.Weight = 31.588447653429604D;
dashboardLayoutItem4.DashboardItem = this.gaugeDashboardItem1;
dashboardLayoutItem4.Weight = 33.032490974729242D;
dashboardLayoutGroup3.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
dashboardLayoutItem2,
dashboardLayoutItem3,
dashboardLayoutItem4
});
dashboardLayoutGroup3.DashboardItem = null;
dashboardLayoutGroup3.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical;
dashboardLayoutGroup3.Weight = 22.837370242214533D;
dashboardLayoutGroup2.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
dashboardLayoutItem1,
dashboardLayoutGroup3
});
dashboardLayoutGroup2.DashboardItem = null;
dashboardLayoutGroup2.Weight = 61.830357142857146D;
dashboardLayoutItem5.DashboardItem = this.cardDashboardItem1;
dashboardLayoutItem5.Weight = 77.162629757785467D;
dashboardLayoutItem6.DashboardItem = this.listBoxDashboardItem1;
dashboardLayoutItem6.Weight = 22.837370242214533D;
dashboardLayoutGroup4.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
dashboardLayoutItem5,
dashboardLayoutItem6
});
dashboardLayoutGroup4.DashboardItem = null;
dashboardLayoutGroup4.Weight = 38.169642857142854D;
dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
dashboardLayoutGroup2,
dashboardLayoutGroup4
});
dashboardLayoutGroup1.DashboardItem = null;
dashboardLayoutGroup1.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical;
this.LayoutRoot = dashboardLayoutGroup1;
dashboardParameter1.Name = "MONEDA";
dashboardParameter1.Type = typeof(string);
dashboardParameter1.Value = "";
this.Parameters.AddRange(new DevExpress.DashboardCommon.DashboardParameter[] {
dashboardParameter1
});
this.Title.Text = "Tablero de control";
((System.ComponentModel.ISupportInitialize)(measure1)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure2)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.cardDashboardItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure3)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure4)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension3)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.chartDashboardItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension4)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.listBoxDashboardItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure5)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure6)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem2)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure7)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure8)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure9)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem3)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dashboardSqlDataSource1)).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()
{
DevExpress.DashboardCommon.Dimension dimension1 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Measure measure1 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Dimension dimension2 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DataAccess.Sql.SelectQuery selectQuery1 = new DevExpress.DataAccess.Sql.SelectQuery();
DevExpress.DataAccess.Sql.Column column1 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression1 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Table table1 = new DevExpress.DataAccess.Sql.Table();
DevExpress.DataAccess.Sql.Column column2 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression2 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column3 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression3 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column4 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression4 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column5 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression5 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column6 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression6 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column7 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression7 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column8 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression8 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column9 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression9 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column10 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression10 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column11 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression11 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column12 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression12 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.Column column13 = new DevExpress.DataAccess.Sql.Column();
DevExpress.DataAccess.Sql.ColumnExpression columnExpression13 = new DevExpress.DataAccess.Sql.ColumnExpression();
DevExpress.DataAccess.Sql.QueryParameter queryParameter1 = new DevExpress.DataAccess.Sql.QueryParameter();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(dash_workflow));
DevExpress.DashboardCommon.Measure measure2 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Dimension dimension3 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Gauge gauge1 = new DevExpress.DashboardCommon.Gauge();
DevExpress.DashboardCommon.Dimension dimension4 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Dimension dimension5 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Dimension dimension6 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Measure measure3 = new DevExpress.DashboardCommon.Measure();
DevExpress.DashboardCommon.Dimension dimension7 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.Dimension dimension8 = new DevExpress.DashboardCommon.Dimension();
DevExpress.DashboardCommon.PivotItemFormatRule pivotItemFormatRule1 = new DevExpress.DashboardCommon.PivotItemFormatRule();
DevExpress.DashboardCommon.FormatConditionDateOccuring formatConditionDateOccuring1 = new DevExpress.DashboardCommon.FormatConditionDateOccuring();
DevExpress.DashboardCommon.IconSettings iconSettings1 = new DevExpress.DashboardCommon.IconSettings();
DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup1 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
DevExpress.DashboardCommon.DashboardLayoutGroup dashboardLayoutGroup2 = new DevExpress.DashboardCommon.DashboardLayoutGroup();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem1 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem2 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardLayoutItem dashboardLayoutItem3 = new DevExpress.DashboardCommon.DashboardLayoutItem();
DevExpress.DashboardCommon.DashboardParameter dashboardParameter1 = new DevExpress.DashboardCommon.DashboardParameter();
this.pieDashboardItem1 = new DevExpress.DashboardCommon.PieDashboardItem();
this.data_workflow = new DevExpress.DashboardCommon.DashboardSqlDataSource();
this.gaugeDashboardItem1 = new DevExpress.DashboardCommon.GaugeDashboardItem();
this.pivotDashboardItem1 = new DevExpress.DashboardCommon.PivotDashboardItem();
((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.data_workflow)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.pivotDashboardItem1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension4)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension5)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension6)).BeginInit();
((System.ComponentModel.ISupportInitialize)(measure3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension7)).BeginInit();
((System.ComponentModel.ISupportInitialize)(dimension8)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// pieDashboardItem1
//
dimension1.DataMember = "Status";
this.pieDashboardItem1.Arguments.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension1
});
this.pieDashboardItem1.ComponentName = "pieDashboardItem1";
measure1.DataMember = "AssignedTo";
measure1.SummaryType = DevExpress.DashboardCommon.SummaryType.CountDistinct;
dimension2.DataMember = "AssignedTo";
this.pieDashboardItem1.DataItemRepository.Clear();
this.pieDashboardItem1.DataItemRepository.Add(measure1, "DataItem0");
this.pieDashboardItem1.DataItemRepository.Add(dimension2, "DataItem2");
this.pieDashboardItem1.DataItemRepository.Add(dimension1, "DataItem1");
this.pieDashboardItem1.DataMember = "view_workflow_laststatus";
this.pieDashboardItem1.DataSource = this.data_workflow;
this.pieDashboardItem1.FilterString = "[DataItem1] <> \'Unassugned\'";
this.pieDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
this.pieDashboardItem1.LabelContentType = ((DevExpress.DashboardCommon.PieValueType)(((DevExpress.DashboardCommon.PieValueType.Argument | DevExpress.DashboardCommon.PieValueType.Percent)
| DevExpress.DashboardCommon.PieValueType.Value)));
this.pieDashboardItem1.Name = "Workflow Activities by Worker";
this.pieDashboardItem1.PieType = DevExpress.DashboardCommon.PieType.Donut;
this.pieDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension2
});
this.pieDashboardItem1.ShowCaption = true;
this.pieDashboardItem1.Values.AddRange(new DevExpress.DashboardCommon.Measure[] {
measure1
});
//
// data_workflow
//
this.data_workflow.ComponentName = "data_workflow";
this.data_workflow.ConnectionName = "DevDB";
this.data_workflow.Name = "CurrentWorkflow";
columnExpression1.ColumnName = "AssignedTo";
table1.MetaSerializable = "<Meta X=\"30\" Y=\"30\" Width=\"125\" Height=\"305\" />";
table1.Name = "view_workflow";
columnExpression1.Table = table1;
column1.Expression = columnExpression1;
columnExpression2.ColumnName = "AssignedBy";
columnExpression2.Table = table1;
column2.Expression = columnExpression2;
columnExpression3.ColumnName = "Project";
columnExpression3.Table = table1;
column3.Expression = columnExpression3;
columnExpression4.ColumnName = "ProjectColor";
columnExpression4.Table = table1;
column4.Expression = columnExpression4;
columnExpression5.ColumnName = "Status";
columnExpression5.Table = table1;
column5.Expression = columnExpression5;
columnExpression6.ColumnName = "StatusOrder";
columnExpression6.Table = table1;
column6.Expression = columnExpression6;
columnExpression7.ColumnName = "Comments";
columnExpression7.Table = table1;
column7.Expression = columnExpression7;
columnExpression8.ColumnName = "Manager";
columnExpression8.Table = table1;
column8.Expression = columnExpression8;
columnExpression9.ColumnName = "Worker";
columnExpression9.Table = table1;
column9.Expression = columnExpression9;
columnExpression10.ColumnName = "Date";
columnExpression10.Table = table1;
column10.Expression = columnExpression10;
columnExpression11.ColumnName = "DueDate";
columnExpression11.Table = table1;
column11.Expression = columnExpression11;
columnExpression12.ColumnName = "RC_ID";
columnExpression12.Table = table1;
column12.Expression = columnExpression12;
columnExpression13.ColumnName = "RC_NAME";
columnExpression13.Table = table1;
column13.Expression = columnExpression13;
selectQuery1.Columns.Add(column1);
selectQuery1.Columns.Add(column2);
selectQuery1.Columns.Add(column3);
selectQuery1.Columns.Add(column4);
selectQuery1.Columns.Add(column5);
selectQuery1.Columns.Add(column6);
selectQuery1.Columns.Add(column7);
selectQuery1.Columns.Add(column8);
selectQuery1.Columns.Add(column9);
selectQuery1.Columns.Add(column10);
selectQuery1.Columns.Add(column11);
selectQuery1.Columns.Add(column12);
selectQuery1.Columns.Add(column13);
selectQuery1.FilterString = "Contains([view_workflow.AssignedTo], ?UserEmail)";
selectQuery1.GroupFilterString = "";
selectQuery1.Name = "view_workflow_laststatus";
queryParameter1.Name = "UserEmail";
queryParameter1.Type = typeof(DevExpress.DataAccess.Expression);
queryParameter1.Value = new DevExpress.DataAccess.Expression("[Parameters.UserEmail]", typeof(string));
selectQuery1.Parameters.Add(queryParameter1);
selectQuery1.Tables.Add(table1);
this.data_workflow.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
selectQuery1
});
this.data_workflow.ResultSchemaSerializable = resources.GetString("data_workflow.ResultSchemaSerializable");
//
// gaugeDashboardItem1
//
this.gaugeDashboardItem1.ComponentName = "gaugeDashboardItem1";
measure2.DataMember = "Status";
measure2.Name = "Count of Workflow Items";
measure2.SummaryType = DevExpress.DashboardCommon.SummaryType.Count;
dimension3.DataMember = "DueDate";
dimension3.DateTimeGroupInterval = DevExpress.DashboardCommon.DateTimeGroupInterval.QuarterYear;
this.gaugeDashboardItem1.DataItemRepository.Clear();
this.gaugeDashboardItem1.DataItemRepository.Add(measure2, "DataItem0");
this.gaugeDashboardItem1.DataItemRepository.Add(dimension3, "DataItem1");
this.gaugeDashboardItem1.DataMember = "view_workflow_laststatus";
this.gaugeDashboardItem1.DataSource = this.data_workflow;
gauge1.AddDataItem("ActualValue", measure2);
this.gaugeDashboardItem1.Gauges.AddRange(new DevExpress.DashboardCommon.Gauge[] {
gauge1
});
this.gaugeDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
this.gaugeDashboardItem1.Name = "Count of Workflow Items per Quarter";
this.gaugeDashboardItem1.SeriesDimensions.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension3
});
this.gaugeDashboardItem1.ShowCaption = true;
//
// pivotDashboardItem1
//
dimension4.DataMember = "Project";
dimension5.DataMember = "Status";
this.pivotDashboardItem1.Columns.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension4,
dimension5
});
this.pivotDashboardItem1.ComponentName = "pivotDashboardItem1";
dimension6.DataMember = "AssignedTo";
measure3.DataMember = "AssignedTo";
measure3.SummaryType = DevExpress.DashboardCommon.SummaryType.Count;
dimension7.DataMember = "RC_ID";
dimension8.DataMember = "RC_NAME";
this.pivotDashboardItem1.DataItemRepository.Clear();
this.pivotDashboardItem1.DataItemRepository.Add(dimension6, "DataItem0");
this.pivotDashboardItem1.DataItemRepository.Add(measure3, "DataItem2");
this.pivotDashboardItem1.DataItemRepository.Add(dimension4, "DataItem1");
this.pivotDashboardItem1.DataItemRepository.Add(dimension7, "DataItem4");
this.pivotDashboardItem1.DataItemRepository.Add(dimension8, "DataItem3");
this.pivotDashboardItem1.DataItemRepository.Add(dimension5, "DataItem5");
this.pivotDashboardItem1.DataMember = "view_workflow_laststatus";
this.pivotDashboardItem1.DataSource = this.data_workflow;
this.pivotDashboardItem1.FilterString = "Not [DataItem5] In (\'Unassugned\')";
formatConditionDateOccuring1.DateType = ((DevExpress.XtraEditors.FilterDateType)(((((((DevExpress.XtraEditors.FilterDateType.Yesterday | DevExpress.XtraEditors.FilterDateType.EarlierThisWeek)
| DevExpress.XtraEditors.FilterDateType.LastWeek)
| DevExpress.XtraEditors.FilterDateType.EarlierThisMonth)
| DevExpress.XtraEditors.FilterDateType.EarlierThisYear)
| DevExpress.XtraEditors.FilterDateType.PriorThisYear)
| DevExpress.XtraEditors.FilterDateType.Beyond)));
iconSettings1.IconType = DevExpress.DashboardCommon.FormatConditionIconType.IndicatorRedFlag;
formatConditionDateOccuring1.StyleSettings = iconSettings1;
pivotItemFormatRule1.Condition = formatConditionDateOccuring1;
pivotItemFormatRule1.Enabled = false;
pivotItemFormatRule1.Name = "FormatRule 1";
this.pivotDashboardItem1.FormatRules.AddRange(new DevExpress.DashboardCommon.PivotItemFormatRule[] {
pivotItemFormatRule1
});
this.pivotDashboardItem1.InteractivityOptions.IgnoreMasterFilters = false;
this.pivotDashboardItem1.LayoutType = DevExpress.DashboardCommon.PivotLayoutType.Compact;
this.pivotDashboardItem1.Name = "Items assigned to you";
this.pivotDashboardItem1.Rows.AddRange(new DevExpress.DashboardCommon.Dimension[] {
dimension6,
dimension7,
dimension8
});
this.pivotDashboardItem1.ShowCaption = true;
this.pivotDashboardItem1.Values.AddRange(new DevExpress.DashboardCommon.Measure[] {
measure3
});
//
// dash_workflow
//
this.DataSources.AddRange(new DevExpress.DashboardCommon.IDashboardDataSource[] {
this.data_workflow
});
this.Items.AddRange(new DevExpress.DashboardCommon.DashboardItem[] {
this.pieDashboardItem1,
this.pivotDashboardItem1,
this.gaugeDashboardItem1
});
dashboardLayoutItem1.DashboardItem = this.pieDashboardItem1;
dashboardLayoutItem1.Weight = 49.957155098543275D;
dashboardLayoutItem2.DashboardItem = this.gaugeDashboardItem1;
dashboardLayoutItem2.Weight = 50.042844901456725D;
dashboardLayoutGroup2.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
dashboardLayoutItem1,
dashboardLayoutItem2
});
dashboardLayoutGroup2.DashboardItem = null;
dashboardLayoutGroup2.Weight = 49.92272024729521D;
dashboardLayoutItem3.DashboardItem = this.pivotDashboardItem1;
dashboardLayoutItem3.Weight = 50.07727975270479D;
dashboardLayoutGroup1.ChildNodes.AddRange(new DevExpress.DashboardCommon.DashboardLayoutNode[] {
dashboardLayoutGroup2,
dashboardLayoutItem3
});
dashboardLayoutGroup1.DashboardItem = null;
dashboardLayoutGroup1.Orientation = DevExpress.DashboardCommon.DashboardLayoutGroupOrientation.Vertical;
this.LayoutRoot = dashboardLayoutGroup1;
dashboardParameter1.Name = "UserEmail";
dashboardParameter1.Type = typeof(string);
dashboardParameter1.Value = "";
this.Parameters.AddRange(new DevExpress.DashboardCommon.DashboardParameter[] {
dashboardParameter1
});
this.Title.Text = "Dashboard";
this.Title.Visible = false;
((System.ComponentModel.ISupportInitialize)(dimension1)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure1)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.pieDashboardItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.data_workflow)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure2)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension3)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gaugeDashboardItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension4)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension5)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension6)).EndInit();
((System.ComponentModel.ISupportInitialize)(measure3)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension7)).EndInit();
((System.ComponentModel.ISupportInitialize)(dimension8)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.pivotDashboardItem1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
