public static void Generate(Telerik.ReportViewer.Html5.WebForms.ReportViewer rv, IEnumerable<object> data, string extension, SortDescriptorCollection sortDescriptors, GroupDescriptorCollection grpDescriptors)
{
Telerik.Reporting.Report report1 = new Telerik.Reporting.Report();
report1.DataSource = data;
string sortCol = "";
string sortDir = "";
//multi sort can be done by iterating through collection like for group
if (sortDescriptors.Count > 0)
{
ColumnSortDescriptor sd = sortDescriptors[0] as ColumnSortDescriptor;
sortCol = sd.Column.UniqueName;
sortDir = sd.SortDirection.ToString();
}
//Page Header Section
Telerik.Reporting.PageHeaderSection pageHeaderSection1 = new Telerik.Reporting.PageHeaderSection();
pageHeaderSection1.Height = new Telerik.Reporting.Drawing.Unit(0.3, Telerik.Reporting.Drawing.UnitType.Inch);
pageHeaderSection1.Style.BackgroundColor = Color.Gray;
Telerik.Reporting.TextBox txtHead = new Telerik.Reporting.TextBox();
txtHead.Value = "Title";
txtHead.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.2395832538604736D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.02083333395421505D, Telerik.Reporting.Drawing.UnitType.Inch));
txtHead.Name = "reportTitle";
txtHead.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(5.5603775978088379D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
pageHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { txtHead });
IEnumerator dataColl = data.GetEnumerator();
int count = 0;
int first = 0;
object obj = null;
while (dataColl.MoveNext())
{
if (first == 0)
{
obj = dataColl.Current;
foreach (PropertyInfo info in obj.GetType().GetProperties())
{
count++;
}
first++;
}
}
Telerik.Reporting.Drawing.Unit x = Telerik.Reporting.Drawing.Unit.Inch(0);
Telerik.Reporting.Drawing.Unit y = Telerik.Reporting.Drawing.Unit.Inch(0);
Telerik.Reporting.ReportItemBase[] headColumnList = new Telerik.Reporting.ReportItem[count];
Telerik.Reporting.ReportItemBase[] detailColumnList = new Telerik.Reporting.ReportItem[count];
Telerik.Reporting.Group group = new Telerik.Reporting.Group();
SizeU size = new SizeU(Telerik.Reporting.Drawing.Unit.Inch((double)(22) / count), Telerik.Reporting.Drawing.Unit.Inch(0.6));
int column = 0;
foreach (PropertyInfo info in obj.GetType().GetProperties())
{
string columnName = info.Name;
Telerik.Reporting.HtmlTextBox headerCol = CreateTxtHeader(columnName, column);
headerCol.Style.BackgroundColor = Color.LemonChiffon;
headerCol.Style.BorderStyle.Default = BorderType.Solid;
headerCol.Style.BorderWidth.Default = Unit.Pixel(1);
headerCol.CanGrow = true;
headerCol.Location = new Telerik.Reporting.Drawing.PointU(x, y);
headerCol.Size = size;
headColumnList[column] = headerCol;
Telerik.Reporting.TextBox textBox = CreateTxtDetail(columnName, column);
textBox.Style.BorderStyle.Default = BorderType.Solid;
textBox.Style.BorderWidth.Default = Unit.Pixel(1);
textBox.CanGrow = true;
textBox.Location = new Telerik.Reporting.Drawing.PointU(x, y);
textBox.Size = size;
detailColumnList[column] = textBox;
textBox.ItemDataBinding += new EventHandler(textBox_ItemDataBound);
x += Telerik.Reporting.Drawing.Unit.Inch(headerCol.Size.Width.Value);
column++;
}
Telerik.Reporting.ReportItemBase[] groupColumnList = new Telerik.Reporting.ReportItem[grpDescriptors.Count];
int i = grpDescriptors.Count;
if (grpDescriptors.Count > 0)
{
Telerik.Reporting.GroupHeaderSection groupHeaderSection1 = new Telerik.Reporting.GroupHeaderSection();
foreach (ColumnGroupDescriptor grpDescriptor in grpDescriptors)
{
string grpCol = grpDescriptor.Column.UniqueName;
group.Groupings.Add(new Grouping("=Fields." + grpCol));
if (grpDescriptor.SortDirection.ToString().ToLower() == "descending")
{
group.Sortings.Add(new Sorting("=Fields." + grpCol, SortDirection.Desc));
}
else
{
group.Sortings.Add(new Sorting("=Fields." + grpCol, SortDirection.Asc));
}
i--;
Telerik.Reporting.TextBox hdCol = new Telerik.Reporting.TextBox();
hdCol.Style.BackgroundColor = Color.Orange;
hdCol.Style.BorderStyle.Default = BorderType.Solid;
hdCol.Style.BorderWidth.Default = Unit.Pixel(1);
hdCol.KeepTogether = true;
hdCol.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(5.5603775978088379D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
hdCol.Value = "=[" + grpCol + "]";
groupColumnList[i] = hdCol;
group.GroupHeader = groupHeaderSection1;
//to avoid extra row after group col
group.GroupHeader.Height = Telerik.Reporting.Drawing.Unit.Inch(0);
}
groupHeaderSection1.Items.AddRange(groupColumnList);
}
if (sortCol.Length > 0)
{
group.Groupings.Add(new Grouping("=Fields." + sortCol));
if (sortDir.ToLower() == "descending")
{
group.Sortings.Add(new Sorting("=Fields." + sortCol, SortDirection.Desc));
}
else
{
group.Sortings.Add(new Sorting("=Fields." + sortCol, SortDirection.Asc));
}
}
ReportHeaderSection reportHeaderSection1 = new Telerik.Reporting.ReportHeaderSection();
reportHeaderSection1.Height = new Telerik.Reporting.Drawing.Unit(0.3, Telerik.Reporting.Drawing.UnitType.Inch);
reportHeaderSection1.Items.AddRange(headColumnList);
report1.Groups.Add(group);
//Detail Section
Telerik.Reporting.DetailSection detailSection1 = new Telerik.Reporting.DetailSection();
detailSection1.Height = new Telerik.Reporting.Drawing.Unit(0.3, Telerik.Reporting.Drawing.UnitType.Inch);
detailSection1.Items.AddRange(detailColumnList);
//Page Footer Section
Telerik.Reporting.PageFooterSection pageFooterSection1 = new Telerik.Reporting.PageFooterSection();
pageFooterSection1.Height = new Telerik.Reporting.Drawing.Unit(0.3, Telerik.Reporting.Drawing.UnitType.Inch);
pageFooterSection1.Style.BackgroundColor = Color.LightGray;
pageFooterSection1.PrintOnFirstPage = true;
pageFooterSection1.PrintOnLastPage = true;
Telerik.Reporting.TextBox txtFooter = new Telerik.Reporting.TextBox();
txtFooter.Value = "='Page ' + PageNumber + ' of ' + PageCount";
txtFooter.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.2395832538604736D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.02083333395421505D, Telerik.Reporting.Drawing.UnitType.Inch));
txtFooter.Name = "pageInfoTextBox";
txtFooter.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(5.5603775978088379D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
Telerik.Reporting.PictureBox picBoxFooter = new Telerik.Reporting.PictureBox();
picBoxFooter.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.2395832538604736D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.02083333395421505D, Telerik.Reporting.Drawing.UnitType.Inch));
picBoxFooter.Value = @"C:\CCMSGoldStandard_Local\CCMSGoldStandard\CCMSAppShell\Images\no.png";
picBoxFooter.Style.TextAlign = Telerik.Reporting.Drawing.
HorizontalAlign.Center;
picBoxFooter.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Inch))), new Telerik.Reporting.Drawing.Unit(.5D, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Inch))));
picBoxFooter.Sizing = ImageSizeMode.AutoSize;
pageFooterSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { txtFooter, picBoxFooter });
//add all section to report
report1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { pageHeaderSection1, reportHeaderSection1, detailSection1, pageFooterSection1 });
report1.PageSettings.Landscape = false;
report1.PageSettings.Margins.Bottom = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch);
report1.PageSettings.Margins.Left = new Telerik.Reporting.Drawing.Unit(.25, Telerik.Reporting.Drawing.UnitType.Inch);
report1.PageSettings.Margins.Right = new Telerik.Reporting.Drawing.Unit(.25, Telerik.Reporting.Drawing.UnitType.Inch);
report1.PageSettings.Margins.Top = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch);
Telerik.Reporting.Drawing.SizeU paperSize = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(22, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(22, Telerik.Reporting.Drawing.UnitType.Inch));
report1.PageSettings.PaperSize = paperSize;
report1.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Custom;
Hashtable deviceInfo = new Hashtable();
deviceInfo["FontEmbedding"] = "Subset";
if (extension.ToLower() == "csv")
{
deviceInfo["NoHeader"] = true;
deviceInfo["NoStaticText"] = true;
}
Telerik.Reporting.Processing.ReportProcessor RP = new Telerik.Reporting.Processing.ReportProcessor();
byte[] buffer = RP.RenderReport(extension.ToUpper(), report1, deviceInfo).DocumentBytes;
string myPath = "C:";
string file = myPath + @"\" + DateTime.Now.ToString("HHmmss") + "." + extension;
FileStream fs = new FileStream(file, FileMode.Create);
fs.Write(buffer, 0, buffer.Length);
fs.Flush();
fs.Close();
Process.Start(file);
}
/// <summary>
/// Required method for telerik Reporting designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
Telerik.Reporting.NavigateToReportAction navigateToReportAction1 = new Telerik.Reporting.NavigateToReportAction();
Telerik.Reporting.TypeReportSource typeReportSource1 = new Telerik.Reporting.TypeReportSource();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(EmployeeSalesSummary));
Telerik.Reporting.GraphGroup graphGroup1 = new Telerik.Reporting.GraphGroup();
Telerik.Reporting.Drawing.ColorPalette colorPalette1 = new Telerik.Reporting.Drawing.ColorPalette();
Telerik.Reporting.GraphTitle graphTitle1 = new Telerik.Reporting.GraphTitle();
Telerik.Reporting.CategoryScale categoryScale1 = new Telerik.Reporting.CategoryScale();
Telerik.Reporting.NumericalScale numericalScale1 = new Telerik.Reporting.NumericalScale();
Telerik.Reporting.GraphGroup graphGroup2 = new Telerik.Reporting.GraphGroup();
Telerik.Reporting.GraphGroup graphGroup3 = new Telerik.Reporting.GraphGroup();
Telerik.Reporting.Drawing.ColorPalette colorPalette2 = new Telerik.Reporting.Drawing.ColorPalette();
Telerik.Reporting.GraphTitle graphTitle2 = new Telerik.Reporting.GraphTitle();
Telerik.Reporting.CategoryScale categoryScale2 = new Telerik.Reporting.CategoryScale();
Telerik.Reporting.NumericalScale numericalScale2 = new Telerik.Reporting.NumericalScale();
Telerik.Reporting.Drawing.ColorPalette colorPalette3 = new Telerik.Reporting.Drawing.ColorPalette();
Telerik.Reporting.GraphGroup graphGroup4 = new Telerik.Reporting.GraphGroup();
Telerik.Reporting.TableGroup tableGroup1 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup2 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup3 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup4 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup5 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup6 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup7 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup8 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup9 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup10 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup11 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup12 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.Group group1 = new Telerik.Reporting.Group();
Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter();
Telerik.Reporting.ReportParameter reportParameter2 = new Telerik.Reporting.ReportParameter();
Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule2 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule3 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule4 = new Telerik.Reporting.Drawing.StyleRule();
this.textBoxTableTitle = new Telerik.Reporting.TextBox();
this.textBoxCategoryAmount = new Telerik.Reporting.TextBox();
this.textBoxCategory = new Telerik.Reporting.TextBox();
this.textBoxSalesOrderNumber = new Telerik.Reporting.TextBox();
this.textBoxOrderTotal = new Telerik.Reporting.TextBox();
this.textBox4 = new Telerik.Reporting.TextBox();
this.textBox12 = new Telerik.Reporting.TextBox();
this.textBoxEmployeeSalesTotal = new Telerik.Reporting.TextBox();
this.textBoxTotalLabel = new Telerik.Reporting.TextBox();
this.textBox10 = new Telerik.Reporting.TextBox();
this.groupFooterSection1 = new Telerik.Reporting.GroupFooterSection();
this.groupHeaderSection1 = new Telerik.Reporting.GroupHeaderSection();
this.textBoxLogo = new Telerik.Reporting.TextBox();
this.textBoxDataRange = new Telerik.Reporting.TextBox();
this.textBoxReportEmployee = new Telerik.Reporting.TextBox();
this.shape3 = new Telerik.Reporting.Shape();
this.Employees = new Telerik.Reporting.SqlDataSource();
this.detail = new Telerik.Reporting.DetailSection();
this.panelWrapper = new Telerik.Reporting.Panel();
this.graph1 = new Telerik.Reporting.Graph();
this.cartesianCoordinateSystem1 = new Telerik.Reporting.CartesianCoordinateSystem();
this.graphAxis2 = new Telerik.Reporting.GraphAxis();
this.graphAxis1 = new Telerik.Reporting.GraphAxis();
this.mainDataSource = new Telerik.Reporting.SqlDataSource();
this.lineSeries1 = new Telerik.Reporting.AreaSeries();
this.graph2 = new Telerik.Reporting.Graph();
this.cartesianCoordinateSystem3 = new Telerik.Reporting.CartesianCoordinateSystem();
this.graphAxis6 = new Telerik.Reporting.GraphAxis();
this.graphAxis5 = new Telerik.Reporting.GraphAxis();
this.barSeries1 = new Telerik.Reporting.BarSeries();
this.crosstabEmployeeSales = new Telerik.Reporting.Crosstab();
this.textBox6 = new Telerik.Reporting.TextBox();
this.textBox5 = new Telerik.Reporting.TextBox();
this.textBox9 = new Telerik.Reporting.TextBox();
this.textBox13 = new Telerik.Reporting.TextBox();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// textBoxTableTitle
//
this.textBoxTableTitle.Name = "textBoxTableTitle";
this.textBoxTableTitle.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0799999237060547D), Telerik.Reporting.Drawing.Unit.Inch(0.47999998927116394D));
this.textBoxTableTitle.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.textBoxTableTitle.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(16D);
this.textBoxTableTitle.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Inch(0.079999998211860657D);
this.textBoxTableTitle.Value = "{Parameters.ReportDate.Value.ToString(\"MMMM yyyy\")} Order Summary";
//
// textBoxCategoryAmount
//
this.textBoxCategoryAmount.Format = "{0:N2}";
this.textBoxCategoryAmount.Name = "textBoxCategoryAmount";
this.textBoxCategoryAmount.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.75D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D));
this.textBoxCategoryAmount.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBoxCategoryAmount.Value = "=Sum(Fields.LineTotal)";
//
// textBoxCategory
//
this.textBoxCategory.Name = "textBoxCategory";
this.textBoxCategory.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(5.130000114440918D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D));
this.textBoxCategory.Value = "=Fields.Category";
//
// textBoxSalesOrderNumber
//
typeReportSource1.Parameters.Add(new Telerik.Reporting.Parameter("OrderNumber", "=Fields.SalesOrderNumber"));
typeReportSource1.Parameters.Add(new Telerik.Reporting.Parameter("ForYear", "=Parameters.ReportDate.Value.Year"));
typeReportSource1.Parameters.Add(new Telerik.Reporting.Parameter("ForMonth", "=Parameters.ReportDate.Value.Month"));
typeReportSource1.TypeName = "Telerik.Reporting.Examples.CSharp.Invoice, CSharp.ReportLibrary, Version=1.0.0.0," +
" Culture=neutral, PublicKeyToken=null";
navigateToReportAction1.ReportSource = typeReportSource1;
this.textBoxSalesOrderNumber.Action = navigateToReportAction1;
this.textBoxSalesOrderNumber.Name = "textBoxSalesOrderNumber";
this.textBoxSalesOrderNumber.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2100000381469727D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D));
this.textBoxSalesOrderNumber.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(105)))), ((int)(((byte)(104)))));
this.textBoxSalesOrderNumber.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Inch(0.05000000074505806D);
this.textBoxSalesOrderNumber.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Top;
this.textBoxSalesOrderNumber.Value = "=Fields.SalesOrderNumber";
//
// textBoxOrderTotal
//
this.textBoxOrderTotal.Format = "{0:N2}";
this.textBoxOrderTotal.Name = "textBoxOrderTotal";
this.textBoxOrderTotal.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.75D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D));
this.textBoxOrderTotal.Style.BorderColor.Default = System.Drawing.Color.Black;
this.textBoxOrderTotal.Style.BorderColor.Top = System.Drawing.Color.FromArgb(((int)(((byte)(230)))), ((int)(((byte)(230)))), ((int)(((byte)(230)))));
this.textBoxOrderTotal.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.textBoxOrderTotal.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.textBoxOrderTotal.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBoxOrderTotal.Value = "=Sum(Fields.LineTotal)";
//
// textBox4
//
this.textBox4.Name = "textBox4";
this.textBox4.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(5.130000114440918D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D));
this.textBox4.Style.BorderColor.Default = System.Drawing.Color.Black;
this.textBox4.Style.BorderColor.Top = System.Drawing.Color.FromArgb(((int)(((byte)(230)))), ((int)(((byte)(230)))), ((int)(((byte)(230)))));
this.textBox4.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.textBox4.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
//
// textBox12
//
this.textBox12.Name = "textBox12";
this.textBox12.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2100000381469727D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D));
this.textBox12.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
//
// textBoxEmployeeSalesTotal
//
this.textBoxEmployeeSalesTotal.Format = "{0:N2}";
this.textBoxEmployeeSalesTotal.Name = "textBoxEmployeeSalesTotal";
this.textBoxEmployeeSalesTotal.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.75D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D));
this.textBoxEmployeeSalesTotal.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.textBoxEmployeeSalesTotal.Style.BorderWidth.Bottom = Telerik.Reporting.Drawing.Unit.Point(2D);
this.textBoxEmployeeSalesTotal.Style.Font.Bold = true;
this.textBoxEmployeeSalesTotal.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBoxEmployeeSalesTotal.Value = "=Sum(Fields.LineTotal)";
//
// textBoxTotalLabel
//
this.textBoxTotalLabel.Name = "textBoxTotalLabel";
this.textBoxTotalLabel.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(5.130000114440918D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D));
this.textBoxTotalLabel.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.textBoxTotalLabel.Style.BorderWidth.Bottom = Telerik.Reporting.Drawing.Unit.Point(2D);
this.textBoxTotalLabel.Value = "Total:";
//
// textBox10
//
this.textBox10.Name = "textBox10";
this.textBox10.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.2100000381469727D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D));
this.textBox10.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.textBox10.Style.BorderWidth.Bottom = Telerik.Reporting.Drawing.Unit.Point(2D);
//
// groupFooterSection1
//
this.groupFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.1272023469209671D);
this.groupFooterSection1.Name = "groupFooterSection1";
this.groupFooterSection1.Style.Visible = false;
//
// groupHeaderSection1
//
this.groupHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(1D);
this.groupHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBoxLogo,
this.textBoxDataRange,
this.textBoxReportEmployee,
this.shape3
});
this.groupHeaderSection1.Name = "groupHeaderSection1";
this.groupHeaderSection1.PrintOnEveryPage = true;
//
// textBoxLogo
//
this.textBoxLogo.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(3.9339065551757812E-05D));
this.textBoxLogo.Name = "textBoxLogo";
this.textBoxLogo.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1972219944000244D), Telerik.Reporting.Drawing.Unit.Inch(0.20000004768371582D));
this.textBoxLogo.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(195)))), ((int)(((byte)(47)))), ((int)(((byte)(11)))));
this.textBoxLogo.Style.Font.Bold = true;
this.textBoxLogo.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
this.textBoxLogo.Value = "SALES REPORT";
//
// textBoxDataRange
//
this.textBoxDataRange.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.6000003814697266D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.textBoxDataRange.Name = "textBoxDataRange";
this.textBoxDataRange.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.4999597072601318D), Telerik.Reporting.Drawing.Unit.Inch(0.19837446510791779D));
this.textBoxDataRange.Style.Font.Bold = true;
this.textBoxDataRange.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
this.textBoxDataRange.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBoxDataRange.Value = "=Parameters.ReportDate.Value.ToString(\'MMM yyyy\')";
//
// textBoxReportEmployee
//
this.textBoxReportEmployee.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.20011806488037109D));
this.textBoxReportEmployee.Name = "textBoxReportEmployee";
this.textBoxReportEmployee.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0999603271484375D), Telerik.Reporting.Drawing.Unit.Inch(0.60000002384185791D));
this.textBoxReportEmployee.StyleName = "Header";
this.textBoxReportEmployee.Value = "=Parameters.Employee.Label";
//
// shape3
//
this.shape3.Anchoring = ((Telerik.Reporting.AnchoringStyles)((Telerik.Reporting.AnchoringStyles.Left | Telerik.Reporting.AnchoringStyles.Right)));
this.shape3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.80019682645797729D));
this.shape3.Name = "shape3";
this.shape3.ShapeType = new Telerik.Reporting.Drawing.Shapes.LineShape(Telerik.Reporting.Drawing.Shapes.LineDirection.EW);
this.shape3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0999603271484375D), Telerik.Reporting.Drawing.Unit.Point(2D));
this.shape3.Stretch = true;
this.shape3.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.shape3.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.shape3.Style.BorderWidth.Bottom = Telerik.Reporting.Drawing.Unit.Point(0.5D);
this.shape3.Style.BorderWidth.Top = Telerik.Reporting.Drawing.Unit.Point(1.5D);
this.shape3.Style.Color = System.Drawing.Color.Transparent;
//
// Employees
//
this.Employees.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString";
this.Employees.Name = "Employees";
this.Employees.SelectCommand = resources.GetString("Employees.SelectCommand");
//
// detail
//
this.detail.Height = Telerik.Reporting.Drawing.Unit.Inch(6.8000006675720215D);
this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.panelWrapper
});
this.detail.KeepTogether = false;
this.detail.Name = "detail";
//
// panelWrapper
//
this.panelWrapper.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.graph1,
this.graph2,
this.crosstabEmployeeSales
});
this.panelWrapper.KeepTogether = false;
this.panelWrapper.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9378803194267675E-05D), Telerik.Reporting.Drawing.Unit.Inch(7.8678131103515625E-05D));
this.panelWrapper.Name = "panelWrapper";
this.panelWrapper.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.1000394821167D), Telerik.Reporting.Drawing.Unit.Inch(6.79992151260376D));
//
// graph1
//
graphGroup1.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.OrderDate.Month"));
graphGroup1.Label = "= Fields.OrderDate.ToString(\"MMMM\")";
graphGroup1.Name = "orderDate.MonthGroup1";
graphGroup1.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.OrderDate.Month", Telerik.Reporting.SortDirection.Asc));
this.graph1.CategoryGroups.Add(graphGroup1);
colorPalette1.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(247)))), ((int)(((byte)(150)))), ((int)(((byte)(70))))));
colorPalette1.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(75)))), ((int)(((byte)(172)))), ((int)(((byte)(198))))));
colorPalette1.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(100)))), ((int)(((byte)(162))))));
colorPalette1.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(182)))), ((int)(((byte)(87)))), ((int)(((byte)(8))))));
colorPalette1.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(39)))), ((int)(((byte)(106)))), ((int)(((byte)(124))))));
colorPalette1.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(77)))), ((int)(((byte)(59)))), ((int)(((byte)(98))))));
this.graph1.ColorPalette = colorPalette1;
this.graph1.CoordinateSystems.Add(this.cartesianCoordinateSystem1);
this.graph1.DataSource = this.mainDataSource;
this.graph1.Legend.Position = Telerik.Reporting.GraphItemPosition.RightCenter;
this.graph1.Legend.Style.LineColor = System.Drawing.Color.LightGray;
this.graph1.Legend.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D);
this.graph1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9458274841308594E-05D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.graph1.Name = "graph1";
this.graph1.PlotAreaStyle.LineColor = System.Drawing.Color.LightGray;
this.graph1.PlotAreaStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D);
this.graph1.Series.Add(this.lineSeries1);
this.graph1.SeriesGroups.Add(graphGroup2);
this.graph1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.1000003814697266D), Telerik.Reporting.Drawing.Unit.Inch(2.4000000953674316D));
this.graph1.Style.Font.Name = "Segoe UI";
this.graph1.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Pixel(10D);
this.graph1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Pixel(10D);
this.graph1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Pixel(10D);
this.graph1.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Pixel(10D);
graphTitle1.Position = Telerik.Reporting.GraphItemPosition.TopCenter;
graphTitle1.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(14D);
graphTitle1.Style.LineColor = System.Drawing.Color.LightGray;
graphTitle1.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D);
graphTitle1.Text = "Yearly Sales Comparison";
this.graph1.Titles.Add(graphTitle1);
//
// cartesianCoordinateSystem1
//
this.cartesianCoordinateSystem1.Name = "cartesianCoordinateSystem1";
this.cartesianCoordinateSystem1.XAxis = this.graphAxis2;
this.cartesianCoordinateSystem1.YAxis = this.graphAxis1;
//
// graphAxis2
//
this.graphAxis2.LabelAngle = -90;
this.graphAxis2.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
this.graphAxis2.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.graphAxis2.MajorGridLineStyle.Visible = true;
this.graphAxis2.MajorTickMarkDisplayType = Telerik.Reporting.GraphAxisTickMarkDisplayType.None;
this.graphAxis2.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
this.graphAxis2.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.graphAxis2.MinorGridLineStyle.Visible = false;
this.graphAxis2.Name = "graphAxis2";
this.graphAxis2.Scale = categoryScale1;
this.graphAxis2.Style.Font.Name = "Segoe UI";
this.graphAxis2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(8D);
this.graphAxis2.Style.Visible = true;
//
// graphAxis1
//
this.graphAxis1.LabelFormat = "{0:C0}K";
this.graphAxis1.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
this.graphAxis1.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.graphAxis1.MajorGridLineStyle.Visible = true;
this.graphAxis1.MajorTickMarkDisplayType = Telerik.Reporting.GraphAxisTickMarkDisplayType.None;
this.graphAxis1.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
this.graphAxis1.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.graphAxis1.MinorGridLineStyle.Visible = false;
this.graphAxis1.Name = "graphAxis1";
this.graphAxis1.Scale = numericalScale1;
this.graphAxis1.Style.Font.Name = "Segoe UI";
this.graphAxis1.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(8D);
this.graphAxis1.Style.Visible = true;
//
// mainDataSource
//
this.mainDataSource.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString";
this.mainDataSource.Name = "mainDataSource";
this.mainDataSource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
new Telerik.Reporting.SqlDataSourceParameter("@ReportYear", System.Data.DbType.String, null),
new Telerik.Reporting.SqlDataSourceParameter("@ReportMonth", System.Data.DbType.String, null),
new Telerik.Reporting.SqlDataSourceParameter("@EmployeeID", System.Data.DbType.Int32, "=Parameters.Employee.Value")
});
this.mainDataSource.SelectCommand = resources.GetString("mainDataSource.SelectCommand");
//
// lineSeries1
//
this.lineSeries1.AreaStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.lineSeries1.ArrangeMode = Telerik.Reporting.GraphSeriesArrangeMode.Stacked;
this.lineSeries1.CategoryGroup = graphGroup1;
this.lineSeries1.CoordinateSystem = this.cartesianCoordinateSystem1;
this.lineSeries1.DataPointLabel = "=Sum(Fields.LineTotal)";
this.lineSeries1.DataPointLabelStyle.Visible = false;
this.lineSeries1.DataPointStyle.Visible = false;
this.lineSeries1.LegendItem.Value = "=Fields.OrderDate.Year";
this.lineSeries1.MarkerSize = Telerik.Reporting.Drawing.Unit.Mm(2D);
this.lineSeries1.Name = "lineSeries1";
graphGroup2.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.OrderDate.Year"));
graphGroup2.Name = "orderDate.YearGroup1";
graphGroup2.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.OrderDate.Year", Telerik.Reporting.SortDirection.Asc));
this.lineSeries1.SeriesGroup = graphGroup2;
this.lineSeries1.Y = "=ISNULL(Sum(Fields.LineTotal), 0) / 1000.0";
//
// graph2
//
graphGroup3.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.Category"));
graphGroup3.Name = "categoryGroup1";
graphGroup3.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.Category", Telerik.Reporting.SortDirection.Asc));
this.graph2.CategoryGroups.Add(graphGroup3);
colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(247)))), ((int)(((byte)(150)))), ((int)(((byte)(70))))));
colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(75)))), ((int)(((byte)(172)))), ((int)(((byte)(198))))));
colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(100)))), ((int)(((byte)(162))))));
colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(182)))), ((int)(((byte)(87)))), ((int)(((byte)(8))))));
colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(39)))), ((int)(((byte)(106)))), ((int)(((byte)(124))))));
colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(77)))), ((int)(((byte)(59)))), ((int)(((byte)(98))))));
this.graph2.ColorPalette = colorPalette2;
this.graph2.CoordinateSystems.Add(this.cartesianCoordinateSystem3);
this.graph2.DataSource = this.mainDataSource;
this.graph2.Legend.IsInsidePlotArea = false;
this.graph2.Legend.Position = Telerik.Reporting.GraphItemPosition.RightCenter;
this.graph2.Legend.Style.Font.Name = "Segoe UI";
this.graph2.Legend.Style.LineColor = System.Drawing.Color.LightGray;
this.graph2.Legend.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D);
this.graph2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(2.5999214649200439D));
this.graph2.Name = "graph2";
this.graph2.PlotAreaStyle.LineColor = System.Drawing.Color.LightGray;
this.graph2.PlotAreaStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D);
this.graph2.Series.Add(this.barSeries1);
this.graph2.SeriesGroups.Add(graphGroup4);
this.graph2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.1000003814697266D), Telerik.Reporting.Drawing.Unit.Inch(2.4000000953674316D));
this.graph2.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Pixel(10D);
this.graph2.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Pixel(10D);
this.graph2.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Pixel(10D);
this.graph2.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Pixel(10D);
graphTitle2.Position = Telerik.Reporting.GraphItemPosition.TopCenter;
graphTitle2.Style.Font.Name = "Segoe UI";
graphTitle2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(14D);
graphTitle2.Style.LineColor = System.Drawing.Color.LightGray;
graphTitle2.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D);
graphTitle2.Text = "Category Sales Comparison";
this.graph2.Titles.Add(graphTitle2);
//
// cartesianCoordinateSystem3
//
this.cartesianCoordinateSystem3.Name = "cartesianCoordinateSystem3";
this.cartesianCoordinateSystem3.XAxis = this.graphAxis6;
this.cartesianCoordinateSystem3.YAxis = this.graphAxis5;
//
// graphAxis6
//
this.graphAxis6.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
this.graphAxis6.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.graphAxis6.MajorGridLineStyle.Visible = false;
this.graphAxis6.MajorTickMarkDisplayType = Telerik.Reporting.GraphAxisTickMarkDisplayType.None;
this.graphAxis6.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
this.graphAxis6.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.graphAxis6.MinorGridLineStyle.Visible = false;
this.graphAxis6.Name = "graphAxis6";
this.graphAxis6.Scale = categoryScale2;
this.graphAxis6.Style.Font.Name = "Segoe UI";
this.graphAxis6.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(8D);
//
// graphAxis5
//
this.graphAxis5.LabelFormat = "{0:C0}K";
this.graphAxis5.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
this.graphAxis5.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.graphAxis5.MajorTickMarkDisplayType = Telerik.Reporting.GraphAxisTickMarkDisplayType.None;
this.graphAxis5.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
this.graphAxis5.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.graphAxis5.MinorGridLineStyle.Visible = false;
this.graphAxis5.Name = "graphAxis5";
this.graphAxis5.Scale = numericalScale2;
this.graphAxis5.Style.Font.Name = "Segoe UI";
this.graphAxis5.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(8D);
//
// barSeries1
//
this.barSeries1.CategoryGroup = graphGroup3;
colorPalette3.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(247)))), ((int)(((byte)(150)))), ((int)(((byte)(70))))));
colorPalette3.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(75)))), ((int)(((byte)(172)))), ((int)(((byte)(198))))));
colorPalette3.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(100)))), ((int)(((byte)(162))))));
colorPalette3.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(182)))), ((int)(((byte)(87)))), ((int)(((byte)(8))))));
colorPalette3.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(39)))), ((int)(((byte)(106)))), ((int)(((byte)(124))))));
colorPalette3.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(77)))), ((int)(((byte)(59)))), ((int)(((byte)(98))))));
this.barSeries1.ColorPalette = colorPalette3;
this.barSeries1.CoordinateSystem = this.cartesianCoordinateSystem3;
this.barSeries1.DataPointLabel = "=Sum(Fields.LineTotal)";
this.barSeries1.DataPointLabelStyle.Visible = false;
this.barSeries1.DataPointStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D);
this.barSeries1.DataPointStyle.Visible = true;
this.barSeries1.LegendItem.Value = "=Fields.OrderDate.Year";
graphGroup4.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.OrderDate.Year"));
graphGroup4.Name = "orderDate.YearGroup2";
graphGroup4.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.OrderDate.Year", Telerik.Reporting.SortDirection.Asc));
this.barSeries1.SeriesGroup = graphGroup4;
this.barSeries1.Y = "=Sum(Fields.LineTotal) / 1000.0";
//
// crosstabEmployeeSales
//
this.crosstabEmployeeSales.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(0D)));
this.crosstabEmployeeSales.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(Telerik.Reporting.Drawing.Unit.Inch(0.48000001907348633D)));
this.crosstabEmployeeSales.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(Telerik.Reporting.Drawing.Unit.Inch(0.24000000953674316D)));
this.crosstabEmployeeSales.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(Telerik.Reporting.Drawing.Unit.Inch(0.24000000953674316D)));
this.crosstabEmployeeSales.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(Telerik.Reporting.Drawing.Unit.Inch(0.24000000953674316D)));
this.crosstabEmployeeSales.Body.SetCellContent(1, 0, this.textBox6);
this.crosstabEmployeeSales.Body.SetCellContent(0, 0, this.textBox5);
this.crosstabEmployeeSales.Body.SetCellContent(2, 0, this.textBox9);
this.crosstabEmployeeSales.Body.SetCellContent(3, 0, this.textBox13);
this.crosstabEmployeeSales.ColumnGroups.Add(tableGroup1);
this.crosstabEmployeeSales.DataSource = this.mainDataSource;
this.crosstabEmployeeSales.Filters.Add(new Telerik.Reporting.Filter("= Fields.OrderDate.Year", Telerik.Reporting.FilterOperator.Equal, "=Parameters.ReportDate.Value.Year"));
this.crosstabEmployeeSales.Filters.Add(new Telerik.Reporting.Filter("= Fields.OrderDate.Month", Telerik.Reporting.FilterOperator.Equal, "=Parameters.ReportDate.Value.Month"));
this.crosstabEmployeeSales.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBox6,
this.textBox5,
this.textBox9,
this.textBox13,
this.textBoxTableTitle,
this.textBoxSalesOrderNumber,
this.textBoxCategory,
this.textBoxCategoryAmount,
this.textBox12,
this.textBox4,
this.textBoxOrderTotal,
this.textBox10,
this.textBoxTotalLabel,
this.textBoxEmployeeSalesTotal
});
this.crosstabEmployeeSales.KeepTogether = false;
this.crosstabEmployeeSales.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(5.4999213218688965D));
this.crosstabEmployeeSales.Name = "crosstabEmployeeSales";
this.crosstabEmployeeSales.NoDataMessage = "= \"No Sales for \" + Parameters.ReportDate.Value.ToString(\"MMMM, yyyy\")";
this.crosstabEmployeeSales.NoDataStyle.Color = System.Drawing.Color.Red;
tableGroup2.Name = "RowGroup";
tableGroup2.ReportItem = this.textBoxTableTitle;
tableGroup2.Sortings.Add(new Telerik.Reporting.Sorting("1", Telerik.Reporting.SortDirection.Asc));
tableGroup6.Name = "Detail";
tableGroup6.ReportItem = this.textBoxCategoryAmount;
tableGroup5.ChildGroups.Add(tableGroup6);
tableGroup5.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.Category"));
tableGroup5.Name = "Category";
tableGroup5.ReportItem = this.textBoxCategory;
tableGroup5.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.Category", Telerik.Reporting.SortDirection.Asc));
tableGroup4.ChildGroups.Add(tableGroup5);
tableGroup4.Name = "Group6";
tableGroup4.ReportItem = this.textBoxSalesOrderNumber;
tableGroup9.Name = "Group2";
tableGroup9.ReportItem = this.textBoxOrderTotal;
tableGroup8.ChildGroups.Add(tableGroup9);
tableGroup8.Name = "Group1";
tableGroup8.ReportItem = this.textBox4;
tableGroup7.ChildGroups.Add(tableGroup8);
tableGroup7.Name = "Group7";
tableGroup7.ReportItem = this.textBox12;
tableGroup3.ChildGroups.Add(tableGroup4);
tableGroup3.ChildGroups.Add(tableGroup7);
tableGroup3.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.SalesOrderID"));
tableGroup3.Name = "SalesOrder";
tableGroup3.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.SalesOrderNumber", Telerik.Reporting.SortDirection.Asc));
tableGroup12.Name = "Group4";
tableGroup12.ReportItem = this.textBoxEmployeeSalesTotal;
tableGroup11.ChildGroups.Add(tableGroup12);
tableGroup11.Name = "Group5";
tableGroup11.ReportItem = this.textBoxTotalLabel;
tableGroup10.ChildGroups.Add(tableGroup11);
tableGroup10.Name = "Group3";
tableGroup10.ReportItem = this.textBox10;
this.crosstabEmployeeSales.RowGroups.Add(tableGroup2);
this.crosstabEmployeeSales.RowGroups.Add(tableGroup3);
this.crosstabEmployeeSales.RowGroups.Add(tableGroup10);
this.crosstabEmployeeSales.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.09000015258789D), Telerik.Reporting.Drawing.Unit.Inch(1.2000000476837158D));
this.crosstabEmployeeSales.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(137)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
//
// textBox6
//
this.textBox6.Name = "textBox6";
this.textBox6.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D));
//
// textBox5
//
this.textBox5.Name = "textBox5";
this.textBox5.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.47999998927116394D));
this.textBox5.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.None;
this.textBox5.Style.BorderStyle.Left = Telerik.Reporting.Drawing.BorderType.None;
//
// textBox9
//
this.textBox9.Name = "textBox9";
this.textBox9.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D));
//
// textBox13
//
this.textBox13.Name = "textBox13";
this.textBox13.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.23999999463558197D));
//
// EmployeeSalesSummary
//
group1.GroupFooter = this.groupFooterSection1;
group1.GroupHeader = this.groupHeaderSection1;
group1.Groupings.Add(new Telerik.Reporting.Grouping(""));
group1.Name = "group1";
this.Groups.AddRange(new Telerik.Reporting.Group[] {
group1
});
this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.groupHeaderSection1,
this.groupFooterSection1,
this.detail
});
this.Name = "EmployeeSalesSummary";
this.PageSettings.Landscape = false;
this.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D), Telerik.Reporting.Drawing.Unit.Inch(0.30000001192092896D), Telerik.Reporting.Drawing.Unit.Inch(0.40000000596046448D));
this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter;
reportParameter1.AutoRefresh = true;
reportParameter1.Name = "ReportDate";
reportParameter1.Text = "Report Date";
reportParameter1.Type = Telerik.Reporting.ReportParameterType.DateTime;
reportParameter1.Value = "=#2003-07-01#";
reportParameter1.Visible = true;
reportParameter2.AutoRefresh = true;
reportParameter2.AvailableValues.DataSource = this.Employees;
reportParameter2.AvailableValues.DisplayMember = "= Fields.Employee";
reportParameter2.AvailableValues.ValueMember = "= Fields.SalesPersonID";
reportParameter2.Name = "Employee";
reportParameter2.Text = "Employee";
reportParameter2.Type = Telerik.Reporting.ReportParameterType.Integer;
reportParameter2.Value = "=283";
reportParameter2.Visible = true;
this.ReportParameters.Add(reportParameter1);
this.ReportParameters.Add(reportParameter2);
styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextItemBase)),
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.HtmlTextBox))
});
styleRule1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(2D);
styleRule1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D);
styleRule2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("Header")
});
styleRule2.Style.Font.Bold = true;
styleRule2.Style.Font.Name = "Segoe UI Light";
styleRule2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(25D);
styleRule2.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D);
styleRule2.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Top;
styleRule3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("Category")
});
styleRule3.Style.Font.Name = "Segoe UI Light";
styleRule3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(16D);
styleRule3.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D);
styleRule3.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Top;
styleRule4.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextBox))
});
styleRule4.Style.Font.Name = "Segoe UI";
styleRule4.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Inch(0D);
styleRule4.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Bottom;
this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] {
styleRule1,
styleRule2,
styleRule3,
styleRule4
});
this.Width = Telerik.Reporting.Drawing.Unit.Inch(8.09999942779541D);
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
/// <summary>
/// Required method for telerik Reporting designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
Telerik.Reporting.Barcodes.Code128Encoder code128Encoder1 = new Telerik.Reporting.Barcodes.Code128Encoder();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Invoice));
Telerik.Reporting.TypeReportSource typeReportSource1 = new Telerik.Reporting.TypeReportSource();
Telerik.Reporting.Group group1 = new Telerik.Reporting.Group();
Telerik.Reporting.Drawing.TextWatermark textWatermark1 = new Telerik.Reporting.Drawing.TextWatermark();
Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter();
Telerik.Reporting.ReportParameter reportParameter2 = new Telerik.Reporting.ReportParameter();
Telerik.Reporting.ReportParameter reportParameter3 = new Telerik.Reporting.ReportParameter();
Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule2 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule3 = new Telerik.Reporting.Drawing.StyleRule();
this.groupFooterSection1 = new Telerik.Reporting.GroupFooterSection();
this.groupHeaderSection1 = new Telerik.Reporting.GroupHeaderSection();
this.panel5 = new Telerik.Reporting.Panel();
this.Text1 = new Telerik.Reporting.TextBox();
this.barcode2 = new Telerik.Reporting.Barcode();
this.pictureBox1 = new Telerik.Reporting.PictureBox();
this.textBox1 = new Telerik.Reporting.TextBox();
this.panel3 = new Telerik.Reporting.Panel();
this.Id1 = new Telerik.Reporting.TextBox();
this.Text8 = new Telerik.Reporting.TextBox();
this.Field6 = new Telerik.Reporting.TextBox();
this.shape3 = new Telerik.Reporting.Shape();
this.OrderNumbersDataSource = new Telerik.Reporting.SqlDataSource();
this.detail = new Telerik.Reporting.DetailSection();
this.panel4 = new Telerik.Reporting.Panel();
this.textBox14 = new Telerik.Reporting.TextBox();
this.textBox10 = new Telerik.Reporting.TextBox();
this.textBox9 = new Telerik.Reporting.TextBox();
this.textBox8 = new Telerik.Reporting.TextBox();
this.textBox6 = new Telerik.Reporting.TextBox();
this.textBox4 = new Telerik.Reporting.TextBox();
this.textBox12 = new Telerik.Reporting.TextBox();
this.textBox13 = new Telerik.Reporting.TextBox();
this.textBox11 = new Telerik.Reporting.TextBox();
this.textBox16 = new Telerik.Reporting.TextBox();
this.textBox17 = new Telerik.Reporting.TextBox();
this.textBox18 = new Telerik.Reporting.TextBox();
this.textBox19 = new Telerik.Reporting.TextBox();
this.textBox21 = new Telerik.Reporting.TextBox();
this.panel1 = new Telerik.Reporting.Panel();
this.textBox24 = new Telerik.Reporting.TextBox();
this.textBox23 = new Telerik.Reporting.TextBox();
this.textBox25 = new Telerik.Reporting.TextBox();
this.textBox26 = new Telerik.Reporting.TextBox();
this.textBox27 = new Telerik.Reporting.TextBox();
this.textBox30 = new Telerik.Reporting.TextBox();
this.textBox29 = new Telerik.Reporting.TextBox();
this.textBox28 = new Telerik.Reporting.TextBox();
this.textBox32 = new Telerik.Reporting.TextBox();
this.textBox31 = new Telerik.Reporting.TextBox();
this.panel2 = new Telerik.Reporting.Panel();
this.textBox7 = new Telerik.Reporting.TextBox();
this.textBox2 = new Telerik.Reporting.TextBox();
this.textBox3 = new Telerik.Reporting.TextBox();
this.subReport1 = new Telerik.Reporting.SubReport();
this.InvoicesDataSource = new Telerik.Reporting.SqlDataSource();
this.pageFooterSection1 = new Telerik.Reporting.PageFooterSection();
this.textBox5 = new Telerik.Reporting.TextBox();
this.textBox22 = new Telerik.Reporting.TextBox();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// groupFooterSection1
//
this.groupFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.23541705310344696D);
this.groupFooterSection1.Name = "groupFooterSection1";
this.groupFooterSection1.Style.Visible = false;
//
// groupHeaderSection1
//
this.groupHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(1.4500000476837158D);
this.groupHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.panel5
});
this.groupHeaderSection1.Name = "groupHeaderSection1";
//
// panel5
//
this.panel5.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.Text1,
this.barcode2,
this.pictureBox1,
this.textBox1,
this.panel3
});
this.panel5.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.010456085205078125D), Telerik.Reporting.Drawing.Unit.Inch(3.9339065551757812E-05D));
this.panel5.Name = "panel5";
this.panel5.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(20.547340393066406D), Telerik.Reporting.Drawing.Unit.Cm(3.668447732925415D));
//
// Text1
//
this.Text1.CanGrow = false;
this.Text1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(5.3865165710449219D), Telerik.Reporting.Drawing.Unit.Cm(0.73998814821243286D));
this.Text1.Name = "Text1";
this.Text1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(7.0666971206665039D), Telerik.Reporting.Drawing.Unit.Cm(1.3915178775787354D));
this.Text1.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
this.Text1.Value = "275 Grove St., Suite 2-400, Newton, MA 02466\r\nPhone: +1.888.365.2779\r\nFax: +1.617" +
".249.2116";
//
// barcode2
//
this.barcode2.Encoder = code128Encoder1;
this.barcode2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(15.098536491394043D), Telerik.Reporting.Drawing.Unit.Cm(0.00010012308484874666D));
this.barcode2.Name = "barcode2";
this.barcode2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(5.448702335357666D), Telerik.Reporting.Drawing.Unit.Cm(2.1811349391937256D));
this.barcode2.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.barcode2.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Bottom;
this.barcode2.Value = "=Fields.PurchaseOrderNumber";
//
// pictureBox1
//
this.pictureBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.pictureBox1.MimeType = "image/jpeg";
this.pictureBox1.Name = "pictureBox1";
this.pictureBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.8914073705673218D), Telerik.Reporting.Drawing.Unit.Inch(0.8587145209312439D));
this.pictureBox1.Value = ((object)(resources.GetObject("pictureBox1.Value")));
//
// textBox1
//
this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.1206760406494141D), Telerik.Reporting.Drawing.Unit.Inch(3.9378803194267675E-05D));
this.textBox1.Name = "textBox1";
this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.9106760025024414D), Telerik.Reporting.Drawing.Unit.Inch(0.29121589660644531D));
this.textBox1.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(195)))), ((int)(((byte)(47)))), ((int)(((byte)(11)))));
this.textBox1.Value = "AdventureWorks";
//
// panel3
//
this.panel3.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.Id1,
this.Text8,
this.Field6,
this.shape3
});
this.panel3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(0.93754321336746216D));
this.panel3.Name = "panel3";
this.panel3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0894250869750977D), Telerik.Reporting.Drawing.Unit.Inch(0.50285667181015015D));
//
// Id1
//
this.Id1.CanGrow = false;
this.Id1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0D), Telerik.Reporting.Drawing.Unit.Cm(0D));
this.Id1.Name = "Id1";
this.Id1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(10.239533424377441D), Telerik.Reporting.Drawing.Unit.Inch(0.44999998807907104D));
this.Id1.Style.BackgroundColor = System.Drawing.Color.Empty;
this.Id1.Style.BorderColor.Default = System.Drawing.Color.Black;
this.Id1.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.None;
this.Id1.StyleName = "Header";
this.Id1.Value = "Sales Order: {Fields.SalesOrderID}";
//
// Text8
//
this.Text8.CanGrow = false;
this.Text8.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(13.574539184570313D), Telerik.Reporting.Drawing.Unit.Cm(0D));
this.Text8.Name = "Text8";
this.Text8.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(1.5236968994140625D), Telerik.Reporting.Drawing.Unit.Inch(0.44999998807907104D));
this.Text8.Style.BackgroundColor = System.Drawing.Color.Empty;
this.Text8.Style.Visible = true;
this.Text8.StyleName = "Header";
this.Text8.Value = "Date:";
//
// Field6
//
this.Field6.CanGrow = false;
this.Field6.Format = "{0:d}";
this.Field6.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(15.133413314819336D), Telerik.Reporting.Drawing.Unit.Cm(0D));
this.Field6.Name = "Field6";
this.Field6.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(5.4136261940002441D), Telerik.Reporting.Drawing.Unit.Inch(0.44999998807907104D));
this.Field6.Style.BackgroundColor = System.Drawing.Color.Empty;
this.Field6.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.Field6.StyleName = "Header";
this.Field6.Value = "= Fields.OrderDate";
//
// shape3
//
this.shape3.Anchoring = ((Telerik.Reporting.AnchoringStyles)((Telerik.Reporting.AnchoringStyles.Left | Telerik.Reporting.AnchoringStyles.Right)));
this.shape3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.47507891058921814D));
this.shape3.Name = "shape3";
this.shape3.ShapeType = new Telerik.Reporting.Drawing.Shapes.LineShape(Telerik.Reporting.Drawing.Shapes.LineDirection.EW);
this.shape3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0893850326538086D), Telerik.Reporting.Drawing.Unit.Point(2D));
this.shape3.Stretch = true;
this.shape3.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.shape3.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.shape3.Style.BorderWidth.Bottom = Telerik.Reporting.Drawing.Unit.Point(0.5D);
this.shape3.Style.BorderWidth.Top = Telerik.Reporting.Drawing.Unit.Point(1.5D);
this.shape3.Style.Color = System.Drawing.Color.Transparent;
//
// OrderNumbersDataSource
//
this.OrderNumbersDataSource.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString";
this.OrderNumbersDataSource.Name = "OrderNumbers";
this.OrderNumbersDataSource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
new Telerik.Reporting.SqlDataSourceParameter("@ForYear", System.Data.DbType.String, "=Parameters.ForYear.Value"),
new Telerik.Reporting.SqlDataSourceParameter("@ForMonth", System.Data.DbType.String, "=Parameters.ForMonth.Value")
});
this.OrderNumbersDataSource.SelectCommand = resources.GetString("OrderNumbersDataSource.SelectCommand");
//
// detail
//
this.detail.Height = Telerik.Reporting.Drawing.Unit.Inch(3.2155463695526123D);
this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.panel4,
this.subReport1
});
this.detail.KeepTogether = false;
this.detail.Name = "detail";
//
// panel4
//
this.panel4.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBox14,
this.textBox10,
this.textBox9,
this.textBox8,
this.textBox6,
this.textBox4,
this.textBox12,
this.textBox13,
this.textBox11,
this.textBox16,
this.textBox17,
this.textBox18,
this.textBox19,
this.textBox21,
this.panel1,
this.panel2,
this.textBox2,
this.textBox3
});
this.panel4.KeepTogether = false;
this.panel4.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.panel4.Name = "panel4";
this.panel4.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0998811721801758D), Telerik.Reporting.Drawing.Unit.Inch(2.71911358833313D));
//
// textBox14
//
this.textBox14.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.8959121704101562D), Telerik.Reporting.Drawing.Unit.Inch(0.59330624341964722D));
this.textBox14.Name = "textBox14";
this.textBox14.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.7913684844970703D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
this.textBox14.Value = "=Fields.Store";
//
// textBox10
//
this.textBox10.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.010495503433048725D), Telerik.Reporting.Drawing.Unit.Inch(1.5699173212051392D));
this.textBox10.Name = "textBox10";
this.textBox10.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.2792060375213623D), Telerik.Reporting.Drawing.Unit.Inch(0.29374995827674866D));
this.textBox10.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(13D);
this.textBox10.Value = "=Fields.CustPhone";
//
// textBox9
//
this.textBox9.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.80837249755859375D));
this.textBox9.Name = "textBox9";
this.textBox9.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.9018634557724D), Telerik.Reporting.Drawing.Unit.Inch(0.2571415901184082D));
this.textBox9.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(13D);
this.textBox9.Value = "=Fields.CustFirstName + \" \" + Fields.CustLastName";
//
// textBox8
//
this.textBox8.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.010456085205078125D), Telerik.Reporting.Drawing.Unit.Inch(0.60829383134841919D));
this.textBox8.Name = "textBox8";
this.textBox8.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.72496062517166138D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
this.textBox8.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
this.textBox8.Value = "CONTACT:";
//
// textBox6
//
this.textBox6.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.8959121704101562D), Telerik.Reporting.Drawing.Unit.Inch(1.5699173212051392D));
this.textBox6.Name = "textBox6";
this.textBox6.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.7913684844970703D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
this.textBox6.Value = "=Fields.BillCountryRegion";
//
// textBox4
//
this.textBox4.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.8959121704101562D), Telerik.Reporting.Drawing.Unit.Inch(1.3698383569717407D));
this.textBox4.Name = "textBox4";
this.textBox4.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.7913684844970703D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
this.textBox4.Value = "=Fields.BillPostalCode + \" \" + Fields.BillCity";
//
// textBox12
//
this.textBox12.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.8959121704101562D), Telerik.Reporting.Drawing.Unit.Inch(1.1697593927383423D));
this.textBox12.Name = "textBox12";
this.textBox12.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.8776596784591675D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
this.textBox12.Value = "=IsNull(Fields.BillAddress2, \'No secondary Address\')";
//
// textBox13
//
this.textBox13.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.8959121704101562D), Telerik.Reporting.Drawing.Unit.Inch(0.9696807861328125D));
this.textBox13.Name = "textBox13";
this.textBox13.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.7913684844970703D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
this.textBox13.Value = "=Fields.BillAddress1";
//
// textBox11
//
this.textBox11.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(1.3698387145996094D));
this.textBox11.Name = "textBox11";
this.textBox11.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.72496062517166138D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
this.textBox11.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
this.textBox11.Value = "PHONE:";
//
// textBox16
//
this.textBox16.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9547619819641113D), Telerik.Reporting.Drawing.Unit.Inch(0.57831829786300659D));
this.textBox16.Name = "textBox16";
this.textBox16.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1450793743133545D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
this.textBox16.Value = "=Fields.Store";
//
// textBox17
//
this.textBox17.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9547619819641113D), Telerik.Reporting.Drawing.Unit.Inch(0.96968048810958862D));
this.textBox17.Name = "textBox17";
this.textBox17.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1450793743133545D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
this.textBox17.Value = "=Fields.ShipAddress1";
//
// textBox18
//
this.textBox18.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9547619819641113D), Telerik.Reporting.Drawing.Unit.Inch(1.1697593927383423D));
this.textBox18.Name = "textBox18";
this.textBox18.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1450793743133545D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
this.textBox18.Value = "=IsNull(Fields.ShipAddress2, \'No secondary Address\')";
//
// textBox19
//
this.textBox19.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9547619819641113D), Telerik.Reporting.Drawing.Unit.Inch(1.3698383569717407D));
this.textBox19.Name = "textBox19";
this.textBox19.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1450793743133545D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
this.textBox19.Value = "=Fields.ShipPostalCode + \" \" + Fields.ShipCity + \", \" + Fields.ShipStateProvince " +
"";
//
// textBox21
//
this.textBox21.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9547619819641113D), Telerik.Reporting.Drawing.Unit.Inch(1.5699173212051392D));
this.textBox21.Name = "textBox21";
this.textBox21.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1450793743133545D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
this.textBox21.Value = "=Fields.ShipCountryRegion";
//
// panel1
//
this.panel1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBox24,
this.textBox23,
this.textBox25,
this.textBox26,
this.textBox27,
this.textBox30,
this.textBox29,
this.textBox28,
this.textBox32,
this.textBox31
});
this.panel1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(2.0311710834503174D));
this.panel1.Name = "panel1";
this.panel1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0998411178588867D), Telerik.Reporting.Drawing.Unit.Inch(0.55303496122360229D));
//
// textBox24
//
this.textBox24.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
this.textBox24.Name = "textBox24";
this.textBox24.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.1395833492279053D), Telerik.Reporting.Drawing.Unit.Inch(0.3425000011920929D));
this.textBox24.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.textBox24.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.textBox24.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D);
this.textBox24.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
this.textBox24.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
this.textBox24.Value = "DATE:";
//
// textBox23
//
this.textBox23.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.1396621465682983D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
this.textBox23.Name = "textBox23";
this.textBox23.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.7561712265014648D), Telerik.Reporting.Drawing.Unit.Inch(0.3425000011920929D));
this.textBox23.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.textBox23.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.textBox23.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D);
this.textBox23.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
this.textBox23.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
this.textBox23.Value = "ORDER DATE:";
//
// textBox25
//
this.textBox25.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.8959121704101562D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
this.textBox25.Name = "textBox25";
this.textBox25.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.6796835660934448D), Telerik.Reporting.Drawing.Unit.Inch(0.3425000011920929D));
this.textBox25.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.textBox25.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.textBox25.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D);
this.textBox25.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
this.textBox25.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
this.textBox25.Value = "SALES PERSON:";
//
// textBox26
//
this.textBox26.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(4.5756745338439941D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
this.textBox26.Name = "textBox26";
this.textBox26.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.3790086507797241D), Telerik.Reporting.Drawing.Unit.Inch(0.3425000011920929D));
this.textBox26.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.textBox26.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.textBox26.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D);
this.textBox26.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
this.textBox26.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
this.textBox26.Value = "PURCHASE ORDER:";
//
// textBox27
//
this.textBox27.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9547619819641113D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
this.textBox27.Name = "textBox27";
this.textBox27.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1450793743133545D), Telerik.Reporting.Drawing.Unit.Inch(0.3425000011920929D));
this.textBox27.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.textBox27.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.textBox27.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D);
this.textBox27.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
this.textBox27.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox27.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
this.textBox27.Value = "SHIPMENT METHOD";
//
// textBox30
//
this.textBox30.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.8959121704101562D), Telerik.Reporting.Drawing.Unit.Inch(0.34261831641197205D));
this.textBox30.Name = "textBox30";
this.textBox30.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.6796832084655762D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
this.textBox30.Value = "=Fields.SalesFirstName + \" \" + Fields.SalesLastName";
//
// textBox29
//
this.textBox29.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(4.5756745338439941D), Telerik.Reporting.Drawing.Unit.Inch(0.34261831641197205D));
this.textBox29.Name = "textBox29";
this.textBox29.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.3790086507797241D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
this.textBox29.Value = "=Fields.PurchaseOrderNumber";
//
// textBox28
//
this.textBox28.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9547619819641113D), Telerik.Reporting.Drawing.Unit.Inch(0.34261831641197205D));
this.textBox28.Name = "textBox28";
this.textBox28.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1450397968292236D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
this.textBox28.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox28.Value = "=Fields.ShipMethod";
//
// textBox32
//
this.textBox32.Format = "{0:d}";
this.textBox32.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.1396620273590088D), Telerik.Reporting.Drawing.Unit.Inch(0.34261831641197205D));
this.textBox32.Name = "textBox32";
this.textBox32.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.7561712265014648D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
this.textBox32.Value = "=Fields.OrderDate";
//
// textBox31
//
this.textBox31.Format = "{0:d}";
this.textBox31.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9339065551757812E-05D), Telerik.Reporting.Drawing.Unit.Inch(0.34261831641197205D));
this.textBox31.Name = "textBox31";
this.textBox31.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.1395833492279053D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
this.textBox31.Value = "=Today()";
//
// panel2
//
this.panel2.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBox7
});
this.panel2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
this.panel2.Name = "panel2";
this.panel2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0998411178588867D), Telerik.Reporting.Drawing.Unit.Inch(0.45000001788139343D));
this.panel2.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.panel2.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D);
//
// textBox7
//
this.textBox7.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.textBox7.Name = "textBox7";
this.textBox7.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.9041273593902588D), Telerik.Reporting.Drawing.Unit.Inch(0.44999998807907104D));
this.textBox7.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
this.textBox7.StyleName = "Header";
this.textBox7.Value = "Customer Details";
//
// textBox2
//
this.textBox2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(2.1311321258544922D), Telerik.Reporting.Drawing.Unit.Inch(0.60829383134841919D));
this.textBox2.Name = "textBox2";
this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.66167718172073364D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
this.textBox2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
this.textBox2.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox2.Value = "ADDRESS:";
//
// textBox3
//
this.textBox3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.35480260848999D), Telerik.Reporting.Drawing.Unit.Inch(0.57831794023513794D));
this.textBox3.Name = "textBox3";
this.textBox3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.56537884473800659D), Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D));
this.textBox3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
this.textBox3.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox3.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Top;
this.textBox3.Value = "SHIP TO:";
//
// subReport1
//
this.subReport1.KeepTogether = false;
this.subReport1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.010495503433048725D), Telerik.Reporting.Drawing.Unit.Inch(2.865025520324707D));
this.subReport1.Name = "subReport1";
typeReportSource1.Parameters.Add(new Telerik.Reporting.Parameter("SaledOrderID", "=Fields.SalesOrderID"));
typeReportSource1.TypeName = "Telerik.Reporting.Examples.CSharp.SalesOrderDetails, CSharp.ReportLibrary, Versio" +
"n=1.0.0.0, Culture=neutral, PublicKeyToken=null";
this.subReport1.ReportSource = typeReportSource1;
this.subReport1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0893068313598633D), Telerik.Reporting.Drawing.Unit.Inch(0.27500006556510925D));
//
// InvoicesDataSource
//
this.InvoicesDataSource.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString";
this.InvoicesDataSource.Name = "Invoices";
this.InvoicesDataSource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
new Telerik.Reporting.SqlDataSourceParameter("@SalesOrderNumber", System.Data.DbType.String, "=Parameters.OrderNumber.Value")
});
this.InvoicesDataSource.SelectCommand = resources.GetString("InvoicesDataSource.SelectCommand");
//
// pageFooterSection1
//
this.pageFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.2291666716337204D);
this.pageFooterSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBox5,
this.textBox22
});
this.pageFooterSection1.Name = "pageFooterSection1";
this.pageFooterSection1.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
//
// textBox5
//
this.textBox5.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.textBox5.Name = "textBox5";
this.textBox5.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.8958332538604736D), Telerik.Reporting.Drawing.Unit.Inch(0.22912724316120148D));
this.textBox5.Value = "=PageExec(\"lineTotalDataTextBox\",Count(Fields.ProductNumber)) + \" products, \" + P" +
"ageExec(\"lineTotalDataTextBox\",Sum(Fields.OrderQty)) + \" items on page \" + Page" +
"Number";
//
// textBox22
//
this.textBox22.Format = "{0:C2}";
this.textBox22.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9685325622558594D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
this.textBox22.Name = "textBox22";
this.textBox22.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.1312694549560547D), Telerik.Reporting.Drawing.Unit.Inch(0.22908782958984375D));
this.textBox22.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox22.Value = "=PageExec(\"lineTotalDataTextBox\",sum(LineTotal))";
//
// Invoice
//
this.DataSource = this.InvoicesDataSource;
this.Filters.Add(new Telerik.Reporting.Filter("=Fields.SalesOrderNumber", Telerik.Reporting.FilterOperator.Equal, "=Parameters.OrderNumber.Value"));
group1.GroupFooter = this.groupFooterSection1;
group1.GroupHeader = this.groupHeaderSection1;
group1.Name = "group1";
this.Groups.AddRange(new Telerik.Reporting.Group[] {
group1
});
this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.groupHeaderSection1,
this.groupFooterSection1,
this.detail,
this.pageFooterSection1
});
this.Name = "Invoice";
this.PageSettings.Landscape = false;
this.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D), Telerik.Reporting.Drawing.Unit.Inch(0.30000001192092896D), Telerik.Reporting.Drawing.Unit.Inch(0.40000000596046448D));
this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter;
textWatermark1.Color = System.Drawing.Color.Black;
textWatermark1.Font.Bold = false;
textWatermark1.Font.Italic = false;
textWatermark1.Font.Name = "Tahoma";
textWatermark1.Font.Size = Telerik.Reporting.Drawing.Unit.Point(150D);
textWatermark1.Font.Strikeout = false;
textWatermark1.Font.Underline = false;
textWatermark1.Opacity = 0.02D;
textWatermark1.Orientation = Telerik.Reporting.Drawing.WatermarkOrientation.Diagonal;
textWatermark1.Position = Telerik.Reporting.Drawing.WatermarkPosition.Front;
textWatermark1.PrintOnFirstPage = true;
textWatermark1.PrintOnLastPage = true;
textWatermark1.Text = "Original";
this.PageSettings.Watermarks.Add(textWatermark1);
reportParameter1.AutoRefresh = true;
reportParameter1.AvailableValues.DataSource = this.OrderNumbersDataSource;
reportParameter1.AvailableValues.DisplayMember = "SalesOrderNumber";
reportParameter1.AvailableValues.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.SalesOrderNumber", Telerik.Reporting.SortDirection.Asc));
reportParameter1.AvailableValues.ValueMember = "SalesOrderNumber";
reportParameter1.Name = "OrderNumber";
reportParameter1.Text = "Order #";
reportParameter1.Value = "=First(Fields.SalesOrderNumber)";
reportParameter1.Visible = true;
reportParameter2.Name = "ForYear";
reportParameter2.Type = Telerik.Reporting.ReportParameterType.Integer;
reportParameter2.Value = "=2003";
reportParameter3.Name = "ForMonth";
reportParameter3.Type = Telerik.Reporting.ReportParameterType.Integer;
reportParameter3.Value = "=7";
this.ReportParameters.Add(reportParameter1);
this.ReportParameters.Add(reportParameter2);
this.ReportParameters.Add(reportParameter3);
this.Style.BackgroundColor = System.Drawing.Color.White;
styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextItemBase)),
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.HtmlTextBox))
});
styleRule1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(2D);
styleRule1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D);
styleRule2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextBox))
});
styleRule2.Style.Font.Name = "Segoe UI";
styleRule2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(10D);
styleRule3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("Header")
});
styleRule3.Style.Font.Bold = true;
styleRule3.Style.Font.Name = "Segoe UI Light";
styleRule3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(16D);
styleRule3.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D);
this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] {
styleRule1,
styleRule2,
styleRule3
});
this.Width = Telerik.Reporting.Drawing.Unit.Inch(8.09999942779541D);
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
/// <summary>
/// Required method for telerik Reporting designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
Telerik.Reporting.TableGroup tableGroup1 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup2 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup3 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup4 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup5 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup6 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup7 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup8 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.Drawing.FormattingRule formattingRule1 = new Telerik.Reporting.Drawing.FormattingRule();
Telerik.Reporting.Drawing.FormattingRule formattingRule2 = new Telerik.Reporting.Drawing.FormattingRule();
Telerik.Reporting.Drawing.FormattingRule formattingRule3 = new Telerik.Reporting.Drawing.FormattingRule();
Telerik.Reporting.Drawing.FormattingRule formattingRule4 = new Telerik.Reporting.Drawing.FormattingRule();
Telerik.Reporting.Drawing.FormattingRule formattingRule5 = new Telerik.Reporting.Drawing.FormattingRule();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ProductCatalog));
Telerik.Reporting.TocLevel tocLevel1 = new Telerik.Reporting.TocLevel();
Telerik.Reporting.TocLevel tocLevel2 = new Telerik.Reporting.TocLevel();
Telerik.Reporting.TocLevel tocLevel3 = new Telerik.Reporting.TocLevel();
Telerik.Reporting.Group group1 = new Telerik.Reporting.Group();
Telerik.Reporting.Group group2 = new Telerik.Reporting.Group();
Telerik.Reporting.Group group3 = new Telerik.Reporting.Group();
Telerik.Reporting.Drawing.TextWatermark textWatermark1 = new Telerik.Reporting.Drawing.TextWatermark();
Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter();
Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule2 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule3 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule4 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule5 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.DescendantSelector descendantSelector1 = new Telerik.Reporting.Drawing.DescendantSelector();
this.textBox5 = new Telerik.Reporting.TextBox();
this.textBox14 = new Telerik.Reporting.TextBox();
this.textBox15 = new Telerik.Reporting.TextBox();
this.textBox7 = new Telerik.Reporting.TextBox();
this.textBox9 = new Telerik.Reporting.TextBox();
this.textBox19 = new Telerik.Reporting.TextBox();
this.textBox21 = new Telerik.Reporting.TextBox();
this.groupFooterSection1 = new Telerik.Reporting.GroupFooterSection();
this.groupHeaderSection1 = new Telerik.Reporting.GroupHeaderSection();
this.textBoxProductCategoryLabel = new Telerik.Reporting.TextBox();
this.textBox3 = new Telerik.Reporting.TextBox();
this.shape3 = new Telerik.Reporting.Shape();
this.groupFooterSection2 = new Telerik.Reporting.GroupFooterSection();
this.groupHeaderSection2 = new Telerik.Reporting.GroupHeaderSection();
this.textBox4 = new Telerik.Reporting.TextBox();
this.groupFooterSection3 = new Telerik.Reporting.GroupFooterSection();
this.groupHeaderSection3 = new Telerik.Reporting.GroupHeaderSection();
this.panel3 = new Telerik.Reporting.Panel();
this.pictureBox1 = new Telerik.Reporting.PictureBox();
this.textBox1 = new Telerik.Reporting.TextBox();
this.table1 = new Telerik.Reporting.Table();
this.textBox16 = new Telerik.Reporting.TextBox();
this.textBox17 = new Telerik.Reporting.TextBox();
this.textBox8 = new Telerik.Reporting.TextBox();
this.textBox18 = new Telerik.Reporting.TextBox();
this.textBox20 = new Telerik.Reporting.TextBox();
this.textBox22 = new Telerik.Reporting.TextBox();
this.panel7 = new Telerik.Reporting.Panel();
this.shape1 = new Telerik.Reporting.Shape();
this.textBox10 = new Telerik.Reporting.TextBox();
this.textBox6 = new Telerik.Reporting.TextBox();
this.sqlDataSource2 = new Telerik.Reporting.SqlDataSource();
this.detailSection1 = new Telerik.Reporting.DetailSection();
this.sqlDataSource1 = new Telerik.Reporting.SqlDataSource();
this.tocSection1 = new Telerik.Reporting.TocSection();
this.pageHeaderSection1 = new Telerik.Reporting.PageHeaderSection();
this.textBox2 = new Telerik.Reporting.TextBox();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// textBox5
//
this.textBox5.Name = "textBox5";
this.textBox5.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.95442020893096924D), Telerik.Reporting.Drawing.Unit.Inch(0.27081868052482605D));
this.textBox5.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(177)))), ((int)(((byte)(161)))), ((int)(((byte)(82)))));
this.textBox5.Value = "Product No.";
//
// textBox14
//
this.textBox14.Name = "textBox14";
this.textBox14.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.2207286357879639D), Telerik.Reporting.Drawing.Unit.Cm(0.68787944316864014D));
this.textBox14.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(177)))), ((int)(((byte)(161)))), ((int)(((byte)(82)))));
this.textBox14.Value = "Product";
//
// textBox15
//
this.textBox15.Name = "textBox15";
this.textBox15.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.0693451166152954D), Telerik.Reporting.Drawing.Unit.Cm(0.68787944316864014D));
this.textBox15.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(177)))), ((int)(((byte)(161)))), ((int)(((byte)(82)))));
this.textBox15.Value = "Color";
//
// textBox7
//
this.textBox7.Name = "textBox7";
this.textBox7.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.63820755481719971D), Telerik.Reporting.Drawing.Unit.Cm(0.68787944316864014D));
this.textBox7.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(177)))), ((int)(((byte)(161)))), ((int)(((byte)(82)))));
this.textBox7.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox7.Value = "Size";
//
// textBox9
//
this.textBox9.Name = "textBox9";
this.textBox9.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.63375592231750488D), Telerik.Reporting.Drawing.Unit.Cm(0.68787944316864014D));
this.textBox9.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(177)))), ((int)(((byte)(161)))), ((int)(((byte)(82)))));
this.textBox9.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox9.Value = "Weight";
//
// textBox19
//
this.textBox19.Name = "textBox19";
this.textBox19.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.0724959373474121D), Telerik.Reporting.Drawing.Unit.Cm(0.68787944316864014D));
this.textBox19.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(177)))), ((int)(((byte)(161)))), ((int)(((byte)(82)))));
this.textBox19.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox19.Value = "Dealer";
//
// textBox21
//
this.textBox21.Name = "textBox21";
this.textBox21.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.1005908250808716D), Telerik.Reporting.Drawing.Unit.Cm(0.68787944316864014D));
this.textBox21.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
this.textBox21.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(177)))), ((int)(((byte)(161)))), ((int)(((byte)(82)))));
this.textBox21.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox21.Value = "List Price";
//
// groupFooterSection1
//
this.groupFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.21875D);
this.groupFooterSection1.Name = "groupFooterSection1";
this.groupFooterSection1.Style.Visible = false;
//
// groupHeaderSection1
//
this.groupHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(1.5D);
this.groupHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBoxProductCategoryLabel,
this.textBox3,
this.shape3
});
this.groupHeaderSection1.Name = "groupHeaderSection1";
this.groupHeaderSection1.PrintOnEveryPage = true;
//
// textBoxProductCategoryLabel
//
this.textBoxProductCategoryLabel.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(0.90000009536743164D));
this.textBoxProductCategoryLabel.Name = "textBoxProductCategoryLabel";
this.textBoxProductCategoryLabel.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0999212265014648D), Telerik.Reporting.Drawing.Unit.Inch(0.3999999463558197D));
this.textBoxProductCategoryLabel.StyleName = "Category";
this.textBoxProductCategoryLabel.Value = "=Fields.ProductCategory";
//
// textBox3
//
this.textBox3.Culture = new System.Globalization.CultureInfo("en");
this.textBox3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(3.9339065551757812E-05D));
this.textBox3.Name = "textBox3";
this.textBox3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0999603271484375D), Telerik.Reporting.Drawing.Unit.Inch(0.60000002384185791D));
this.textBox3.StyleName = "Header";
this.textBox3.Value = "Product Catalog";
//
// shape3
//
this.shape3.Anchoring = ((Telerik.Reporting.AnchoringStyles)((Telerik.Reporting.AnchoringStyles.Left | Telerik.Reporting.AnchoringStyles.Right)));
this.shape3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.60011798143386841D));
this.shape3.Name = "shape3";
this.shape3.ShapeType = new Telerik.Reporting.Drawing.Shapes.LineShape(Telerik.Reporting.Drawing.Shapes.LineDirection.EW);
this.shape3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0999603271484375D), Telerik.Reporting.Drawing.Unit.Point(2D));
this.shape3.Stretch = true;
this.shape3.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.shape3.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.shape3.Style.BorderWidth.Bottom = Telerik.Reporting.Drawing.Unit.Point(0.5D);
this.shape3.Style.BorderWidth.Top = Telerik.Reporting.Drawing.Unit.Point(1.5D);
this.shape3.Style.Color = System.Drawing.Color.Transparent;
//
// groupFooterSection2
//
this.groupFooterSection2.Height = Telerik.Reporting.Drawing.Unit.Inch(0.1979166716337204D);
this.groupFooterSection2.Name = "groupFooterSection2";
this.groupFooterSection2.Style.Visible = false;
//
// groupHeaderSection2
//
this.groupHeaderSection2.Height = Telerik.Reporting.Drawing.Unit.Inch(0.40000000596046448D);
this.groupHeaderSection2.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBox4
});
this.groupHeaderSection2.KeepTogether = false;
this.groupHeaderSection2.Name = "groupHeaderSection2";
this.groupHeaderSection2.PrintOnEveryPage = true;
//
// textBox4
//
this.textBox4.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.textBox4.Name = "textBox4";
this.textBox4.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0999603271484375D), Telerik.Reporting.Drawing.Unit.Inch(0.30000010132789612D));
this.textBox4.StyleName = "SubCategory";
this.textBox4.Value = "=Fields.ProductSubCategory";
//
// groupFooterSection3
//
this.groupFooterSection3.Height = Telerik.Reporting.Drawing.Unit.Inch(0.14999993145465851D);
this.groupFooterSection3.Name = "groupFooterSection3";
//
// groupHeaderSection3
//
this.groupHeaderSection3.Height = Telerik.Reporting.Drawing.Unit.Inch(1.5000003576278687D);
this.groupHeaderSection3.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.panel3
});
this.groupHeaderSection3.Name = "groupHeaderSection3";
this.groupHeaderSection3.PrintOnEveryPage = true;
//
// panel3
//
this.panel3.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.pictureBox1,
this.textBox1,
this.table1,
this.textBox6
});
this.panel3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.19999949634075165D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.panel3.Name = "panel3";
this.panel3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(7.7000007629394531D), Telerik.Reporting.Drawing.Unit.Inch(1.4530587196350098D));
//
// pictureBox1
//
this.pictureBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
this.pictureBox1.MimeType = "";
this.pictureBox1.Name = "pictureBox1";
this.pictureBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.3372377157211304D), Telerik.Reporting.Drawing.Unit.Inch(0.89988160133361816D));
this.pictureBox1.Sizing = Telerik.Reporting.Drawing.ImageSizeMode.ScaleProportional;
this.pictureBox1.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.pictureBox1.Style.Color = System.Drawing.Color.White;
this.pictureBox1.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.pictureBox1.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Point(1D);
this.pictureBox1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(1D);
this.pictureBox1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(1D);
this.pictureBox1.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Point(1D);
this.pictureBox1.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.pictureBox1.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
this.pictureBox1.Value = "=Fields.LargePhoto";
//
// textBox1
//
this.textBox1.Bindings.Add(new Telerik.Reporting.Binding("Style.Font.Name", "= IIf(Parameters.CultureID.Value = \'zh-cht\', \'Microsoft JhengHei\', IIf(Paramet" +
"ers.CultureID.Value = \'th\', \'Microsoft Sans Serif\', \'Segoe UI Light\'))"));
this.textBox1.CanShrink = true;
this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(4.2445292472839355D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
this.textBox1.Name = "textBox1";
this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(3.2999608516693115D), Telerik.Reporting.Drawing.Unit.Inch(0.89988160133361816D));
this.textBox1.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.None;
this.textBox1.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
this.textBox1.Style.Font.Name = "Segoe UI Light";
this.textBox1.Value = "=Fields.Description";
//
// table1
//
this.table1.Bindings.Add(new Telerik.Reporting.Binding("DataSource", "=ReportItem.DataObject"));
this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(0.95442020893096924D)));
this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(2.220726490020752D)));
this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(1.0693440437316895D)));
this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(0.63820689916610718D)));
this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(0.63375532627105713D)));
this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(1.072495698928833D)));
this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(1.1005908250808716D)));
this.table1.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(Telerik.Reporting.Drawing.Unit.Cm(0.716888964176178D)));
this.table1.Body.SetCellContent(0, 0, this.textBox16);
this.table1.Body.SetCellContent(0, 1, this.textBox17);
this.table1.Body.SetCellContent(0, 3, this.textBox8);
this.table1.Body.SetCellContent(0, 4, this.textBox18);
this.table1.Body.SetCellContent(0, 5, this.textBox20);
this.table1.Body.SetCellContent(0, 6, this.textBox22);
this.table1.Body.SetCellContent(0, 2, this.panel7);
tableGroup1.Name = "tableGroup1";
tableGroup1.ReportItem = this.textBox5;
tableGroup2.Name = "tableGroup2";
tableGroup2.ReportItem = this.textBox14;
tableGroup3.Name = "tableGroup3";
tableGroup3.ReportItem = this.textBox15;
tableGroup4.Name = "tableGroup4";
tableGroup4.ReportItem = this.textBox7;
tableGroup5.Name = "tableGroup5";
tableGroup5.ReportItem = this.textBox9;
tableGroup6.Name = "tableGroup6";
tableGroup6.ReportItem = this.textBox19;
tableGroup7.Name = "tableGroup7";
tableGroup7.ReportItem = this.textBox21;
this.table1.ColumnGroups.Add(tableGroup1);
this.table1.ColumnGroups.Add(tableGroup2);
this.table1.ColumnGroups.Add(tableGroup3);
this.table1.ColumnGroups.Add(tableGroup4);
this.table1.ColumnGroups.Add(tableGroup5);
this.table1.ColumnGroups.Add(tableGroup6);
this.table1.ColumnGroups.Add(tableGroup7);
this.table1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBox16,
this.textBox17,
this.panel7,
this.textBox8,
this.textBox18,
this.textBox20,
this.textBox22,
this.textBox5,
this.textBox14,
this.textBox15,
this.textBox7,
this.textBox9,
this.textBox19,
this.textBox21
});
this.table1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(9.987076191464439E-05D), Telerik.Reporting.Drawing.Unit.Cm(2.2860004901885986D));
this.table1.Name = "table1";
tableGroup8.Groupings.Add(new Telerik.Reporting.Grouping(""));
tableGroup8.Name = "detailGroup";
this.table1.RowGroups.Add(tableGroup8);
this.table1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(7.6895394325256348D), Telerik.Reporting.Drawing.Unit.Cm(1.4047684669494629D));
//
// textBox16
//
this.textBox16.Name = "textBox16";
this.textBox16.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.95442020893096924D), Telerik.Reporting.Drawing.Unit.Cm(0.716888964176178D));
this.textBox16.Value = "=Fields.ProductNumber";
//
// textBox17
//
this.textBox17.Name = "textBox17";
this.textBox17.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.220726490020752D), Telerik.Reporting.Drawing.Unit.Cm(0.716888964176178D));
this.textBox17.Value = "=Fields.ProductName";
//
// textBox8
//
this.textBox8.Name = "textBox8";
this.textBox8.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.63820689916610718D), Telerik.Reporting.Drawing.Unit.Cm(0.716888964176178D));
this.textBox8.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox8.Value = "=IsNull(Fields.Size, \'N/A\')";
//
// textBox18
//
this.textBox18.Name = "textBox18";
this.textBox18.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.63375532627105713D), Telerik.Reporting.Drawing.Unit.Cm(0.716888964176178D));
this.textBox18.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox18.Value = "=IsNull(Fields.Weight, \'N/A\')";
//
// textBox20
//
this.textBox20.Format = "{0:C2}";
this.textBox20.Name = "textBox20";
this.textBox20.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.072495698928833D), Telerik.Reporting.Drawing.Unit.Cm(0.716888964176178D));
this.textBox20.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox20.Value = "=ISNULL(Fields.StandardCost, \"Call\")";
//
// textBox22
//
this.textBox22.Format = "{0:C2}";
this.textBox22.Name = "textBox22";
this.textBox22.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.1005908250808716D), Telerik.Reporting.Drawing.Unit.Cm(0.716888964176178D));
this.textBox22.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
this.textBox22.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox22.Value = "=IsNull(Fields.ListPrice, \'Call\')";
//
// panel7
//
this.panel7.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.shape1,
this.textBox10
});
this.panel7.Name = "panel7";
this.panel7.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.0693440437316895D), Telerik.Reporting.Drawing.Unit.Cm(0.716888964176178D));
this.panel7.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(230)))), ((int)(((byte)(230)))), ((int)(((byte)(230)))));
this.panel7.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.panel7.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.Solid;
this.panel7.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.panel7.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
//
// shape1
//
formattingRule1.Filters.Add(new Telerik.Reporting.Filter("= ToLower(Fields.Color)", Telerik.Reporting.FilterOperator.Equal, "red"));
formattingRule1.StopIfTrue = true;
formattingRule1.Style.BackgroundColor = System.Drawing.Color.Red;
formattingRule2.Filters.Add(new Telerik.Reporting.Filter("= ToLower(Fields.Color)", Telerik.Reporting.FilterOperator.Equal, "blue"));
formattingRule2.StopIfTrue = true;
formattingRule2.Style.BackgroundColor = System.Drawing.Color.Blue;
formattingRule3.Filters.Add(new Telerik.Reporting.Filter("= ToLower(Fields.Color)", Telerik.Reporting.FilterOperator.Equal, "black"));
formattingRule3.StopIfTrue = true;
formattingRule3.Style.BackgroundColor = System.Drawing.Color.Black;
formattingRule4.Filters.Add(new Telerik.Reporting.Filter("= ToLower(Fields.Color)", Telerik.Reporting.FilterOperator.Equal, "yellow"));
formattingRule4.StopIfTrue = true;
formattingRule4.Style.BackgroundColor = System.Drawing.Color.Yellow;
formattingRule5.Filters.Add(new Telerik.Reporting.Filter("= ToLower(Fields.Color)", Telerik.Reporting.FilterOperator.Equal, "silver"));
formattingRule5.StopIfTrue = true;
formattingRule5.Style.BackgroundColor = System.Drawing.Color.Silver;
this.shape1.ConditionalFormatting.AddRange(new Telerik.Reporting.Drawing.FormattingRule[] {
formattingRule1,
formattingRule2,
formattingRule3,
formattingRule4,
formattingRule5
});
this.shape1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0.0793650820851326D), Telerik.Reporting.Drawing.Unit.Cm(0.07025589793920517D));
this.shape1.Name = "shape1";
this.shape1.ShapeType = new Telerik.Reporting.Drawing.Shapes.EllipseShape(0D);
this.shape1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.26041331887245178D), Telerik.Reporting.Drawing.Unit.Inch(0.22303469479084015D));
this.shape1.Style.Color = System.Drawing.Color.Transparent;
//
// textBox10
//
this.textBox10.Format = "{0:C2}";
this.textBox10.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0.8202979564666748D), Telerik.Reporting.Drawing.Unit.Cm(0.07025589793920517D));
this.textBox10.Name = "textBox10";
this.textBox10.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(1.6804002523422241D), Telerik.Reporting.Drawing.Unit.Inch(0.25454029440879822D));
this.textBox10.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.None;
this.textBox10.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
this.textBox10.Value = "= IsNull(Fields.Color, \'N/A\')";
//
// textBox6
//
this.textBox6.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.4648761749267578D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.textBox6.Name = "textBox6";
this.textBox6.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.0351245403289795D), Telerik.Reporting.Drawing.Unit.Inch(0.30000028014183044D));
this.textBox6.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.None;
this.textBox6.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
this.textBox6.StyleName = "SubCategory";
this.textBox6.Value = "=Fields.ProductModel";
//
// sqlDataSource2
//
this.sqlDataSource2.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString";
this.sqlDataSource2.Name = "sqlDataSource2";
this.sqlDataSource2.SelectCommand = "SELECT RTRIM(CultureID) AS CultureID, Name FROM Production.Culture WHERE (NOT (RT" +
"RIM(CultureID) IN (\'es\', \'\')))";
//
// detailSection1
//
this.detailSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.13208325207233429D);
this.detailSection1.Name = "detailSection1";
this.detailSection1.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(137)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
this.detailSection1.Style.BorderWidth.Left = Telerik.Reporting.Drawing.Unit.Point(3D);
this.detailSection1.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(8D);
this.detailSection1.Style.Visible = false;
//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString";
this.sqlDataSource1.Name = "sqlDataSource1";
this.sqlDataSource1.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
new Telerik.Reporting.SqlDataSourceParameter("@cultureID", System.Data.DbType.String, "=Parameters(\'CultureID\').Value")
});
this.sqlDataSource1.SelectCommand = resources.GetString("sqlDataSource1.SelectCommand");
//
// tocSection1
//
this.tocSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(1.5D);
this.tocSection1.KeepTogether = false;
tocLevel1.LeaderSymbol = '\0';
tocLevel1.Name = "Level1";
tocLevel1.Style.Font.Bold = true;
tocLevel1.Style.Font.Name = "Segoe UI Light";
tocLevel1.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(16D);
tocLevel1.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Point(5D);
tocLevel1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(2D);
tocLevel1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D);
tocLevel1.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Point(5D);
tocLevel2.Name = "Level2";
tocLevel2.Style.Font.Name = "Segoe UI Light";
tocLevel2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(13D);
tocLevel2.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Point(1D);
tocLevel2.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(32D);
tocLevel2.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D);
tocLevel2.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Point(1D);
tocLevel3.Name = "Level3";
tocLevel3.Style.Font.Name = "Segoe UI Light";
tocLevel3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(13D);
tocLevel3.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Point(1D);
tocLevel3.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(52D);
tocLevel3.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D);
tocLevel3.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Point(1D);
this.tocSection1.Levels.Add(tocLevel1);
this.tocSection1.Levels.Add(tocLevel2);
this.tocSection1.Levels.Add(tocLevel3);
this.tocSection1.Name = "tocSection1";
this.tocSection1.PageBreak = Telerik.Reporting.PageBreak.After;
this.tocSection1.Title = "Table of Contents";
this.tocSection1.TitleStyle.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.tocSection1.TitleStyle.BorderWidth.Bottom = Telerik.Reporting.Drawing.Unit.Point(2D);
this.tocSection1.TitleStyle.Font.Bold = true;
this.tocSection1.TitleStyle.Font.Name = "Segoe UI Light";
this.tocSection1.TitleStyle.Font.Size = Telerik.Reporting.Drawing.Unit.Point(25D);
this.tocSection1.TitleStyle.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Point(10D);
//
// pageHeaderSection1
//
this.pageHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.19999997317790985D);
this.pageHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBox2
});
this.pageHeaderSection1.Name = "pageHeaderSection1";
//
// textBox2
//
this.textBox2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(4.2000002861022949D), Telerik.Reporting.Drawing.Unit.Inch(3.9339065551757812E-05D));
this.textBox2.Name = "textBox2";
this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(3.8999993801116943D), Telerik.Reporting.Drawing.Unit.Inch(0.19996063411235809D));
this.textBox2.Style.Font.Name = "Segoe UI Light";
this.textBox2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(10D);
this.textBox2.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox2.Value = "= PageExec(\'group1\', Fields.ProductCategory) + \', page \' + PageNumber(\'group1\', F" +
"ields.ProductCategory) + \' of \' + PageCount(\'group1\', Fields.ProductCategory)";
//
// ProductCatalog
//
this.Bindings.Add(new Telerik.Reporting.Binding("Culture", "=Parameters.CultureID.Value"));
this.DataSource = this.sqlDataSource1;
this.DocumentName = "=\'ProductCatalog.\' + Parameters.CultureID.Value";
group1.DocumentMapText = "=Fields.ProductCategory";
group1.GroupFooter = this.groupFooterSection1;
group1.GroupHeader = this.groupHeaderSection1;
group1.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.ProductCategory"));
group1.GroupKeepTogether = Telerik.Reporting.GroupKeepTogether.All;
group1.Name = "group1";
group1.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.ProductCategory", Telerik.Reporting.SortDirection.Asc));
group1.TocText = "=Fields.ProductCategory";
group2.DocumentMapText = "=Fields.ProductSubCategory";
group2.GroupFooter = this.groupFooterSection2;
group2.GroupHeader = this.groupHeaderSection2;
group2.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.ProductSubCategory"));
group2.GroupKeepTogether = Telerik.Reporting.GroupKeepTogether.FirstDetail;
group2.Name = "group2";
group2.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.ProductSubCategory", Telerik.Reporting.SortDirection.Asc));
group2.TocText = "=Fields.ProductSubCategory";
group3.DocumentMapText = "=Fields.ProductModel";
group3.GroupFooter = this.groupFooterSection3;
group3.GroupHeader = this.groupHeaderSection3;
group3.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.ProductModel"));
group3.GroupKeepTogether = Telerik.Reporting.GroupKeepTogether.FirstDetail;
group3.Name = "group3";
group3.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.ProductModel", Telerik.Reporting.SortDirection.Asc));
this.Groups.AddRange(new Telerik.Reporting.Group[] {
group1,
group2,
group3
});
this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.groupHeaderSection1,
this.groupFooterSection1,
this.groupHeaderSection2,
this.groupFooterSection2,
this.groupHeaderSection3,
this.groupFooterSection3,
this.detailSection1,
this.tocSection1,
this.pageHeaderSection1
});
this.Name = "ProductCatalog";
this.PageSettings.Landscape = false;
this.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D), Telerik.Reporting.Drawing.Unit.Inch(0.30000001192092896D), Telerik.Reporting.Drawing.Unit.Inch(0.40000000596046448D));
this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter;
textWatermark1.Color = System.Drawing.Color.FromArgb(((int)(((byte)(137)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
textWatermark1.Font.Name = "Tahoma";
textWatermark1.Font.Size = Telerik.Reporting.Drawing.Unit.Point(100D);
textWatermark1.Opacity = 0.06D;
textWatermark1.Orientation = Telerik.Reporting.Drawing.WatermarkOrientation.Vertical;
textWatermark1.Position = Telerik.Reporting.Drawing.WatermarkPosition.Front;
textWatermark1.Text = "=PageExec(\"textBoxProductCategoryLabel\", First(Fields.ProductCategory))";
this.PageSettings.Watermarks.Add(textWatermark1);
reportParameter1.AutoRefresh = true;
reportParameter1.AvailableValues.DataSource = this.sqlDataSource2;
reportParameter1.AvailableValues.DisplayMember = "Name";
reportParameter1.AvailableValues.ValueMember = "CultureID";
reportParameter1.Name = "CultureID";
reportParameter1.Text = "Language";
reportParameter1.Value = "en";
reportParameter1.Visible = true;
this.ReportParameters.Add(reportParameter1);
styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextItemBase)),
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.HtmlTextBox))
});
styleRule1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(2D);
styleRule1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D);
styleRule2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("Header")
});
styleRule2.Style.Font.Bold = true;
styleRule2.Style.Font.Name = "Segoe UI Light";
styleRule2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(25D);
styleRule2.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D);
styleRule3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("Category")
});
styleRule3.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(25)))), ((int)(((byte)(7)))), ((int)(((byte)(5)))));
styleRule3.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
styleRule3.Style.BorderWidth.Bottom = Telerik.Reporting.Drawing.Unit.Point(1D);
styleRule3.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D);
styleRule3.Style.Font.Name = "Segoe UI Light";
styleRule3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(16D);
styleRule3.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D);
styleRule4.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("SubCategory")
});
styleRule4.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
styleRule4.Style.BorderWidth.Bottom = Telerik.Reporting.Drawing.Unit.Point(0.5D);
styleRule4.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D);
styleRule4.Style.Font.Name = "Segoe UI Light";
styleRule4.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(13D);
styleRule4.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D);
descendantSelector1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.GroupHeaderSection)),
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.Panel)),
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextBox))
});
styleRule5.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
descendantSelector1
});
styleRule5.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(230)))), ((int)(((byte)(230)))), ((int)(((byte)(230)))));
styleRule5.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
styleRule5.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.Solid;
styleRule5.Style.Font.Name = "Segoe UI";
styleRule5.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(10D);
styleRule5.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Inch(0.039999999105930328D);
styleRule5.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0.05000000074505806D);
styleRule5.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Inch(0.05000000074505806D);
styleRule5.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Bottom;
this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] {
styleRule1,
styleRule2,
styleRule3,
styleRule4,
styleRule5
});
this.TocText = "Product Catalog";
this.Width = Telerik.Reporting.Drawing.Unit.Inch(8.09999942779541D);
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
/// <summary>
/// Required method for telerik Reporting designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ProductLineSales));
Telerik.Reporting.GraphGroup graphGroup1 = new Telerik.Reporting.GraphGroup();
Telerik.Reporting.Drawing.ColorPalette colorPalette1 = new Telerik.Reporting.Drawing.ColorPalette();
Telerik.Reporting.GraphTitle graphTitle1 = new Telerik.Reporting.GraphTitle();
Telerik.Reporting.NumericalScale numericalScale1 = new Telerik.Reporting.NumericalScale();
Telerik.Reporting.CategoryScale categoryScale1 = new Telerik.Reporting.CategoryScale();
Telerik.Reporting.GraphGroup graphGroup2 = new Telerik.Reporting.GraphGroup();
Telerik.Reporting.GraphGroup graphGroup3 = new Telerik.Reporting.GraphGroup();
Telerik.Reporting.Drawing.ColorPalette colorPalette2 = new Telerik.Reporting.Drawing.ColorPalette();
Telerik.Reporting.GraphTitle graphTitle2 = new Telerik.Reporting.GraphTitle();
Telerik.Reporting.NumericalScale numericalScale2 = new Telerik.Reporting.NumericalScale();
Telerik.Reporting.CategoryScale categoryScale2 = new Telerik.Reporting.CategoryScale();
Telerik.Reporting.GraphGroup graphGroup4 = new Telerik.Reporting.GraphGroup();
Telerik.Reporting.Group group1 = new Telerik.Reporting.Group();
Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter();
Telerik.Reporting.ReportParameter reportParameter2 = new Telerik.Reporting.ReportParameter();
Telerik.Reporting.ReportParameter reportParameter3 = new Telerik.Reporting.ReportParameter();
Telerik.Reporting.ReportParameter reportParameter4 = new Telerik.Reporting.ReportParameter();
Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule2 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule3 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule4 = new Telerik.Reporting.Drawing.StyleRule();
this.groupFooterSection1 = new Telerik.Reporting.GroupFooterSection();
this.groupHeaderSection1 = new Telerik.Reporting.GroupHeaderSection();
this.textBoxCategories = new Telerik.Reporting.TextBox();
this.textBoxTitle = new Telerik.Reporting.TextBox();
this.textBoxTimeInterval = new Telerik.Reporting.TextBox();
this.shape3 = new Telerik.Reporting.Shape();
this.productCategoriesDataSource = new Telerik.Reporting.SqlDataSource();
this.productSubcategoriesDataSource = new Telerik.Reporting.SqlDataSource();
this.detail = new Telerik.Reporting.DetailSection();
this.textBoxTopEmployeesHeader = new Telerik.Reporting.TextBox();
this.textBoxTopStoresHeader = new Telerik.Reporting.TextBox();
this.graph1 = new Telerik.Reporting.Graph();
this.cartesianCoordinateSystem2 = new Telerik.Reporting.CartesianCoordinateSystem();
this.graphAxis3 = new Telerik.Reporting.GraphAxis();
this.graphAxis4 = new Telerik.Reporting.GraphAxis();
this.employeesDataSource = new Telerik.Reporting.SqlDataSource();
this.barSeries1 = new Telerik.Reporting.BarSeries();
this.graph2 = new Telerik.Reporting.Graph();
this.polarCoordinateSystem3 = new Telerik.Reporting.PolarCoordinateSystem();
this.graphAxis7 = new Telerik.Reporting.GraphAxis();
this.graphAxis8 = new Telerik.Reporting.GraphAxis();
this.storesDataSource = new Telerik.Reporting.SqlDataSource();
this.barSeries2 = new Telerik.Reporting.BarSeries();
this.reportFooterSection1 = new Telerik.Reporting.ReportFooterSection();
this.textBoxReportFooter = new Telerik.Reporting.TextBox();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// groupFooterSection1
//
this.groupFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.0520833320915699D);
this.groupFooterSection1.Name = "groupFooterSection1";
this.groupFooterSection1.Style.Visible = false;
//
// groupHeaderSection1
//
this.groupHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(1.1999999284744263D);
this.groupHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBoxCategories,
this.textBoxTitle,
this.textBoxTimeInterval,
this.shape3
});
this.groupHeaderSection1.Name = "groupHeaderSection1";
//
// textBoxCategories
//
this.textBoxCategories.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.21311600506305695D));
this.textBoxCategories.Name = "textBoxCategories";
this.textBoxCategories.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0999212265014648D), Telerik.Reporting.Drawing.Unit.Inch(0.60000002384185791D));
this.textBoxCategories.StyleName = "Header";
this.textBoxCategories.Value = "= Parameters.ProductCategory+\" » \"+Join(\", \", Parameters.ProductSubcategory.Value" +
")";
//
// textBoxTitle
//
this.textBoxTitle.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(3.9339065551757812E-05D));
this.textBoxTitle.Name = "textBoxTitle";
this.textBoxTitle.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.3020832538604736D), Telerik.Reporting.Drawing.Unit.Inch(0.21299798786640167D));
this.textBoxTitle.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(195)))), ((int)(((byte)(47)))), ((int)(((byte)(11)))));
this.textBoxTitle.Style.Font.Bold = true;
this.textBoxTitle.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
this.textBoxTitle.Value = "PRODUCT LINE SALES";
//
// textBoxTimeInterval
//
this.textBoxTimeInterval.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.4558329582214355D), Telerik.Reporting.Drawing.Unit.Inch(3.9339065551757812E-05D));
this.textBoxTimeInterval.Name = "textBoxTimeInterval";
this.textBoxTimeInterval.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.64408802986145D), Telerik.Reporting.Drawing.Unit.Inch(0.21299798786640167D));
this.textBoxTimeInterval.Style.Font.Bold = true;
this.textBoxTimeInterval.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBoxTimeInterval.Value = "{Parameters.FromDate.Value.ToString(\"MMM yyyy\")} - {Parameters.ToDate.Value.ToStr" +
"ing(\"MMM yyyy\")}";
//
// shape3
//
this.shape3.Anchoring = ((Telerik.Reporting.AnchoringStyles)((Telerik.Reporting.AnchoringStyles.Left | Telerik.Reporting.AnchoringStyles.Right)));
this.shape3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9378803194267675E-05D), Telerik.Reporting.Drawing.Unit.Inch(0.83958339691162109D));
this.shape3.Name = "shape3";
this.shape3.ShapeType = new Telerik.Reporting.Drawing.Shapes.LineShape(Telerik.Reporting.Drawing.Shapes.LineDirection.EW);
this.shape3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.1099214553833D), Telerik.Reporting.Drawing.Unit.Point(3.75D));
this.shape3.Stretch = true;
this.shape3.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.shape3.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.shape3.Style.BorderWidth.Top = Telerik.Reporting.Drawing.Unit.Point(3D);
this.shape3.Style.Color = System.Drawing.Color.Transparent;
//
// productCategoriesDataSource
//
this.productCategoriesDataSource.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString";
this.productCategoriesDataSource.Name = "productCategoriesDataSource";
this.productCategoriesDataSource.SelectCommand = "SELECT Production.ProductCategory.Name AS ProductCategory\r\nFROM Production.Produc" +
"tCategory";
//
// productSubcategoriesDataSource
//
this.productSubcategoriesDataSource.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString";
this.productSubcategoriesDataSource.Name = "productSubcategoriesDataSource";
this.productSubcategoriesDataSource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
new Telerik.Reporting.SqlDataSourceParameter("@productCategory", System.Data.DbType.String, "=Parameters.ProductCategory.Value")
});
this.productSubcategoriesDataSource.SelectCommand = resources.GetString("productSubcategoriesDataSource.SelectCommand");
//
// detail
//
this.detail.Height = Telerik.Reporting.Drawing.Unit.Inch(7.1000003814697266D);
this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBoxTopEmployeesHeader,
this.textBoxTopStoresHeader,
this.graph1,
this.graph2
});
this.detail.Name = "detail";
//
// textBoxTopEmployeesHeader
//
this.textBoxTopEmployeesHeader.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9378803194267675E-05D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.textBoxTopEmployeesHeader.Name = "textBoxTopEmployeesHeader";
this.textBoxTopEmployeesHeader.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0998811721801758D), Telerik.Reporting.Drawing.Unit.Inch(0.30000004172325134D));
this.textBoxTopEmployeesHeader.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.textBoxTopEmployeesHeader.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(105)))), ((int)(((byte)(104)))));
this.textBoxTopEmployeesHeader.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Top;
this.textBoxTopEmployeesHeader.StyleName = "Category";
this.textBoxTopEmployeesHeader.TocText = "Top 10 Employees";
this.textBoxTopEmployeesHeader.Value = "Top 10 Employees";
//
// textBoxTopStoresHeader
//
this.textBoxTopStoresHeader.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(3.5999999046325684D));
this.textBoxTopStoresHeader.Name = "textBoxTopStoresHeader";
this.textBoxTopStoresHeader.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0999603271484375D), Telerik.Reporting.Drawing.Unit.Inch(0.3333333432674408D));
this.textBoxTopStoresHeader.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.textBoxTopStoresHeader.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(105)))), ((int)(((byte)(104)))));
this.textBoxTopStoresHeader.StyleName = "Category";
this.textBoxTopStoresHeader.TocText = "Top 10 Stores";
this.textBoxTopStoresHeader.Value = "Top 10 Stores";
//
// graph1
//
graphGroup1.Filters.Add(new Telerik.Reporting.Filter("=Sum(Fields.SubTotal)", Telerik.Reporting.FilterOperator.TopN, "=10"));
graphGroup1.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.Employee"));
graphGroup1.Name = "employeeGroup1";
graphGroup1.Sortings.Add(new Telerik.Reporting.Sorting("=Sum(Fields.SubTotal)", Telerik.Reporting.SortDirection.Asc));
this.graph1.CategoryGroups.Add(graphGroup1);
colorPalette1.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(21)))), ((int)(((byte)(198)))), ((int)(((byte)(198))))));
this.graph1.ColorPalette = colorPalette1;
this.graph1.CoordinateSystems.Add(this.cartesianCoordinateSystem2);
this.graph1.DataSource = this.employeesDataSource;
this.graph1.Legend.Style.LineColor = System.Drawing.Color.LightGray;
this.graph1.Legend.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D);
this.graph1.Legend.Style.Visible = false;
this.graph1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.0099999997764825821D), Telerik.Reporting.Drawing.Unit.Inch(0.40000000596046448D));
this.graph1.Name = "graph1";
this.graph1.PlotAreaStyle.LineColor = System.Drawing.Color.LightGray;
this.graph1.PlotAreaStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D);
this.graph1.Series.Add(this.barSeries1);
this.graph1.SeriesGroups.Add(graphGroup2);
this.graph1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.1000003814697266D), Telerik.Reporting.Drawing.Unit.Inch(2.9300000667572021D));
this.graph1.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Pixel(10D);
this.graph1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Pixel(10D);
this.graph1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Pixel(10D);
this.graph1.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Pixel(10D);
graphTitle1.Position = Telerik.Reporting.GraphItemPosition.TopCenter;
graphTitle1.Style.LineColor = System.Drawing.Color.LightGray;
graphTitle1.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D);
graphTitle1.Style.Visible = false;
graphTitle1.Text = "graph1";
this.graph1.Titles.Add(graphTitle1);
//
// cartesianCoordinateSystem2
//
this.cartesianCoordinateSystem2.Name = "cartesianCoordinateSystem2";
this.cartesianCoordinateSystem2.XAxis = this.graphAxis3;
this.cartesianCoordinateSystem2.YAxis = this.graphAxis4;
//
// graphAxis3
//
this.graphAxis3.LabelFormat = "{0:C0}K";
this.graphAxis3.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
this.graphAxis3.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.graphAxis3.MajorTickMarkDisplayType = Telerik.Reporting.GraphAxisTickMarkDisplayType.None;
this.graphAxis3.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
this.graphAxis3.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.graphAxis3.MinorGridLineStyle.Visible = false;
this.graphAxis3.Name = "graphAxis3";
this.graphAxis3.Scale = numericalScale1;
//
// graphAxis4
//
this.graphAxis4.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
this.graphAxis4.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.graphAxis4.MajorGridLineStyle.Visible = false;
this.graphAxis4.MajorTickMarkDisplayType = Telerik.Reporting.GraphAxisTickMarkDisplayType.None;
this.graphAxis4.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
this.graphAxis4.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.graphAxis4.MinorGridLineStyle.Visible = false;
this.graphAxis4.Name = "graphAxis4";
categoryScale1.SpacingSlotCount = 0.4D;
this.graphAxis4.Scale = categoryScale1;
//
// employeesDataSource
//
this.employeesDataSource.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString";
this.employeesDataSource.Name = "employeesDataSource";
this.employeesDataSource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
new Telerik.Reporting.SqlDataSourceParameter("@productCategory", System.Data.DbType.String, "=Parameters.ProductCategory.Value"),
new Telerik.Reporting.SqlDataSourceParameter("@FromDate", System.Data.DbType.DateTime, "=Parameters.FromDate.Value"),
new Telerik.Reporting.SqlDataSourceParameter("@ToDate", System.Data.DbType.DateTime, "=Parameters.ToDate.Value"),
new Telerik.Reporting.SqlDataSourceParameter("@productSubCategory", System.Data.DbType.String, "=Parameters.ProductSubcategory.Value")
});
this.employeesDataSource.SelectCommand = resources.GetString("employeesDataSource.SelectCommand");
//
// barSeries1
//
this.barSeries1.CategoryGroup = graphGroup1;
this.barSeries1.CoordinateSystem = this.cartesianCoordinateSystem2;
this.barSeries1.DataPointLabel = "=Sum(Fields.SubTotal)";
this.barSeries1.DataPointLabelStyle.Visible = false;
this.barSeries1.DataPointStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D);
this.barSeries1.DataPointStyle.Visible = true;
this.barSeries1.LegendItem.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Point(0D);
this.barSeries1.LegendItem.Value = "SubTotal";
graphGroup2.Name = "seriesGroup1";
this.barSeries1.SeriesGroup = graphGroup2;
this.barSeries1.X = "=Sum(Fields.SubTotal) /1000.0";
//
// graph2
//
graphGroup3.Name = "categoryGroup1";
this.graph2.CategoryGroups.Add(graphGroup3);
colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(92)))), ((int)(((byte)(25)))), ((int)(((byte)(18))))));
colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(194)))), ((int)(((byte)(46)))), ((int)(((byte)(10))))));
colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(88)))), ((int)(((byte)(55))))));
colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(177)))), ((int)(((byte)(90)))), ((int)(((byte)(40))))));
colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(202)))), ((int)(((byte)(137)))), ((int)(((byte)(104))))));
colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(211)))), ((int)(((byte)(191)))), ((int)(((byte)(105))))));
colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(137)))), ((int)(((byte)(203)))), ((int)(((byte)(42))))));
colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(33)))), ((int)(((byte)(180)))), ((int)(((byte)(114))))));
colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(21)))), ((int)(((byte)(198)))), ((int)(((byte)(198))))));
colorPalette2.Colors.Add(System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(105)))), ((int)(((byte)(104))))));
this.graph2.ColorPalette = colorPalette2;
this.graph2.CoordinateSystems.Add(this.polarCoordinateSystem3);
this.graph2.DataSource = this.storesDataSource;
this.graph2.Legend.Style.Font.Name = "Segoe UI";
this.graph2.Legend.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(8D);
this.graph2.Legend.Style.LineColor = System.Drawing.Color.LightGray;
this.graph2.Legend.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D);
this.graph2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.0099999997764825821D), Telerik.Reporting.Drawing.Unit.Inch(4.0999999046325684D));
this.graph2.Name = "graph2";
this.graph2.PlotAreaStyle.LineColor = System.Drawing.Color.LightGray;
this.graph2.PlotAreaStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D);
this.graph2.Series.Add(this.barSeries2);
this.graph2.SeriesGroups.Add(graphGroup4);
this.graph2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(7.190000057220459D), Telerik.Reporting.Drawing.Unit.Inch(2.9300000667572021D));
this.graph2.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Pixel(20D);
this.graph2.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Pixel(10D);
this.graph2.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Pixel(30D);
this.graph2.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Pixel(20D);
graphTitle2.Position = Telerik.Reporting.GraphItemPosition.TopCenter;
graphTitle2.Style.LineColor = System.Drawing.Color.LightGray;
graphTitle2.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D);
this.graph2.Titles.Add(graphTitle2);
//
// polarCoordinateSystem3
//
this.polarCoordinateSystem3.AngularAxis = this.graphAxis7;
this.polarCoordinateSystem3.Name = "polarCoordinateSystem3";
this.polarCoordinateSystem3.RadialAxis = this.graphAxis8;
//
// graphAxis7
//
this.graphAxis7.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
this.graphAxis7.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.graphAxis7.MajorGridLineStyle.Visible = false;
this.graphAxis7.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
this.graphAxis7.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.graphAxis7.MinorGridLineStyle.Visible = false;
this.graphAxis7.Name = "graphAxis7";
this.graphAxis7.Scale = numericalScale2;
this.graphAxis7.Style.Visible = false;
//
// graphAxis8
//
this.graphAxis8.MajorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
this.graphAxis8.MajorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.graphAxis8.MajorGridLineStyle.Visible = false;
this.graphAxis8.MinorGridLineStyle.LineColor = System.Drawing.Color.LightGray;
this.graphAxis8.MinorGridLineStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.graphAxis8.MinorGridLineStyle.Visible = false;
this.graphAxis8.Name = "graphAxis8";
categoryScale2.PositionMode = Telerik.Reporting.AxisPositionMode.OnTicks;
categoryScale2.SpacingSlotCount = 0D;
this.graphAxis8.Scale = categoryScale2;
this.graphAxis8.Style.Visible = false;
//
// storesDataSource
//
this.storesDataSource.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString";
this.storesDataSource.Name = "storesDataSource";
this.storesDataSource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
new Telerik.Reporting.SqlDataSourceParameter("@productCategory", System.Data.DbType.String, "=Parameters.ProductCategory.Value"),
new Telerik.Reporting.SqlDataSourceParameter("@FromDate", System.Data.DbType.DateTime, "=Parameters.FromDate.Value"),
new Telerik.Reporting.SqlDataSourceParameter("@ToDate", System.Data.DbType.DateTime, "=Parameters.ToDate.Value")
});
this.storesDataSource.SelectCommand = resources.GetString("storesDataSource.SelectCommand");
//
// barSeries2
//
this.barSeries2.ArrangeMode = Telerik.Reporting.GraphSeriesArrangeMode.Stacked100;
this.barSeries2.CategoryGroup = graphGroup3;
this.barSeries2.CoordinateSystem = this.polarCoordinateSystem3;
this.barSeries2.DataPointLabel = "=Sum(Fields.SubTotal)/1000.0";
this.barSeries2.DataPointLabelFormat = "{0:C0}K";
this.barSeries2.DataPointLabelStyle.Visible = true;
this.barSeries2.DataPointStyle.LineWidth = Telerik.Reporting.Drawing.Unit.Inch(0D);
this.barSeries2.DataPointStyle.Visible = true;
this.barSeries2.LegendItem.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Point(0D);
this.barSeries2.LegendItem.Value = "=Fields.StoreName";
graphGroup4.Filters.Add(new Telerik.Reporting.Filter("=Sum(Fields.SubTotal)", Telerik.Reporting.FilterOperator.TopN, "=10"));
graphGroup4.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.StoreName"));
graphGroup4.Name = "storeNameGroup1";
graphGroup4.Sortings.Add(new Telerik.Reporting.Sorting("=Sum(Fields.SubTotal)", Telerik.Reporting.SortDirection.Asc));
this.barSeries2.SeriesGroup = graphGroup4;
this.barSeries2.X = "=Sum(Fields.SubTotal)";
//
// reportFooterSection1
//
this.reportFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.30000001192092896D);
this.reportFooterSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBoxReportFooter
});
this.reportFooterSection1.Name = "reportFooterSection1";
//
// textBoxReportFooter
//
this.textBoxReportFooter.Name = "textBoxReportFooter";
this.textBoxReportFooter.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.0999212265014648D), Telerik.Reporting.Drawing.Unit.Inch(0.30000001192092896D));
this.textBoxReportFooter.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.textBoxReportFooter.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBoxReportFooter.Value = "AdventureWorks {Now().Year}";
//
// ProductLineSales
//
this.Culture = new System.Globalization.CultureInfo("en-US");
this.DocumentName = "= Parameters.ProductCategory.Value + \'Sales(\' + Join(\", \", Parameters.ProductSubc" +
"ategory.Value) + \')[\' + NOW().ToString(\'MMMM yyyy\') + \']\'";
group1.GroupFooter = this.groupFooterSection1;
group1.GroupHeader = this.groupHeaderSection1;
group1.Name = "group1";
this.Groups.AddRange(new Telerik.Reporting.Group[] {
group1
});
this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.groupHeaderSection1,
this.groupFooterSection1,
this.detail,
this.reportFooterSection1
});
this.Name = "ProductLineSales";
this.PageSettings.Landscape = false;
this.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D), Telerik.Reporting.Drawing.Unit.Inch(0.20000000298023224D), Telerik.Reporting.Drawing.Unit.Inch(0.30000001192092896D), Telerik.Reporting.Drawing.Unit.Inch(0.40000000596046448D));
this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter;
reportParameter1.AutoRefresh = true;
reportParameter1.AvailableValues.DataSource = this.productCategoriesDataSource;
reportParameter1.AvailableValues.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.ProductCategory", Telerik.Reporting.SortDirection.Asc));
reportParameter1.AvailableValues.ValueMember = "ProductCategory";
reportParameter1.Name = "ProductCategory";
reportParameter1.Text = "Category";
reportParameter1.Value = "Bikes";
reportParameter1.Visible = true;
reportParameter2.AutoRefresh = true;
reportParameter2.AvailableValues.DataSource = this.productSubcategoriesDataSource;
reportParameter2.AvailableValues.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.ProductSubcategory", Telerik.Reporting.SortDirection.Asc));
reportParameter2.AvailableValues.ValueMember = "ProductSubcategory";
reportParameter2.MultiValue = true;
reportParameter2.Name = "ProductSubcategory";
reportParameter2.Text = "Subcategory";
reportParameter2.Value = "=First(Fields.ProductSubcategory)";
reportParameter2.Visible = true;
reportParameter3.Name = "FromDate";
reportParameter3.Type = Telerik.Reporting.ReportParameterType.DateTime;
reportParameter3.Value = "=#2001-01-01#";
reportParameter4.Name = "ToDate";
reportParameter4.Type = Telerik.Reporting.ReportParameterType.DateTime;
reportParameter4.Value = "=#2004-12-31#";
this.ReportParameters.Add(reportParameter1);
this.ReportParameters.Add(reportParameter2);
this.ReportParameters.Add(reportParameter3);
this.ReportParameters.Add(reportParameter4);
styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextItemBase)),
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.HtmlTextBox))
});
styleRule1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(2D);
styleRule1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D);
styleRule2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("Header")
});
styleRule2.Style.Font.Bold = true;
styleRule2.Style.Font.Name = "Segoe UI Light";
styleRule2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(25D);
styleRule2.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D);
styleRule3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextBox))
});
styleRule3.Style.Font.Name = "Segoe UI";
styleRule3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
styleRule3.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
styleRule4.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("Category")
});
styleRule4.Style.Font.Name = "Segoe UI";
styleRule4.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(13D);
styleRule4.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D);
this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] {
styleRule1,
styleRule2,
styleRule3,
styleRule4
});
this.TocText = "Product Line Sales";
this.Width = Telerik.Reporting.Drawing.Unit.Inch(8.1100006103515625D);
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
public void InitializeComponent2()
{
Telerik.Reporting.Group group1 = new Telerik.Reporting.Group();
Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule2 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule3 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule4 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule5 = new Telerik.Reporting.Drawing.StyleRule();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// labelsGroupHeaderSection
//
GroupHeader.Height = Telerik.Reporting.Drawing.Unit.Inch(0.44166669249534607D);
GroupHeader.Name = "labelsGroupHeaderSection";
GroupHeader.PrintOnEveryPage = true;
//
// labelsGroupFooterSection
//
GroupFooter.Height = Telerik.Reporting.Drawing.Unit.Inch(0.28125D);
GroupFooter.Name = "labelsGroupFooterSection";
GroupFooter.Style.Visible = false;
//
// pageFooter
//
PageFooter.Height = Telerik.Reporting.Drawing.Unit.Inch(0.42083334922790527D);
PageFooter.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
CurrentTime,
PageInfo
});
PageFooter.Name = "pageFooter";
//
// currentTimeTextBox
//
CurrentTime.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.02083333395421505D), Telerik.Reporting.Drawing.Unit.Inch(0.02083333395421505D));
CurrentTime.Name = "currentTimeTextBox";
CurrentTime.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.9791667461395264D), Telerik.Reporting.Drawing.Unit.Inch(0.40000000596046448D));
CurrentTime.StyleName = "PageInfo";
CurrentTime.Value = "=NOW()";
//
// pageInfoTextBox
//
PageInfo.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.0000789165496826D), Telerik.Reporting.Drawing.Unit.Inch(0.02083333395421505D));
PageInfo.Name = "pageInfoTextBox";
PageInfo.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(3.4374210834503174D), Telerik.Reporting.Drawing.Unit.Inch(0.40000000596046448D));
PageInfo.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
PageInfo.StyleName = "PageInfo";
PageInfo.Value = "=PageNumber + \" of \"+PageCount";
//
// reportHeader
//
ReportHeader.Height = Telerik.Reporting.Drawing.Unit.Inch(0.80823493003845215D);
ReportHeader.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
TitleText
});
ReportHeader.Name = "reportHeader";
//
// titleTextBox
//
TitleText.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D));
TitleText.Name = "titleTextBox";
TitleText.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(6.4583334922790527D), Telerik.Reporting.Drawing.Unit.Inch(0.787401556968689D));
TitleText.StyleName = "Title";
//
// reportFooter
//
ReportFooter.Height = Telerik.Reporting.Drawing.Unit.Inch(0.28125D);
ReportFooter.Name = "reportFooter";
//
// detail
//
DetailSection.Height = Telerik.Reporting.Drawing.Unit.Inch(0.44166669249534607D);
DetailSection.Name = "detail";
//
// pageHeader
//
PageHeader.Height = Telerik.Reporting.Drawing.Unit.Inch(0.44166669249534607D);
PageHeader.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
ReportName
});
PageHeader.Name = "pageHeader";
//
// reportNameTextBox
//
ReportName.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.02083333395421505D), Telerik.Reporting.Drawing.Unit.Inch(0.02083333395421505D));
ReportName.Name = "reportNameTextBox";
ReportName.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(6.4166665077209473D), Telerik.Reporting.Drawing.Unit.Inch(0.40000000596046448D));
ReportName.StyleName = "PageInfo";
//
// Report1
//
group1.GroupFooter = GroupFooter;
group1.GroupHeader = GroupHeader;
group1.Name = "labelsGroup";
this.Groups.AddRange(new Telerik.Reporting.Group[] {
group1
});
this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
GroupHeader,
GroupFooter,
PageHeader,
PageFooter,
ReportHeader,
ReportFooter,
DetailSection
});
this.Name = "Report1";
this.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Inch(1D), Telerik.Reporting.Drawing.Unit.Inch(1D), Telerik.Reporting.Drawing.Unit.Inch(1D), Telerik.Reporting.Drawing.Unit.Inch(1D));
this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter;
styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextItemBase)),
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.HtmlTextBox))
});
styleRule1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(2D);
styleRule1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D);
styleRule2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("Title")
});
styleRule2.Style.Color = System.Drawing.Color.Black;
styleRule2.Style.Font.Bold = true;
styleRule2.Style.Font.Italic = false;
styleRule2.Style.Font.Name = "Tahoma";
styleRule2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(18D);
styleRule2.Style.Font.Strikeout = false;
styleRule2.Style.Font.Underline = false;
styleRule3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("Caption")
});
styleRule3.Style.Color = System.Drawing.Color.Black;
styleRule3.Style.Font.Name = "Tahoma";
styleRule3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(10D);
styleRule3.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
styleRule4.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("Data")
});
styleRule4.Style.Font.Name = "Tahoma";
styleRule4.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
styleRule4.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
styleRule5.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("PageInfo")
});
styleRule5.Style.Font.Name = "Tahoma";
styleRule5.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(8D);
styleRule5.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] {
styleRule1,
styleRule2,
styleRule3,
styleRule4,
styleRule5
});
this.Width = Telerik.Reporting.Drawing.Unit.Inch(6.4583334922790527D);
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
/// <summary>
/// Required method for telerik Reporting designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
Telerik.Reporting.TableGroup tableGroup1 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup2 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup3 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup4 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup5 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup6 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup7 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.TableGroup tableGroup8 = new Telerik.Reporting.TableGroup();
Telerik.Reporting.Drawing.FormattingRule formattingRule1 = new Telerik.Reporting.Drawing.FormattingRule();
Telerik.Reporting.Drawing.FormattingRule formattingRule2 = new Telerik.Reporting.Drawing.FormattingRule();
Telerik.Reporting.Drawing.FormattingRule formattingRule3 = new Telerik.Reporting.Drawing.FormattingRule();
Telerik.Reporting.Drawing.FormattingRule formattingRule4 = new Telerik.Reporting.Drawing.FormattingRule();
Telerik.Reporting.Drawing.FormattingRule formattingRule5 = new Telerik.Reporting.Drawing.FormattingRule();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ProductCatalog));
Telerik.Reporting.TocLevel tocLevel1 = new Telerik.Reporting.TocLevel();
Telerik.Reporting.TocLevel tocLevel2 = new Telerik.Reporting.TocLevel();
Telerik.Reporting.TocLevel tocLevel3 = new Telerik.Reporting.TocLevel();
Telerik.Reporting.Group group1 = new Telerik.Reporting.Group();
Telerik.Reporting.Group group2 = new Telerik.Reporting.Group();
Telerik.Reporting.Group group3 = new Telerik.Reporting.Group();
Telerik.Reporting.Drawing.TextWatermark textWatermark1 = new Telerik.Reporting.Drawing.TextWatermark();
Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter();
Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule2 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule3 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule4 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule5 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.DescendantSelector descendantSelector1 = new Telerik.Reporting.Drawing.DescendantSelector();
this.textBox5 = new Telerik.Reporting.TextBox();
this.textBox14 = new Telerik.Reporting.TextBox();
this.textBox15 = new Telerik.Reporting.TextBox();
this.textBox7 = new Telerik.Reporting.TextBox();
this.textBox9 = new Telerik.Reporting.TextBox();
this.textBox19 = new Telerik.Reporting.TextBox();
this.textBox21 = new Telerik.Reporting.TextBox();
this.groupFooterSection1 = new Telerik.Reporting.GroupFooterSection();
this.groupHeaderSection1 = new Telerik.Reporting.GroupHeaderSection();
this.textBoxProductCategoryLabel = new Telerik.Reporting.TextBox();
this.textBox3 = new Telerik.Reporting.TextBox();
this.shape3 = new Telerik.Reporting.Shape();
this.groupFooterSection2 = new Telerik.Reporting.GroupFooterSection();
this.groupHeaderSection2 = new Telerik.Reporting.GroupHeaderSection();
this.textBox4 = new Telerik.Reporting.TextBox();
this.groupFooterSection3 = new Telerik.Reporting.GroupFooterSection();
this.groupHeaderSection3 = new Telerik.Reporting.GroupHeaderSection();
this.panel3 = new Telerik.Reporting.Panel();
this.pictureBox1 = new Telerik.Reporting.PictureBox();
this.textBox1 = new Telerik.Reporting.TextBox();
this.table1 = new Telerik.Reporting.Table();
this.textBox16 = new Telerik.Reporting.TextBox();
this.textBox17 = new Telerik.Reporting.TextBox();
this.textBox8 = new Telerik.Reporting.TextBox();
this.textBox18 = new Telerik.Reporting.TextBox();
this.textBox20 = new Telerik.Reporting.TextBox();
this.textBox22 = new Telerik.Reporting.TextBox();
this.panel7 = new Telerik.Reporting.Panel();
this.shape1 = new Telerik.Reporting.Shape();
this.textBox10 = new Telerik.Reporting.TextBox();
this.textBox6 = new Telerik.Reporting.TextBox();
this.sqlDataSource2 = new Telerik.Reporting.SqlDataSource();
this.detailSection1 = new Telerik.Reporting.DetailSection();
this.sqlDataSource1 = new Telerik.Reporting.SqlDataSource();
this.tocSection1 = new Telerik.Reporting.TocSection();
this.pageHeaderSection1 = new Telerik.Reporting.PageHeaderSection();
this.textBox2 = new Telerik.Reporting.TextBox();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// textBox5
//
this.textBox5.Name = "textBox5";
this.textBox5.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.954D), Telerik.Reporting.Drawing.Unit.Inch(0.271D));
this.textBox5.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(177)))), ((int)(((byte)(161)))), ((int)(((byte)(82)))));
this.textBox5.Value = "Product No.";
//
// textBox14
//
this.textBox14.Name = "textBox14";
this.textBox14.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.221D), Telerik.Reporting.Drawing.Unit.Cm(0.688D));
this.textBox14.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(177)))), ((int)(((byte)(161)))), ((int)(((byte)(82)))));
this.textBox14.Value = "Product";
//
// textBox15
//
this.textBox15.Name = "textBox15";
this.textBox15.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.069D), Telerik.Reporting.Drawing.Unit.Cm(0.688D));
this.textBox15.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(177)))), ((int)(((byte)(161)))), ((int)(((byte)(82)))));
this.textBox15.Value = "Color";
//
// textBox7
//
this.textBox7.Name = "textBox7";
this.textBox7.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.638D), Telerik.Reporting.Drawing.Unit.Cm(0.688D));
this.textBox7.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(177)))), ((int)(((byte)(161)))), ((int)(((byte)(82)))));
this.textBox7.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox7.Value = "Size";
//
// textBox9
//
this.textBox9.Name = "textBox9";
this.textBox9.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.634D), Telerik.Reporting.Drawing.Unit.Cm(0.688D));
this.textBox9.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(177)))), ((int)(((byte)(161)))), ((int)(((byte)(82)))));
this.textBox9.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox9.Value = "Weight";
//
// textBox19
//
this.textBox19.Name = "textBox19";
this.textBox19.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.072D), Telerik.Reporting.Drawing.Unit.Cm(0.688D));
this.textBox19.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(177)))), ((int)(((byte)(161)))), ((int)(((byte)(82)))));
this.textBox19.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox19.Value = "Dealer";
//
// textBox21
//
this.textBox21.Name = "textBox21";
this.textBox21.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.101D), Telerik.Reporting.Drawing.Unit.Cm(0.688D));
this.textBox21.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
this.textBox21.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(177)))), ((int)(((byte)(161)))), ((int)(((byte)(82)))));
this.textBox21.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox21.Value = "List Price";
//
// groupFooterSection1
//
this.groupFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.219D);
this.groupFooterSection1.Name = "groupFooterSection1";
this.groupFooterSection1.Style.Visible = false;
//
// groupHeaderSection1
//
this.groupHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(1.5D);
this.groupHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBoxProductCategoryLabel,
this.textBox3,
this.shape3
});
this.groupHeaderSection1.Name = "groupHeaderSection1";
this.groupHeaderSection1.PrintOnEveryPage = true;
this.groupHeaderSection1.ItemDataBound += new System.EventHandler(this.groupHeaderSection1_ItemDataBound);
//
// textBoxProductCategoryLabel
//
this.textBoxProductCategoryLabel.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.9D));
this.textBoxProductCategoryLabel.Name = "textBoxProductCategoryLabel";
this.textBoxProductCategoryLabel.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.1D), Telerik.Reporting.Drawing.Unit.Inch(0.4D));
this.textBoxProductCategoryLabel.StyleName = "Category";
this.textBoxProductCategoryLabel.Value = "=Fields.ProductCategory";
//
// textBox3
//
this.textBox3.Culture = new System.Globalization.CultureInfo("en");
this.textBox3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.textBox3.Name = "textBox3";
this.textBox3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.1D), Telerik.Reporting.Drawing.Unit.Inch(0.6D));
this.textBox3.StyleName = "Header";
this.textBox3.Value = "Product Catalog";
//
// shape3
//
this.shape3.Anchoring = ((Telerik.Reporting.AnchoringStyles)((Telerik.Reporting.AnchoringStyles.Left | Telerik.Reporting.AnchoringStyles.Right)));
this.shape3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.6D));
this.shape3.Name = "shape3";
this.shape3.ShapeType = new Telerik.Reporting.Drawing.Shapes.LineShape(Telerik.Reporting.Drawing.Shapes.LineDirection.EW);
this.shape3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.1D), Telerik.Reporting.Drawing.Unit.Point(2D));
this.shape3.Stretch = true;
this.shape3.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.shape3.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
this.shape3.Style.BorderWidth.Bottom = Telerik.Reporting.Drawing.Unit.Point(0.5D);
this.shape3.Style.BorderWidth.Top = Telerik.Reporting.Drawing.Unit.Point(1.5D);
this.shape3.Style.Color = System.Drawing.Color.Transparent;
//
// groupFooterSection2
//
this.groupFooterSection2.Height = Telerik.Reporting.Drawing.Unit.Inch(0.198D);
this.groupFooterSection2.Name = "groupFooterSection2";
this.groupFooterSection2.Style.Visible = false;
//
// groupHeaderSection2
//
this.groupHeaderSection2.Height = Telerik.Reporting.Drawing.Unit.Inch(0.4D);
this.groupHeaderSection2.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBox4
});
this.groupHeaderSection2.KeepTogether = false;
this.groupHeaderSection2.Name = "groupHeaderSection2";
this.groupHeaderSection2.PrintOnEveryPage = true;
//
// textBox4
//
this.textBox4.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.textBox4.Name = "textBox4";
this.textBox4.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.1D), Telerik.Reporting.Drawing.Unit.Inch(0.3D));
this.textBox4.StyleName = "SubCategory";
this.textBox4.Value = "=Fields.ProductSubCategory";
//
// groupFooterSection3
//
this.groupFooterSection3.Height = Telerik.Reporting.Drawing.Unit.Inch(0.15D);
this.groupFooterSection3.Name = "groupFooterSection3";
//
// groupHeaderSection3
//
this.groupHeaderSection3.Height = Telerik.Reporting.Drawing.Unit.Inch(1.5D);
this.groupHeaderSection3.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.panel3
});
this.groupHeaderSection3.Name = "groupHeaderSection3";
this.groupHeaderSection3.PrintOnEveryPage = true;
//
// panel3
//
this.panel3.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.pictureBox1,
this.textBox1,
this.table1,
this.textBox6
});
this.panel3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.2D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.panel3.Name = "panel3";
this.panel3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(7.7D), Telerik.Reporting.Drawing.Unit.Inch(1.453D));
//
// pictureBox1
//
this.pictureBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.pictureBox1.MimeType = "";
this.pictureBox1.Name = "pictureBox1";
this.pictureBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.337D), Telerik.Reporting.Drawing.Unit.Inch(0.9D));
this.pictureBox1.Sizing = Telerik.Reporting.Drawing.ImageSizeMode.ScaleProportional;
this.pictureBox1.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.pictureBox1.Style.Color = System.Drawing.Color.White;
this.pictureBox1.Style.LineWidth = Telerik.Reporting.Drawing.Unit.Pixel(1D);
this.pictureBox1.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Point(1D);
this.pictureBox1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(1D);
this.pictureBox1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(1D);
this.pictureBox1.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Point(1D);
this.pictureBox1.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.pictureBox1.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
this.pictureBox1.Value = "=Fields.LargePhoto";
//
// textBox1
//
this.textBox1.Bindings.Add(new Telerik.Reporting.Binding("Style.Font.Name", "= IIf(Parameters.CultureID.Value = \'zh-cht\', \'Microsoft JhengHei\', IIf(Parameters" +
".CultureID.Value = \'th\', \'Microsoft Sans Serif\', \'Segoe UI Light\'))"));
this.textBox1.CanShrink = true;
this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(4.245D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.textBox1.Name = "textBox1";
this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(3.3D), Telerik.Reporting.Drawing.Unit.Inch(0.9D));
this.textBox1.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.None;
this.textBox1.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
this.textBox1.Style.Font.Name = "Segoe UI Light";
this.textBox1.Value = "=Fields.Description";
//
// table1
//
this.table1.Bindings.Add(new Telerik.Reporting.Binding("DataSource", "=ReportItem.DataObject"));
this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(0.954D)));
this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(2.221D)));
this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(1.069D)));
this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(0.638D)));
this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(0.634D)));
this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(1.072D)));
this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(1.101D)));
this.table1.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(Telerik.Reporting.Drawing.Unit.Cm(0.717D)));
this.table1.Body.SetCellContent(0, 0, this.textBox16);
this.table1.Body.SetCellContent(0, 1, this.textBox17);
this.table1.Body.SetCellContent(0, 3, this.textBox8);
this.table1.Body.SetCellContent(0, 4, this.textBox18);
this.table1.Body.SetCellContent(0, 5, this.textBox20);
this.table1.Body.SetCellContent(0, 6, this.textBox22);
this.table1.Body.SetCellContent(0, 2, this.panel7);
tableGroup1.Name = "tableGroup1";
tableGroup1.ReportItem = this.textBox5;
tableGroup2.Name = "tableGroup2";
tableGroup2.ReportItem = this.textBox14;
tableGroup3.Name = "tableGroup3";
tableGroup3.ReportItem = this.textBox15;
tableGroup4.Name = "tableGroup4";
tableGroup4.ReportItem = this.textBox7;
tableGroup5.Name = "tableGroup5";
tableGroup5.ReportItem = this.textBox9;
tableGroup6.Name = "tableGroup6";
tableGroup6.ReportItem = this.textBox19;
tableGroup7.Name = "tableGroup7";
tableGroup7.ReportItem = this.textBox21;
this.table1.ColumnGroups.Add(tableGroup1);
this.table1.ColumnGroups.Add(tableGroup2);
this.table1.ColumnGroups.Add(tableGroup3);
this.table1.ColumnGroups.Add(tableGroup4);
this.table1.ColumnGroups.Add(tableGroup5);
this.table1.ColumnGroups.Add(tableGroup6);
this.table1.ColumnGroups.Add(tableGroup7);
this.table1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBox16,
this.textBox17,
this.panel7,
this.textBox8,
this.textBox18,
this.textBox20,
this.textBox22,
this.textBox5,
this.textBox14,
this.textBox15,
this.textBox7,
this.textBox9,
this.textBox19,
this.textBox21
});
this.table1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0D), Telerik.Reporting.Drawing.Unit.Cm(2.286D));
this.table1.Name = "table1";
tableGroup8.Groupings.Add(new Telerik.Reporting.Grouping(""));
tableGroup8.Name = "detailGroup";
this.table1.RowGroups.Add(tableGroup8);
this.table1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(7.69D), Telerik.Reporting.Drawing.Unit.Cm(1.405D));
//
// textBox16
//
this.textBox16.Name = "textBox16";
this.textBox16.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.954D), Telerik.Reporting.Drawing.Unit.Cm(0.717D));
this.textBox16.Value = "=Fields.ProductNumber";
//
// textBox17
//
this.textBox17.Name = "textBox17";
this.textBox17.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.221D), Telerik.Reporting.Drawing.Unit.Cm(0.717D));
this.textBox17.Value = "=Fields.ProductName";
//
// textBox8
//
this.textBox8.Name = "textBox8";
this.textBox8.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.638D), Telerik.Reporting.Drawing.Unit.Cm(0.717D));
this.textBox8.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox8.Value = "=IsNull(Fields.Size, \'N/A\')";
//
// textBox18
//
this.textBox18.Name = "textBox18";
this.textBox18.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.634D), Telerik.Reporting.Drawing.Unit.Cm(0.717D));
this.textBox18.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox18.Value = "=IsNull(Fields.Weight, \'N/A\')";
//
// textBox20
//
this.textBox20.Format = "{0:C2}";
this.textBox20.Name = "textBox20";
this.textBox20.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.072D), Telerik.Reporting.Drawing.Unit.Cm(0.717D));
this.textBox20.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox20.Value = "=ISNULL(Fields.StandardCost, \"Call\")";
//
// textBox22
//
this.textBox22.Format = "{0:C2}";
this.textBox22.Name = "textBox22";
this.textBox22.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.101D), Telerik.Reporting.Drawing.Unit.Cm(0.717D));
this.textBox22.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
this.textBox22.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox22.Value = "=IsNull(Fields.ListPrice, \'Call\')";
//
// panel7
//
this.panel7.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.shape1,
this.textBox10
});
this.panel7.Name = "panel7";
this.panel7.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.069D), Telerik.Reporting.Drawing.Unit.Cm(0.717D));
this.panel7.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(230)))), ((int)(((byte)(230)))), ((int)(((byte)(230)))));
this.panel7.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.panel7.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.Solid;
this.panel7.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.panel7.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
//
// shape1
//
formattingRule1.Filters.Add(new Telerik.Reporting.Filter("= ToLower(Fields.Color)", Telerik.Reporting.FilterOperator.Equal, "red"));
formattingRule1.StopIfTrue = true;
formattingRule1.Style.BackgroundColor = System.Drawing.Color.Red;
formattingRule2.Filters.Add(new Telerik.Reporting.Filter("= ToLower(Fields.Color)", Telerik.Reporting.FilterOperator.Equal, "blue"));
formattingRule2.StopIfTrue = true;
formattingRule2.Style.BackgroundColor = System.Drawing.Color.Blue;
formattingRule3.Filters.Add(new Telerik.Reporting.Filter("= ToLower(Fields.Color)", Telerik.Reporting.FilterOperator.Equal, "black"));
formattingRule3.StopIfTrue = true;
formattingRule3.Style.BackgroundColor = System.Drawing.Color.Black;
formattingRule4.Filters.Add(new Telerik.Reporting.Filter("= ToLower(Fields.Color)", Telerik.Reporting.FilterOperator.Equal, "yellow"));
formattingRule4.StopIfTrue = true;
formattingRule4.Style.BackgroundColor = System.Drawing.Color.Yellow;
formattingRule5.Filters.Add(new Telerik.Reporting.Filter("= ToLower(Fields.Color)", Telerik.Reporting.FilterOperator.Equal, "silver"));
formattingRule5.StopIfTrue = true;
formattingRule5.Style.BackgroundColor = System.Drawing.Color.Silver;
this.shape1.ConditionalFormatting.AddRange(new Telerik.Reporting.Drawing.FormattingRule[] {
formattingRule1,
formattingRule2,
formattingRule3,
formattingRule4,
formattingRule5
});
this.shape1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0.079D), Telerik.Reporting.Drawing.Unit.Cm(0.07D));
this.shape1.Name = "shape1";
this.shape1.ShapeType = new Telerik.Reporting.Drawing.Shapes.EllipseShape(0D);
this.shape1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.26D), Telerik.Reporting.Drawing.Unit.Inch(0.223D));
this.shape1.Style.Color = System.Drawing.Color.Transparent;
//
// textBox10
//
this.textBox10.Format = "{0:C2}";
this.textBox10.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0.82D), Telerik.Reporting.Drawing.Unit.Cm(0.07D));
this.textBox10.Name = "textBox10";
this.textBox10.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(1.68D), Telerik.Reporting.Drawing.Unit.Inch(0.255D));
this.textBox10.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.None;
this.textBox10.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
this.textBox10.Value = "= IsNull(Fields.Color, \'N/A\')";
//
// textBox6
//
this.textBox6.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.465D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.textBox6.Name = "textBox6";
this.textBox6.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.035D), Telerik.Reporting.Drawing.Unit.Inch(0.3D));
this.textBox6.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.None;
this.textBox6.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
this.textBox6.StyleName = "SubCategory";
this.textBox6.Value = "=Fields.ProductModel";
//
// sqlDataSource2
//
this.sqlDataSource2.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString";
this.sqlDataSource2.Name = "sqlDataSource2";
this.sqlDataSource2.SelectCommand = "SELECT RTRIM(CultureID) AS CultureID, Name FROM Production.Culture WHERE (NOT (RT" +
"RIM(CultureID) IN (\'es\', \'\')))";
//
// detailSection1
//
this.detailSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.132D);
this.detailSection1.Name = "detailSection1";
this.detailSection1.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(137)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
this.detailSection1.Style.BorderWidth.Left = Telerik.Reporting.Drawing.Unit.Point(3D);
this.detailSection1.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(8D);
this.detailSection1.Style.Visible = false;
//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString";
this.sqlDataSource1.Name = "sqlDataSource1";
this.sqlDataSource1.Parameters.Add(new Telerik.Reporting.SqlDataSourceParameter("@cultureID", System.Data.DbType.String, "=Parameters(\'CultureID\').Value"));
this.sqlDataSource1.SelectCommand = resources.GetString("sqlDataSource1.SelectCommand");
//
// tocSection1
//
this.tocSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(1.5D);
this.tocSection1.KeepTogether = false;
tocLevel1.LeaderSymbol = '\0';
tocLevel1.Name = "Level1";
tocLevel1.Style.Font.Bold = true;
tocLevel1.Style.Font.Name = "Segoe UI Light";
tocLevel1.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(16D);
tocLevel1.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Point(5D);
tocLevel1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(2D);
tocLevel1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D);
tocLevel1.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Point(5D);
tocLevel2.Name = "Level2";
tocLevel2.Style.Font.Name = "Segoe UI Light";
tocLevel2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(13D);
tocLevel2.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Point(1D);
tocLevel2.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(32D);
tocLevel2.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D);
tocLevel2.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Point(1D);
tocLevel3.Name = "Level3";
tocLevel3.Style.Font.Name = "Segoe UI Light";
tocLevel3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(13D);
tocLevel3.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Point(1D);
tocLevel3.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(52D);
tocLevel3.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D);
tocLevel3.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Point(1D);
this.tocSection1.Levels.Add(tocLevel1);
this.tocSection1.Levels.Add(tocLevel2);
this.tocSection1.Levels.Add(tocLevel3);
this.tocSection1.Name = "tocSection1";
this.tocSection1.PageBreak = Telerik.Reporting.PageBreak.After;
this.tocSection1.Title = "Table of Contents";
this.tocSection1.TitleStyle.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
this.tocSection1.TitleStyle.BorderWidth.Bottom = Telerik.Reporting.Drawing.Unit.Point(2D);
this.tocSection1.TitleStyle.Font.Bold = true;
this.tocSection1.TitleStyle.Font.Name = "Segoe UI Light";
this.tocSection1.TitleStyle.Font.Size = Telerik.Reporting.Drawing.Unit.Point(25D);
this.tocSection1.TitleStyle.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Point(10D);
//
// pageHeaderSection1
//
this.pageHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.2D);
this.pageHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBox2
});
this.pageHeaderSection1.Name = "pageHeaderSection1";
//
// textBox2
//
this.textBox2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(4.2D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.textBox2.Name = "textBox2";
this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(3.9D), Telerik.Reporting.Drawing.Unit.Inch(0.2D));
this.textBox2.Style.Font.Name = "Segoe UI Light";
this.textBox2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(10D);
this.textBox2.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox2.Value = "= PageExec(\'group1\', Fields.ProductCategory) + \', page \' + PageNumber(\'group1\', F" +
"ields.ProductCategory) + \' of \' + PageCount(\'group1\', Fields.ProductCategory)";
//
// ProductCatalog
//
this.Bindings.Add(new Telerik.Reporting.Binding("Culture", "=Parameters.CultureID.Value"));
this.DataSource = this.sqlDataSource1;
this.DocumentName = "=\'ProductCatalog.\' + Parameters.CultureID.Value";
group1.DocumentMapText = "=Fields.ProductCategory";
group1.GroupFooter = this.groupFooterSection1;
group1.GroupHeader = this.groupHeaderSection1;
group1.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.ProductCategory"));
group1.GroupKeepTogether = Telerik.Reporting.GroupKeepTogether.All;
group1.Name = "group1";
group1.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.ProductCategory", Telerik.Reporting.SortDirection.Asc));
group1.TocText = "=Fields.ProductCategory";
group2.DocumentMapText = "=Fields.ProductSubCategory";
group2.GroupFooter = this.groupFooterSection2;
group2.GroupHeader = this.groupHeaderSection2;
group2.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.ProductSubCategory"));
group2.GroupKeepTogether = Telerik.Reporting.GroupKeepTogether.FirstDetail;
group2.Name = "group2";
group2.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.ProductSubCategory", Telerik.Reporting.SortDirection.Asc));
group2.TocText = "=Fields.ProductSubCategory";
group3.DocumentMapText = "=Fields.ProductModel";
group3.GroupFooter = this.groupFooterSection3;
group3.GroupHeader = this.groupHeaderSection3;
group3.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.ProductModel"));
group3.GroupKeepTogether = Telerik.Reporting.GroupKeepTogether.FirstDetail;
group3.Name = "group3";
group3.Sortings.Add(new Telerik.Reporting.Sorting("=Fields.ProductModel", Telerik.Reporting.SortDirection.Asc));
this.Groups.AddRange(new Telerik.Reporting.Group[] {
group1,
group2,
group3
});
this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.groupHeaderSection1,
this.groupFooterSection1,
this.groupHeaderSection2,
this.groupFooterSection2,
this.groupHeaderSection3,
this.groupFooterSection3,
this.detailSection1,
this.tocSection1,
this.pageHeaderSection1
});
this.Name = "ProductCatalog";
this.PageSettings.Landscape = false;
this.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Inch(0.2D), Telerik.Reporting.Drawing.Unit.Inch(0.2D), Telerik.Reporting.Drawing.Unit.Inch(0.3D), Telerik.Reporting.Drawing.Unit.Inch(0.4D));
this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter;
textWatermark1.Color = System.Drawing.Color.FromArgb(((int)(((byte)(137)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
textWatermark1.Font.Name = "Tahoma";
textWatermark1.Font.Size = Telerik.Reporting.Drawing.Unit.Point(100D);
textWatermark1.Opacity = 0.06D;
textWatermark1.Orientation = Telerik.Reporting.Drawing.WatermarkOrientation.Vertical;
textWatermark1.Position = Telerik.Reporting.Drawing.WatermarkPosition.Front;
textWatermark1.Text = "=PageExec(\"textBoxProductCategoryLabel\", First(Fields.ProductCategory))";
this.PageSettings.Watermarks.Add(textWatermark1);
reportParameter1.AutoRefresh = true;
reportParameter1.AvailableValues.DataSource = this.sqlDataSource2;
reportParameter1.AvailableValues.DisplayMember = "Name";
reportParameter1.AvailableValues.ValueMember = "CultureID";
reportParameter1.Name = "CultureID";
reportParameter1.Text = "Language";
reportParameter1.Value = "en";
reportParameter1.Visible = true;
this.ReportParameters.Add(reportParameter1);
styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextItemBase)),
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.HtmlTextBox))
});
styleRule1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(2D);
styleRule1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D);
styleRule2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("Header")
});
styleRule2.Style.Font.Bold = true;
styleRule2.Style.Font.Name = "Segoe UI Light";
styleRule2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(25D);
styleRule2.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D);
styleRule3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("Category")
});
styleRule3.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(25)))), ((int)(((byte)(7)))), ((int)(((byte)(5)))));
styleRule3.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
styleRule3.Style.BorderWidth.Bottom = Telerik.Reporting.Drawing.Unit.Point(1D);
styleRule3.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D);
styleRule3.Style.Font.Name = "Segoe UI Light";
styleRule3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(16D);
styleRule3.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D);
styleRule4.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("SubCategory")
});
styleRule4.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
styleRule4.Style.BorderWidth.Bottom = Telerik.Reporting.Drawing.Unit.Point(0.5D);
styleRule4.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D);
styleRule4.Style.Font.Name = "Segoe UI Light";
styleRule4.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(13D);
styleRule4.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D);
descendantSelector1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.GroupHeaderSection)),
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.Panel)),
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextBox))
});
styleRule5.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
descendantSelector1
});
styleRule5.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(230)))), ((int)(((byte)(230)))), ((int)(((byte)(230)))));
styleRule5.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
styleRule5.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.Solid;
styleRule5.Style.Font.Name = "Segoe UI";
styleRule5.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(10D);
styleRule5.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Inch(0.04D);
styleRule5.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0.05D);
styleRule5.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Inch(0.05D);
styleRule5.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Bottom;
this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] {
styleRule1,
styleRule2,
styleRule3,
styleRule4,
styleRule5
});
this.TocText = "Product Catalog";
this.Width = Telerik.Reporting.Drawing.Unit.Inch(8.1D);
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
/// <summary>
/// Required method for telerik Reporting designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
Telerik.Reporting.SortingAction sortingAction1 = new Telerik.Reporting.SortingAction();
Telerik.Reporting.SortingAction sortingAction2 = new Telerik.Reporting.SortingAction();
Telerik.Reporting.SortingAction sortingAction3 = new Telerik.Reporting.SortingAction();
Telerik.Reporting.SortingAction sortingAction4 = new Telerik.Reporting.SortingAction();
Telerik.Reporting.SortingAction sortingAction5 = new Telerik.Reporting.SortingAction();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(SalesOrderDetails));
Telerik.Reporting.Group group1 = new Telerik.Reporting.Group();
Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter();
Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule2 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule3 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule4 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule5 = new Telerik.Reporting.Drawing.StyleRule();
this.labelsGroupFooter = new Telerik.Reporting.GroupFooterSection();
this.textBox1 = new Telerik.Reporting.TextBox();
this.textBox2 = new Telerik.Reporting.TextBox();
this.labelsGroupHeader = new Telerik.Reporting.GroupHeaderSection();
this.panel1 = new Telerik.Reporting.Panel();
this.productNumberCaptionTextBox = new Telerik.Reporting.TextBox();
this.nameCaptionTextBox = new Telerik.Reporting.TextBox();
this.orderQtyCaptionTextBox = new Telerik.Reporting.TextBox();
this.unitPriceCaptionTextBox = new Telerik.Reporting.TextBox();
this.lineTotalCaptionTextBox = new Telerik.Reporting.TextBox();
this.detail = new Telerik.Reporting.DetailSection();
this.productNumberDataTextBox = new Telerik.Reporting.TextBox();
this.nameDataTextBox = new Telerik.Reporting.TextBox();
this.orderQtyDataTextBox = new Telerik.Reporting.TextBox();
this.unitPriceDataTextBox = new Telerik.Reporting.TextBox();
this.lineTotalDataTextBox = new Telerik.Reporting.TextBox();
this.sqlDataSource1 = new Telerik.Reporting.SqlDataSource();
this.reportHeaderSection1 = new Telerik.Reporting.ReportHeaderSection();
this.textBox3 = new Telerik.Reporting.TextBox();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// labelsGroupFooter
//
this.labelsGroupFooter.Height = Telerik.Reporting.Drawing.Unit.Inch(0.47999998927116394D);
this.labelsGroupFooter.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBox1,
this.textBox2
});
this.labelsGroupFooter.Name = "labelsGroupFooter";
//
// textBox1
//
this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.textBox1.Name = "textBox1";
this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(6.1228375434875488D), Telerik.Reporting.Drawing.Unit.Inch(0.47996059060096741D));
this.textBox1.StyleName = "Total";
this.textBox1.Value = "Total";
//
// textBox2
//
this.textBox2.Format = "{0:C2}";
this.textBox2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(6.1229557991027832D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.textBox2.Name = "textBox2";
this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.9669651985168457D), Telerik.Reporting.Drawing.Unit.Inch(0.47996059060096741D));
this.textBox2.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.textBox2.StyleName = "Total";
this.textBox2.Value = "=Sum(Fields.LineTotal)";
//
// labelsGroupHeader
//
this.labelsGroupHeader.Height = Telerik.Reporting.Drawing.Unit.Inch(0.47999998927116394D);
this.labelsGroupHeader.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.panel1
});
this.labelsGroupHeader.Name = "labelsGroupHeader";
this.labelsGroupHeader.PrintOnEveryPage = true;
//
// panel1
//
this.panel1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.productNumberCaptionTextBox,
this.nameCaptionTextBox,
this.orderQtyCaptionTextBox,
this.unitPriceCaptionTextBox,
this.lineTotalCaptionTextBox
});
this.panel1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.panel1.Name = "panel1";
this.panel1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.089961051940918D), Telerik.Reporting.Drawing.Unit.Inch(0.47999998927116394D));
//
// productNumberCaptionTextBox
//
sortingAction1.SortingExpression = "= Fields.ProductNumber";
sortingAction1.Targets.AddRange(new Telerik.Reporting.IActionTarget[] {
this
});
this.productNumberCaptionTextBox.Action = sortingAction1;
this.productNumberCaptionTextBox.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(3.9378803194267675E-05D));
this.productNumberCaptionTextBox.Name = "productNumberCaptionTextBox";
this.productNumberCaptionTextBox.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.4000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0.47988176345825195D));
this.productNumberCaptionTextBox.Style.BorderStyle.Left = Telerik.Reporting.Drawing.BorderType.None;
this.productNumberCaptionTextBox.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Left;
this.productNumberCaptionTextBox.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
this.productNumberCaptionTextBox.StyleName = "Caption";
this.productNumberCaptionTextBox.Value = "Product No.";
//
// nameCaptionTextBox
//
sortingAction2.SortingExpression = "= Fields.Name";
sortingAction2.Targets.AddRange(new Telerik.Reporting.IActionTarget[] {
this
});
this.nameCaptionTextBox.Action = sortingAction2;
this.nameCaptionTextBox.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.4000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.nameCaptionTextBox.Name = "nameCaptionTextBox";
this.nameCaptionTextBox.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(3.5D), Telerik.Reporting.Drawing.Unit.Inch(0.47992119193077087D));
this.nameCaptionTextBox.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Left;
this.nameCaptionTextBox.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
this.nameCaptionTextBox.StyleName = "Caption";
this.nameCaptionTextBox.Value = "Name";
//
// orderQtyCaptionTextBox
//
sortingAction3.SortingExpression = "= Fields.OrderQty";
sortingAction3.Targets.AddRange(new Telerik.Reporting.IActionTarget[] {
this
});
this.orderQtyCaptionTextBox.Action = sortingAction3;
this.orderQtyCaptionTextBox.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(4.9000792503356934D), Telerik.Reporting.Drawing.Unit.Inch(-1.2417634032146907E-08D));
this.orderQtyCaptionTextBox.Name = "orderQtyCaptionTextBox";
this.orderQtyCaptionTextBox.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.999882161617279D), Telerik.Reporting.Drawing.Unit.Inch(0.47992119193077087D));
this.orderQtyCaptionTextBox.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Left;
this.orderQtyCaptionTextBox.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
this.orderQtyCaptionTextBox.StyleName = "Caption";
this.orderQtyCaptionTextBox.Value = "Quantity";
//
// unitPriceCaptionTextBox
//
sortingAction4.SortingExpression = "= Fields.UnitPrice";
sortingAction4.Targets.AddRange(new Telerik.Reporting.IActionTarget[] {
this
});
this.unitPriceCaptionTextBox.Action = sortingAction4;
this.unitPriceCaptionTextBox.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.unitPriceCaptionTextBox.Name = "unitPriceCaptionTextBox";
this.unitPriceCaptionTextBox.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.0999211072921753D), Telerik.Reporting.Drawing.Unit.Inch(0.47992119193077087D));
this.unitPriceCaptionTextBox.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Left;
this.unitPriceCaptionTextBox.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
this.unitPriceCaptionTextBox.StyleName = "Caption";
this.unitPriceCaptionTextBox.Value = "Unit Price";
//
// lineTotalCaptionTextBox
//
sortingAction5.SortingExpression = "= Fields.LineTotal";
sortingAction5.Targets.AddRange(new Telerik.Reporting.IActionTarget[] {
this
});
this.lineTotalCaptionTextBox.Action = sortingAction5;
this.lineTotalCaptionTextBox.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(7D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.lineTotalCaptionTextBox.Name = "lineTotalCaptionTextBox";
this.lineTotalCaptionTextBox.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.0899604558944702D), Telerik.Reporting.Drawing.Unit.Inch(0.47992119193077087D));
this.lineTotalCaptionTextBox.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Left;
this.lineTotalCaptionTextBox.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
this.lineTotalCaptionTextBox.StyleName = "Caption";
this.lineTotalCaptionTextBox.Value = "Line Total";
//
// detail
//
this.detail.Height = Telerik.Reporting.Drawing.Unit.Inch(0.47999998927116394D);
this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.productNumberDataTextBox,
this.nameDataTextBox,
this.orderQtyDataTextBox,
this.unitPriceDataTextBox,
this.lineTotalDataTextBox
});
this.detail.Name = "detail";
//
// productNumberDataTextBox
//
this.productNumberDataTextBox.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.productNumberDataTextBox.Name = "productNumberDataTextBox";
this.productNumberDataTextBox.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.4000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0.47992119193077087D));
this.productNumberDataTextBox.Style.BorderStyle.Left = Telerik.Reporting.Drawing.BorderType.None;
this.productNumberDataTextBox.StyleName = "Data";
this.productNumberDataTextBox.Value = "=Fields.ProductNumber";
//
// nameDataTextBox
//
this.nameDataTextBox.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.4000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.nameDataTextBox.Name = "nameDataTextBox";
this.nameDataTextBox.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(3.4999992847442627D), Telerik.Reporting.Drawing.Unit.Inch(0.47992119193077087D));
this.nameDataTextBox.StyleName = "Data";
this.nameDataTextBox.Value = "=Fields.Name";
//
// orderQtyDataTextBox
//
this.orderQtyDataTextBox.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(4.9000787734985352D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.orderQtyDataTextBox.Name = "orderQtyDataTextBox";
this.orderQtyDataTextBox.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.99984258413314819D), Telerik.Reporting.Drawing.Unit.Inch(0.47992119193077087D));
this.orderQtyDataTextBox.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.orderQtyDataTextBox.StyleName = "Data";
this.orderQtyDataTextBox.Value = "=Fields.OrderQty";
//
// unitPriceDataTextBox
//
this.unitPriceDataTextBox.Format = "{0:C2}";
this.unitPriceDataTextBox.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(5.9000000953674316D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.unitPriceDataTextBox.Name = "unitPriceDataTextBox";
this.unitPriceDataTextBox.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.0999206304550171D), Telerik.Reporting.Drawing.Unit.Inch(0.47992119193077087D));
this.unitPriceDataTextBox.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.unitPriceDataTextBox.StyleName = "Data";
this.unitPriceDataTextBox.Value = "=Fields.UnitPrice";
//
// lineTotalDataTextBox
//
this.lineTotalDataTextBox.Format = "{0:C2}";
this.lineTotalDataTextBox.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(7D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.lineTotalDataTextBox.Name = "lineTotalDataTextBox";
this.lineTotalDataTextBox.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.0899215936660767D), Telerik.Reporting.Drawing.Unit.Inch(0.47992119193077087D));
this.lineTotalDataTextBox.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
this.lineTotalDataTextBox.StyleName = "Data";
this.lineTotalDataTextBox.Value = "=Fields.LineTotal";
//
// sqlDataSource1
//
this.sqlDataSource1.ConnectionString = "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString";
this.sqlDataSource1.Name = "sqlDataSource1";
this.sqlDataSource1.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
new Telerik.Reporting.SqlDataSourceParameter("@SalesOrderID", System.Data.DbType.Int32, "=Parameters.SalesOrderID.Value")
});
this.sqlDataSource1.SelectCommand = resources.GetString("sqlDataSource1.SelectCommand");
//
// reportHeaderSection1
//
this.reportHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.5D);
this.reportHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBox3
});
this.reportHeaderSection1.Name = "reportHeaderSection1";
//
// textBox3
//
this.textBox3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(3.9339065551757812E-05D));
this.textBox3.Name = "textBox3";
this.textBox3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(8.089961051940918D), Telerik.Reporting.Drawing.Unit.Inch(0.49996066093444824D));
this.textBox3.StyleName = "Title";
this.textBox3.Value = "Order Details";
//
// SalesOrderDetails
//
this.DataSource = this.sqlDataSource1;
this.Filters.Add(new Telerik.Reporting.Filter("=Fields.SalesOrderID", Telerik.Reporting.FilterOperator.Equal, "=Parameters.SalesOrderID.Value"));
group1.GroupFooter = this.labelsGroupFooter;
group1.GroupHeader = this.labelsGroupHeader;
group1.Name = "labelsGroup";
this.Groups.AddRange(new Telerik.Reporting.Group[] {
group1
});
this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.labelsGroupHeader,
this.labelsGroupFooter,
this.detail,
this.reportHeaderSection1
});
this.Name = "SalesOrderDetails";
this.PageSettings.Landscape = false;
this.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D));
this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter;
reportParameter1.Name = "SalesOrderID";
reportParameter1.Value = "=43860";
this.ReportParameters.Add(reportParameter1);
this.Style.BackgroundColor = System.Drawing.Color.White;
styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextItemBase)),
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.HtmlTextBox))
});
styleRule1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(2D);
styleRule1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D);
styleRule2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("Title")
});
styleRule2.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
styleRule2.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D);
styleRule2.Style.Font.Bold = true;
styleRule2.Style.Font.Name = "Segoe UI Light";
styleRule2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(16D);
styleRule2.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0D);
styleRule2.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
styleRule3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("Caption")
});
styleRule3.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(230)))), ((int)(((byte)(230)))), ((int)(((byte)(230)))));
styleRule3.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.None;
styleRule3.Style.BorderStyle.Left = Telerik.Reporting.Drawing.BorderType.Solid;
styleRule3.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(177)))), ((int)(((byte)(161)))), ((int)(((byte)(82)))));
styleRule3.Style.Font.Name = "Segoe UI";
styleRule3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(10D);
styleRule3.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Inch(0.079999998211860657D);
styleRule3.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0.10000000149011612D);
styleRule3.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Inch(0.10000000149011612D);
styleRule3.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Bottom;
styleRule4.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("Data")
});
styleRule4.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(230)))), ((int)(((byte)(230)))), ((int)(((byte)(230)))));
styleRule4.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.None;
styleRule4.Style.BorderStyle.Left = Telerik.Reporting.Drawing.BorderType.Solid;
styleRule4.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
styleRule4.Style.Font.Name = "Segoe UI";
styleRule4.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(10D);
styleRule4.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Inch(0.079999998211860657D);
styleRule4.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0.10000000149011612D);
styleRule4.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Inch(0.10000000149011612D);
styleRule4.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Bottom;
styleRule5.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("Total")
});
styleRule5.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid;
styleRule5.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.None;
styleRule5.Style.BorderStyle.Top = Telerik.Reporting.Drawing.BorderType.Solid;
styleRule5.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(0.5D);
styleRule5.Style.Font.Bold = true;
styleRule5.Style.Font.Name = "Segoe UI";
styleRule5.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(10D);
styleRule5.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Inch(0.079999998211860657D);
styleRule5.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Inch(0.10000000149011612D);
styleRule5.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Inch(0.10000000149011612D);
styleRule5.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Inch(0D);
styleRule5.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Bottom;
this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] {
styleRule1,
styleRule2,
styleRule3,
styleRule4,
styleRule5
});
this.Width = Telerik.Reporting.Drawing.Unit.Inch(8.09000015258789D);
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
public void InitializeComponent2()
{
Telerik.Reporting.Group group1 = new Telerik.Reporting.Group();
Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule2 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule3 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule4 = new Telerik.Reporting.Drawing.StyleRule();
Telerik.Reporting.Drawing.StyleRule styleRule5 = new Telerik.Reporting.Drawing.StyleRule();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// labelsGroupHeaderSection
//
GroupHeader.Height = Telerik.Reporting.Drawing.Unit.Inch(0.44166669249534607D);
GroupHeader.Name = "labelsGroupHeaderSection";
GroupHeader.PrintOnEveryPage = true;
//
// labelsGroupFooterSection
//
GroupFooter.Height = Telerik.Reporting.Drawing.Unit.Inch(0.28125D);
GroupFooter.Name = "labelsGroupFooterSection";
GroupFooter.Style.Visible = false;
//
// pageFooter
//
PageFooter.Height = Telerik.Reporting.Drawing.Unit.Inch(0.42083334922790527D);
PageFooter.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
CurrentTime,
PageInfo});
PageFooter.Name = "pageFooter";
//
// currentTimeTextBox
//
CurrentTime.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.02083333395421505D), Telerik.Reporting.Drawing.Unit.Inch(0.02083333395421505D));
CurrentTime.Name = "currentTimeTextBox";
CurrentTime.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.9791667461395264D), Telerik.Reporting.Drawing.Unit.Inch(0.40000000596046448D));
CurrentTime.StyleName = "PageInfo";
CurrentTime.Value = "=NOW()";
//
// pageInfoTextBox
//
PageInfo.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.0000789165496826D), Telerik.Reporting.Drawing.Unit.Inch(0.02083333395421505D));
PageInfo.Name = "pageInfoTextBox";
PageInfo.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(3.4374210834503174D), Telerik.Reporting.Drawing.Unit.Inch(0.40000000596046448D));
PageInfo.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;
PageInfo.StyleName = "PageInfo";
PageInfo.Value = "=PageNumber + \" of \"+PageCount";
//
// reportHeader
//
ReportHeader.Height = Telerik.Reporting.Drawing.Unit.Inch(0.80823493003845215D);
ReportHeader.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
TitleText});
ReportHeader.Name = "reportHeader";
//
// titleTextBox
//
TitleText.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0D));
TitleText.Name = "titleTextBox";
TitleText.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(6.4583334922790527D), Telerik.Reporting.Drawing.Unit.Inch(0.787401556968689D));
TitleText.StyleName = "Title";
//
// reportFooter
//
ReportFooter.Height = Telerik.Reporting.Drawing.Unit.Inch(0.28125D);
ReportFooter.Name = "reportFooter";
//
// detail
//
DetailSection.Height = Telerik.Reporting.Drawing.Unit.Inch(0.44166669249534607D);
DetailSection.Name = "detail";
//
// pageHeader
//
PageHeader.Height = Telerik.Reporting.Drawing.Unit.Inch(0.44166669249534607D);
PageHeader.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
ReportName});
PageHeader.Name = "pageHeader";
//
// reportNameTextBox
//
ReportName.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.02083333395421505D), Telerik.Reporting.Drawing.Unit.Inch(0.02083333395421505D));
ReportName.Name = "reportNameTextBox";
ReportName.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(6.4166665077209473D), Telerik.Reporting.Drawing.Unit.Inch(0.40000000596046448D));
ReportName.StyleName = "PageInfo";
//
// Report1
//
group1.GroupFooter = GroupFooter;
group1.GroupHeader = GroupHeader;
group1.Name = "labelsGroup";
this.Groups.AddRange(new Telerik.Reporting.Group[] {
group1});
this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
GroupHeader,
GroupFooter,
PageHeader,
PageFooter,
ReportHeader,
ReportFooter,
DetailSection});
this.Name = "Report1";
this.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Inch(1D), Telerik.Reporting.Drawing.Unit.Inch(1D), Telerik.Reporting.Drawing.Unit.Inch(1D), Telerik.Reporting.Drawing.Unit.Inch(1D));
this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter;
styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.TextItemBase)),
new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.HtmlTextBox))});
styleRule1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Point(2D);
styleRule1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Point(2D);
styleRule2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("Title")});
styleRule2.Style.Color = System.Drawing.Color.Black;
styleRule2.Style.Font.Bold = true;
styleRule2.Style.Font.Italic = false;
styleRule2.Style.Font.Name = "Tahoma";
styleRule2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(18D);
styleRule2.Style.Font.Strikeout = false;
styleRule2.Style.Font.Underline = false;
styleRule3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("Caption")});
styleRule3.Style.Color = System.Drawing.Color.Black;
styleRule3.Style.Font.Name = "Tahoma";
styleRule3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(10D);
styleRule3.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
styleRule4.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("Data")});
styleRule4.Style.Font.Name = "Tahoma";
styleRule4.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
styleRule4.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
styleRule5.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
new Telerik.Reporting.Drawing.StyleSelector("PageInfo")});
styleRule5.Style.Font.Name = "Tahoma";
styleRule5.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(8D);
styleRule5.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] {
styleRule1,
styleRule2,
styleRule3,
styleRule4,
styleRule5});
this.Width = Telerik.Reporting.Drawing.Unit.Inch(6.4583334922790527D);
((System.ComponentModel.ISupportInitialize)(this)).EndInit();
}
/// <summary>
/// Refreshes the data on the telerik report so new data can be added.
/// </summary>
public static void ResetDefaults()
{
for (int i = 0; i < count; i++)
{
MyDataBoxes[i].Value = "";
MyCaptionBoxes[i].Value = "";
MyDataBoxes[i] = new TextBox();
MyCaptionBoxes[i] = new TextBox();
AllGroups[i] = new Telerik.Reporting.Group();
}
for (int i = 0; i < 50; i++)
{
if (HeaderSections[i] != null)
{
HeaderSections[i].Items.Clear();
}
if (FooterSections[i] != null)
{
FooterSections[i].Items.Clear();
}
if (AllGroups[i] != null)
{
AllGroups[i].Groupings.Clear();
}
}
FilterCount = 0;
GroupCount = 0;
GroupLoc = 0.14083333395421505D;
Detail.Items.Clear();
count = 0;
CapLocX = 1.2666666507720947D;
}
public static void GenerateHeaderFooters()
{
for (int i = 0; i < 50; i++)
{
HeaderSections[i] = new GroupHeaderSection();
FooterSections[i] = new GroupFooterSection();
AllGroups[i] = new Telerik.Reporting.Group();
HeaderSections[i].Height = Unit.Inch(TBHeight);
HeaderSections[i].Style.BackgroundColor = Color.FromArgb(224, 224, 224);
FooterSections[i].Height = Unit.Inch(TBHeight);
AllGroups[i].GroupFooter = FooterSections[i];
AllGroups[i].GroupHeader = HeaderSections[i];
}
}
/// <summary>
/// Builds the report.
/// </summary>
/// <param name="reportDocument">The report document.</param>
public void BuildReport(ICustomReport reportDocument)
{
var currentReport = reportDocument.Reports.First();
SetIdentity(currentReport);
//_originalPageHeaderHeight = ((PageHeaderSection) currentReport.Items["pageHeader"]).Height;
//This report parameter holds the current template system name.
_processName = currentReport.ReportParameters["processName"].Value.ToString();
//This report parameter holds the currently visible columns of the grid and in what order they're in
var cols = currentReport.ReportParameters["columns"].Value.ToString();
var columns = cols.Split(';').ToList();
_columns = new List<ColumnInfo>();
foreach (var col in columns)
{
_columns.Add(new ColumnInfo(col));
}
var groupsStr = currentReport.ReportParameters["groups"].Value.ToString();
_groups = (string.IsNullOrEmpty(groupsStr) ? new string[0] : groupsStr.Split(';')).ToList();
//TODO: Uncomment if needed
// _columns.AddRange(_groups);
if (reportDocument.FitToPage)
{
if (currentReport.GetType().Name.ToLower().Contains("landscape"))
{
FitToPageColumnWidth = Math.Min(1, 10.0 / _columns.Count);
FitToPageColumnCount = (short) Math.Max(10, _columns.Count);
}
if (currentReport.GetType().Name.ToLower().Contains("portrait"))
{
FitToPageColumnWidth = Math.Min(1.1, 7.0 / _columns.Count);
FitToPageColumnCount = (short) Math.Max(7, _columns.Count);
}
currentReport.Width = new Unit(_columns.Count * FitToPageColumnWidth, UnitType.Inch);
}
_groupColumn = currentReport.ReportParameters["groupColumn"].Value.ToString();
var fldList = new List<FieldInfo>(_columns.Count);
var processProperties = new Dictionary<PropertyInfo, string>();
var processType = TheDynamicTypeManager.GetInfoType<IInfoClass>(_processName);
if (processType != null)
{
processProperties = processType.GetAllPropertiesWithPaths();
var properties = processProperties.Where(p => _columns.Any(c=>c.SystemName == p.Value));
foreach (var column in _columns)
{
foreach (var property in properties)
{
if (property.Value == column.SystemName)
{
fldList.Add(new FieldInfo(property.Key, column));
break;
}
}
}
_fieldAttrDict = GetFieldAttributes(processProperties.Select(x => x.Key));
}
if (_fieldAttrDict == null)
_fieldAttrDict = new Dictionary<PropertyInfo, FieldParametres>();
_colDict = new SortedDictionary<int, string[]>();
//Grouping
foreach (var colName in _groups)
{
var group = new Telerik.Reporting.Group();
group.Name = colName;
var groupHeaderSection = new GroupHeaderSection();
var groupFooterSection = new GroupFooterSection();
group.GroupHeader = groupHeaderSection;
group.GroupFooter = groupFooterSection;
var txt = new TextBox();
txt.Style.Font.Size = new Unit(10, UnitType.Point);
txt.Style.Font.Bold = true;
txt.Style.BackgroundColor = Color.FromArgb(255, 225, 225, 225);
txt.Style.TextAlign = HorizontalAlign.Left;
txt.Style.VerticalAlign = VerticalAlign.Middle;
groupHeaderSection.Items.Add(txt);
groupHeaderSection.Height = new Unit(21);
groupHeaderSection.Style.BorderStyle.Default = BorderType.Solid;
groupHeaderSection.Style.BorderColor.Default = Color.White;
groupHeaderSection.Style.BorderColor.Left = Color.Transparent;
var panel = new Panel();
panel.Height = new Unit(20);
panel.Style.LineStyle = LineStyle.Solid;
panel.Style.LineWidth = new Unit(2.0);
panel.Style.BorderColor.Default = Color.Black;
panel.Style.BorderWidth.Default = new Unit(2.0);
panel.Style.BorderStyle.Default = BorderType.None;
panel.Style.BorderStyle.Top = BorderType.Solid;
panel.Style.BorderStyle.Bottom = BorderType.Solid;
groupFooterSection.Items.Add(panel);
groupFooterSection.Height = new Unit(25);
//groupFooterSection.Style.BorderStyle.Default = BorderType.Solid;
//groupFooterSection.Style.BorderColor.Default = Color.White;
groupFooterSection.Style.BorderColor.Left = Color.Transparent;
groupFooterSection.Style.Padding.Top = new Unit(2);
groupFooterSection.Style.Padding.Bottom = new Unit(2);
//if you need to filter the data, apply filtering
//group1.Filters.Add(new Telerik.Reporting.Data.Filter("=Fields.ProductID", Telerik.Reporting.Data.FilterOperator.Equal, "=10"));
currentReport.Groups.Add(group);
}
var aggregateData = currentReport.ReportParameters["aggregates"].Value.ToString();
_aggregateDict = ParseAggregateData(aggregateData);
var nextLeft = _groups.Count > 0 ? (_groups.Count - 1) * 0.15 : 0;
var availableWidth = currentReport.Width.Value - nextLeft;
var ctrlSize = availableWidth / (fldList.Count() - _groups.Count);
_indentOffset = 0;
_reportItemCounter = new Dictionary<string, int>();
var counter = 0;
double fitToPageFooterLocationX = 0;
//posess fields
foreach (var fld in fldList)
{
if (_reportItemCounter.ContainsKey(fld.Property.Name))
{
continue;
}
var fieldValueMap = GetFieldValueMap(currentReport, fld.Property, processProperties[fld.Property]);
if (_groups.Contains(processProperties[fld.Property] ?? string.Empty))
{
//create group
var fieldGroup = currentReport.Groups.FirstOrDefault(x => x.Name == processProperties[fld.Property]);
if (fieldGroup != null)
{
_indentOffset = 0.15 * _groups.IndexOf(processProperties[fld.Property]);
fieldGroup.Groupings.Add(new Grouping(fieldValueMap));
((TextBox)fieldGroup.GroupHeader.Items[0]).Value = string.Format("=' ' + {0} + ' Total: ' + Exec('{1}', Count(IsNull({0},1)))", fieldValueMap.TrimStart('='), fieldGroup.Name);
((TextBox)fieldGroup.GroupHeader.Items[0]).Location = new PointU(new Unit(_indentOffset, UnitType.Inch), new Unit(0, UnitType.Inch));
((TextBox)fieldGroup.GroupHeader.Items[0]).Size = new SizeU(new Unit(currentReport.Width.Value - _indentOffset, UnitType.Inch), new Unit(20, UnitType.Pixel));
//AddGroupLevelLines(fieldGroup.GroupHeader.Items);
((Panel)fieldGroup.GroupFooter.Items[0]).Location = new PointU(new Unit(_indentOffset, UnitType.Inch), new Unit(0, UnitType.Inch));
((Panel)fieldGroup.GroupFooter.Items[0]).Size = new SizeU(new Unit(currentReport.Width.Value - _indentOffset, UnitType.Inch), new Unit(20, UnitType.Pixel));
//AddGroupLevelLines(fieldGroup.GroupFooter.Items);
}
continue;
}
var cPoint = new PointU(new Unit(nextLeft, UnitType.Inch), new Unit(0.4, UnitType.Inch));
var uSize = new SizeU(new Unit(ctrlSize, UnitType.Inch), new Unit(0.2, UnitType.Inch));
var attr = fld.Property.GetCustomAttributes(false);
var displayAttr = attr.FirstOrDefault(x => x is DisplayAttribute) as DisplayAttribute;
string colName = "<NoName>";
if (displayAttr == null)
{
colName = fld.Column.Header;
//var infoInstance = Activator.CreateInstance(processType);
//if (infoInstance != null)
//{
// var field = processType.GetField(fld.Name + "Property");
// if (field != null)
// {
// var fieldValue = field.GetValue(infoInstance) as IPropertyInfo;
// if (fieldValue != null)
// {
// colName = fieldValue.FriendlyName;
// }
// }
//}
}
else
{
colName = displayAttr.GetName();
}
var headerLabel = new TextBox { Value = colName, Location = cPoint, Size = uSize, StyleName = "Caption", Multiline = true, CanGrow = true };
headerLabel.Style.BackgroundColor = Color.Transparent;
headerLabel.Style.Font.Size = new Unit(10, UnitType.Point);
headerLabel.Style.VerticalAlign = VerticalAlign.Top;
var dataTextBox = new TextBox();
var dataTextBoxName = string.Format("{0}TextBox", processProperties[fld.Property]);
dataTextBox.Name = dataTextBoxName;
var propertyName = processProperties[fld.Property];
var isExistsBackgroudColor = processProperties.Any(x => x.Key.Name == propertyName + Constants.FieldBackColorPostfix);
dataTextBox.TextWrap = true;
dataTextBox.Location = new PointU(new Unit(nextLeft, UnitType.Inch), new Unit(0, UnitType.Inch));
dataTextBox.Size = uSize;
dataTextBox.CanGrow = true;
if (isExistsBackgroudColor)
{
if (fieldValueMap.StartsWith("="))
{
fieldValueMap = fieldValueMap.Remove(0, 1);
fieldValueMap = string.Format("=GetValueWithBackgroundColor({0}, Fields.[{1}{2}])", fieldValueMap, processProperties[fld.Property], Constants.FieldBackColorPostfix);
EventHandler itemDataBoundHandler = (sender, args) =>
{
var textBox = sender as Telerik.Reporting.Processing.TextBox;
if (textBox == null)
{
return;
}
var colorAsLong = ((KeyValuePair<object, long>)textBox.Value).Value;
if (colorAsLong != 0)
{
var bytes = BitConverter.GetBytes(colorAsLong);
if (bytes[3] == 0) bytes[3] = 255;
var color = Color.FromArgb(bytes[3], bytes[2], bytes[1], bytes[0]);
((Telerik.Reporting.Processing.ProcessingElement)sender).Style.BackgroundColor = color;
}
textBox.Value = ((KeyValuePair<object, long>)textBox.Value).Key;
};
dataTextBox.ItemDataBound += itemDataBoundHandler;
EventHandler dataTextBoxDisposedHandler = null;
dataTextBoxDisposedHandler = (sender, args) =>
{
dataTextBox.ItemDataBound -= itemDataBoundHandler;
dataTextBox.Disposed -= dataTextBoxDisposedHandler;
};
dataTextBox.Disposed += dataTextBoxDisposedHandler;
}
}
dataTextBox.Value = fieldValueMap;
if (!reportDocument.FitToPage)
{
dataTextBox.ItemDataBound += OnItemDataBound;
EventHandler dataTextBoxDisposedHandler = null;
dataTextBoxDisposedHandler = (sender, args) =>
{
dataTextBox.ItemDataBound -= OnItemDataBound;
dataTextBox.Disposed -= dataTextBoxDisposedHandler;
};
dataTextBox.Disposed += dataTextBoxDisposedHandler;
}
var pictureBox = new PictureBox { Value = fieldValueMap };
pictureBox.Name = string.Format("{0}TextBox", processProperties[fld.Property]);
pictureBox.Sizing = ImageSizeMode.ScaleProportional;
if (!reportDocument.FitToPage)
{
pictureBox.ItemDataBound += OnItemDataBound;
EventHandler pictureBoxDisposedHandler = null;
pictureBoxDisposedHandler = (sender, args) =>
{
pictureBox.ItemDataBound -= OnItemDataBound;
pictureBox.Disposed -= pictureBoxDisposedHandler;
};
pictureBox.Disposed += pictureBoxDisposedHandler;
}
nextLeft = nextLeft + ctrlSize;
if (reportDocument.FitToPage)
{
currentReport.Items["labelsGroupHeaderSection"].Items.Add(headerLabel);
}
else
{
currentReport.Items["pageHeader"].Items.Add(headerLabel);
}
if (_fieldAttrDict[fld.Property].FieldEditor == "Image")
{
currentReport.Items["detail"].Items["rowPanel"].Items.Add(pictureBox);
}
else
{
currentReport.Items["detail"].Items["rowPanel"].Items.Add(dataTextBox);
}
_reportItemCounter.Add(processProperties[fld.Property], 0);
if (reportDocument.FitToPage)
{
_colDict.Add(currentReport.Items["labelsGroupHeaderSection"].Items.Count - 1, new[] { processProperties[fld.Property], headerLabel.Value });
}
else
{
_colDict.Add(currentReport.Items["pageHeader"].Items.Count - 1, new[] { processProperties[fld.Property], headerLabel.Value });
}
if (reportDocument.FitToPage)
{
fitToPageFooterLocationX = counter % FitToPageColumnCount == 0 ? 0 : fitToPageFooterLocationX;
if (_aggregateDict.Keys.All(x => x != fld.Property.Name))
{
var footerTextBox = new TextBox
{
Name = string.Format("{0}{1}FooterTextBox", fld.Property.Name, fldList.IndexOf(fld)),
Location = new PointU(new Unit(fitToPageFooterLocationX, UnitType.Inch), new Unit(0, UnitType.Inch)),
Size = new SizeU(new Unit(FitToPageColumnWidth, UnitType.Inch), new Unit(0.15, UnitType.Inch))
};
currentReport.Items["pageFooter"].Items.Add(footerTextBox);
}
//calculate server-side aggregates
var aggregateDefinitions = _aggregateDict.ToList()
.SelectMany(i => i.Value)
.Where(d => !AggregateHelper.IsPageAggregateType(d.SummaryType))
.ToList();
var queryCriteria = new AggregateDataSourceQueryCriteria
{
ProcessName = _processName,
FilterDefinition = GetFilterDefinition(currentReport)
};
var serverAggregateResults = AggregateProcessor.CalculateAggregates(aggregateDefinitions, queryCriteria);
foreach (var aggregateItem in _aggregateDict)
{
if (aggregateItem.Key != fld.Property.Name)
{
continue;
}
double fitToPageFooterLocationY = 0;
for (var i = 0; i < aggregateItem.Value.Count; i++)
{
var footerTextBox = new TextBox
{
Name = string.Format("{0}{1}FooterTextBox", fld.Property.Name, aggregateItem.Value[i].SummaryType), // telerik recommends set unique names for all controls
Size = new SizeU(new Unit(GetWidthFitToPage(fld.Property.Name, i), UnitType.Inch), new Unit(0.15, UnitType.Inch)),
Location = new PointU(new Unit(fitToPageFooterLocationX, UnitType.Inch), new Unit(fitToPageFooterLocationY, UnitType.Inch))
};
if (AggregateHelper.IsPageAggregateType(aggregateItem.Value[i].SummaryType))
{
footerTextBox.Value = string.Format(@"='{0}: ' + AfterCalculateAggregates(PageExec('{1}TextBox', {2}(BeforeCalculateAggregates(Fields.[{1}], ""{2}"", ""{3}"", ""{4}"", ""{5}"", ""{6}""))), ""{2}"", ""{3}"", ""{4}"", ""{5}"", ""{6}"")",
AggregateProcessor.GetAggregateFunctionShortName(aggregateItem.Value[i].SummaryType), aggregateItem.Key, aggregateItem.Value[i].SummaryType, aggregateItem.Value[i].CustomConverter, aggregateItem.Value[i].TargetType, aggregateItem.Value[i].TypeName, aggregateItem.Value[i].ConverterParameter);
}
else
{
var result = serverAggregateResults.FirstOrDefault(r => r.ColumnName == aggregateItem.Key && r.SummaryType == aggregateItem.Value[i].SummaryType);
footerTextBox.Value = string.Format("{0}: {1}", AggregateHelper.GetAttribute(aggregateItem.Value[i].SummaryType).ShortName, result != null ? result.Value : Constants.Empty);
}
if (aggregateItem.Value[i].SummaryType == SummaryTypes.Count)
{
footerTextBox.Bindings.Add(new Binding("Visible", string.Format(@"=IIf(PageExec(""{0}"", Count(Fields.{1})) = 0, False, True)", dataTextBoxName, fld.Property.Name)));
}
if (aggregateItem.Value[i].SummaryType == SummaryTypes.Min || aggregateItem.Value[i].SummaryType == SummaryTypes.Max)
{
if (fld.Property.PropertyType != typeof(bool) && fld.Property.PropertyType != typeof(bool?))//VRN-5079
{
footerTextBox.Bindings.Add(new Binding("Visible", string.Format(@"=FooterTextBoxVisibilityWithValue(PageExec(""{0}"", Min(Fields.{1})))", dataTextBoxName, fld.Property.Name)));
}
}
fitToPageFooterLocationY += 0.15;
currentReport.Items["pageFooter"].Items.Add(footerTextBox);
}
}
fitToPageFooterLocationX += FitToPageColumnWidth;
counter++;
}
}
if (reportDocument.FitToPage)
{
var max = _aggregateDict.Count == 0 ? 0 : _aggregateDict.Max(x => x.Value.Count);
if (max != 0)
{
((PageFooterSection) currentReport.Items["pageFooter"]).Height = new Unit(max*0.15 + 0.2, UnitType.Inch);
}
currentReport.Items["pageFooter"].Items["currentTimeTextBox"].Visible = false;
currentReport.Items["pageFooter"].Items["pageInfoTextBox"].Visible = false;
}
_indentOffset = _groups.Count > 0 ? (_groups.Count - 1) * 0.15 : 0;
//AddGroupLevelLines(currentReport.Items["detail"].Items["rowPanel"].Items);
}