This is a migrated thread and some comments may be shown as answers.

Report Preview giving error under developed under Visual studio 2010

4 Answers 101 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

Nirmal asked on 26 Apr 2013, 12:29 PM

Hi All,

I am new to telerik view, I have been trying to learn it and followed the telerik video to design a Sales Dashboard Report.

After I complete the Cross tab report and want to see the report designed so far and click Preview, I am encountering the below error:
Do not know what is the problem. The Error is as below:
"An error has occurred while processing Table 'crosstab1': Value of Top/Bootom filters evaluate to integer"

Please find the code generated by the designer below:
namespace ReportsLibrary
{
partial class DashboardReport
{
#region Component Designer generated code
/// <summary>
/// Required method for telerik Reporting designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(DashboardReport));
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.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter();
Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule();
this.textBox7 = new Telerik.Reporting.TextBox();
this.textBox9 = new Telerik.Reporting.TextBox();
this.textBox8 = new Telerik.Reporting.TextBox();
this.yeardatasource = new Telerik.Reporting.SqlDataSource();
this.pageHeaderSection1 = new Telerik.Reporting.PageHeaderSection();
this.textBox1 = new Telerik.Reporting.TextBox();
this.pictureBox1 = new Telerik.Reporting.PictureBox();
this.textBox4 = new Telerik.Reporting.TextBox();
this.detail = new Telerik.Reporting.DetailSection();
this.textBox2 = new Telerik.Reporting.TextBox();
this.crosstab1 = new Telerik.Reporting.Crosstab();
this.textBox6 = new Telerik.Reporting.TextBox();
this.textBox10 = new Telerik.Reporting.TextBox();
this.textBox5 = new Telerik.Reporting.TextBox();
this.SalesPersonDatasource = new Telerik.Reporting.SqlDataSource();
this.pageFooterSection1 = new Telerik.Reporting.PageFooterSection();
this.textBox3 = new Telerik.Reporting.TextBox();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// textBox7
//
this.textBox7.Name = "textBox7";
this.textBox7.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1D), Telerik.Reporting.Drawing.Unit.Inch(0.5D));
this.textBox7.Value = "= \'Q\' + ReportsLibrary.DashboardReport.Qtr(Fields.OrderDate)";
//
// textBox9
//
this.textBox9.Name = "textBox9";
this.textBox9.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2D), Telerik.Reporting.Drawing.Unit.Inch(0.5D));
this.textBox9.StyleName = "";
this.textBox9.Value = "Total";
//
// textBox8
//
this.textBox8.Name = "textBox8";
this.textBox8.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1D), Telerik.Reporting.Drawing.Unit.Inch(0.5D));
this.textBox8.Value = "= Fields.SalesPersonFullName";
//
// yeardatasource
//
this.yeardatasource.ConnectionString = "ReportsLibrary.Properties.Settings.AdventureWorks";
this.yeardatasource.Name = "yeardatasource";
this.yeardatasource.SelectCommand = "SELECT \r\n Distinct YEAR(OrderDate) as YEAR\r\n FROM Sales.SalesOrderHeader so\r\nOR" +
"DER BY YEAR asc\r\n ";
//
// pageHeaderSection1
//
this.pageHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.90000009536743164D);
this.pageHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBox1,
this.pictureBox1,
this.textBox4});
this.pageHeaderSection1.Name = "pageHeaderSection1";
//
// textBox1
//
this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), 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(5.9999213218688965D), Telerik.Reporting.Drawing.Unit.Inch(0.60000008344650269D));
this.textBox1.Style.BackgroundColor = System.Drawing.Color.White;
this.textBox1.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(135)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
this.textBox1.Style.Font.Name = "Arial Black";
this.textBox1.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(30D);
this.textBox1.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
this.textBox1.Value = "Quarterly Sales";
//
// pictureBox1
//
this.pictureBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(3.9378803194267675E-05D));
this.pictureBox1.MimeType = "image/bmp";
this.pictureBox1.Name = "pictureBox1";
this.pictureBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.0999606847763062D), Telerik.Reporting.Drawing.Unit.Inch(0.60000008344650269D));
this.pictureBox1.Value = ((object)(resources.GetObject("pictureBox1.Value")));
//
// textBox4
//
this.textBox4.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.60011816024780273D));
this.textBox4.Name = "textBox4";
this.textBox4.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(5.9999213218688965D), Telerik.Reporting.Drawing.Unit.Inch(0.19988186657428742D));
this.textBox4.Style.BackgroundColor = System.Drawing.Color.Silver;
this.textBox4.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(135)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
this.textBox4.Style.Font.Name = "Arial Black";
this.textBox4.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(10D);
this.textBox4.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
this.textBox4.Value = "(Internal Use Only)";
//
// detail
//
this.detail.Height = Telerik.Reporting.Drawing.Unit.Inch(2D);
this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBox2,
this.crosstab1});
this.detail.Name = "detail";
//
// textBox2
//
this.textBox2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
this.textBox2.Name = "textBox2";
this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(5.7999610900878906D), Telerik.Reporting.Drawing.Unit.Inch(0.3999999463558197D));
this.textBox2.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(135)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
this.textBox2.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(0)))), ((int)(((byte)(64)))));
this.textBox2.Style.Font.Name = "Arial Black";
this.textBox2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(16D);
this.textBox2.Value = "Top 5 Performing Agents";
//
// crosstab1
//
this.crosstab1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(1D)));
this.crosstab1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(2D)));
this.crosstab1.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(Telerik.Reporting.Drawing.Unit.Inch(0.5D)));
this.crosstab1.Body.SetCellContent(0, 0, this.textBox6);
this.crosstab1.Body.SetCellContent(0, 1, this.textBox10);
tableGroup1.Groupings.Add(new Telerik.Reporting.Grouping("= ReportsLibrary.DashboardReport.Qtr(Fields.OrderDate)"));
tableGroup1.Name = "Quarter";
tableGroup1.ReportItem = this.textBox7;
tableGroup1.Sortings.Add(new Telerik.Reporting.Sorting("= ReportsLibrary.DashboardReport.Qtr(Fields.OrderDate)", Telerik.Reporting.SortDirection.Asc));
//tableGroup2.Name = "Group1";
tableGroup2.ReportItem = this.textBox9;
this.crosstab1.ColumnGroups.Add(tableGroup1);
this.crosstab1.ColumnGroups.Add(tableGroup2);
this.crosstab1.Corner.SetCellContent(0, 0, this.textBox5);
this.crosstab1.DataSource = this.SalesPersonDatasource;
this.crosstab1.Filters.Add(new Telerik.Reporting.Filter("=Fields.OrderDate.Year", Telerik.Reporting.FilterOperator.Equal, "=Parameters.ReportYear.Value"));
this.crosstab1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBox6,
this.textBox10,
this.textBox7,
this.textBox9,
this.textBox5,
this.textBox8});
this.crosstab1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(0.40011820197105408D));
this.crosstab1.Name = "crosstab1";
tableGroup3.Filters.Add(new Telerik.Reporting.Filter("= Sum(Fields.SubTotal)", Telerik.Reporting.FilterOperator.TopN, "5"));
tableGroup3.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.SalesPersonFullName"));
tableGroup3.Name = "SalesPersonFullName";
tableGroup3.ReportItem = this.textBox8;
tableGroup3.Sortings.Add(new Telerik.Reporting.Sorting("= Sum(Fields.SubTotal)", Telerik.Reporting.SortDirection.Desc));
this.crosstab1.RowGroups.Add(tableGroup3);
this.crosstab1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(4D), Telerik.Reporting.Drawing.Unit.Inch(1D));
//
// textBox6
//
this.textBox6.Format = "{0:#.}";
this.textBox6.Name = "textBox6";
this.textBox6.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1D), Telerik.Reporting.Drawing.Unit.Inch(0.5D));
this.textBox6.Value = "= Sum(Fields.SubTotal) / 1000.0";
//
// textBox10
//
this.textBox10.Name = "textBox10";
this.textBox10.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2D), Telerik.Reporting.Drawing.Unit.Inch(0.5D));
this.textBox10.StyleName = "";
this.textBox10.Value = "= Sum(Fields.SubTotal) / 1000.0";
//
// textBox5
//
this.textBox5.Name = "textBox5";
this.textBox5.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1D), Telerik.Reporting.Drawing.Unit.Inch(0.5D));
this.textBox5.Value = "Sales Person ";
//
// SalesPersonDatasource
//
this.SalesPersonDatasource.ConnectionString = "ReportsLibrary.Properties.Settings.AdventureWorks";
this.SalesPersonDatasource.Name = "SalesPersonDatasource";
this.SalesPersonDatasource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
new Telerik.Reporting.SqlDataSourceParameter("@ReportYear", System.Data.DbType.Int32, "=Parameters.ReportYear.Value")});
this.SalesPersonDatasource.SelectCommand = resources.GetString("SalesPersonDatasource.SelectCommand");
//
// pageFooterSection1
//
this.pageFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(2D);
this.pageFooterSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBox3});
this.pageFooterSection1.Name = "pageFooterSection1";
//
// textBox3
//
this.textBox3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
this.textBox3.Name = "textBox3";
this.textBox3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(5.7999610900878906D), Telerik.Reporting.Drawing.Unit.Inch(0.3999999463558197D));
this.textBox3.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(135)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
this.textBox3.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(0)))), ((int)(((byte)(64)))));
this.textBox3.Style.Font.Name = "Arial Black";
this.textBox3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(16D);
this.textBox3.Value = "Top 5 Performing Stores";
//
// DashboardReport
//
this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.pageHeaderSection1,
this.detail,
this.pageFooterSection1});
this.Name = "DashboardReport";
this.PageSettings.Landscape = true;
this.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Inch(0.30000001192092896D), Telerik.Reporting.Drawing.Unit.Inch(1D), Telerik.Reporting.Drawing.Unit.Inch(0.40000000596046448D), Telerik.Reporting.Drawing.Unit.Inch(1D));
this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter;
reportParameter1.AutoRefresh = true;
reportParameter1.AvailableValues.DataSource = this.yeardatasource;
reportParameter1.AvailableValues.DisplayMember = "= Fields.YEAR";
reportParameter1.AvailableValues.ValueMember = "= Fields.YEAR";
reportParameter1.Name = "ReportYear";
reportParameter1.Text = "Sales for Year";
reportParameter1.Type = Telerik.Reporting.ReportParameterType.Integer;
reportParameter1.Value = "2001";
reportParameter1.Visible = true;
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);
this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] {
styleRule1});
this.Width = Telerik.Reporting.Drawing.Unit.Inch(6D);
((System.ComponentModel.ISupportInitialize)(this)).EndInit();

}
#endregion

private Telerik.Reporting.PageHeaderSection pageHeaderSection1;
private Telerik.Reporting.DetailSection detail;
private Telerik.Reporting.PageFooterSection pageFooterSection1;
private Telerik.Reporting.TextBox textBox1;
private Telerik.Reporting.PictureBox pictureBox1;
private Telerik.Reporting.TextBox textBox4;
private Telerik.Reporting.TextBox textBox2;
private Telerik.Reporting.TextBox textBox3;
private Telerik.Reporting.SqlDataSource yeardatasource;
private Telerik.Reporting.Crosstab crosstab1;
private Telerik.Reporting.TextBox textBox6;
private Telerik.Reporting.TextBox textBox7;
private Telerik.Reporting.TextBox textBox5;
private Telerik.Reporting.SqlDataSource SalesPersonDatasource;
private Telerik.Reporting.TextBox textBox8;
private Telerik.Reporting.TextBox textBox10;
private Telerik.Reporting.TextBox textBox9;
}
}

Please the attached code for the userdefined function Qtr(Quarter).
namespace ReportsLibrary
{
using System;
using System.ComponentModel;
using System.Drawing;
using System.Windows.Forms;
using Telerik.Reporting;
using Telerik.Reporting.Drawing;

/// <summary>
/// Summary description for DashboardReport.
/// </summary>
public partial class DashboardReport : Telerik.Reporting.Report
{
public DashboardReport()
{
//
// Required for telerik Reporting designer support
//
InitializeComponent();

//
// TODO: Add any constructor code after InitializeComponent call
//
}
public static int Qtr(DateTime date)
{
return (1 + ((date.Month - 1) / 3));
}
}
}

Thanks in advance.

Rgds,
Nirmal

4 Answers, 1 is accepted

answered on 29 Apr 2013, 01:11 AM

ReportPreviewErrorScreenShot.png

Hi,

This is another issue: The Issue is while doing a report preview I am getting error as depicted in the screen shot attached along with the code the designer generates.

I copied the existing Pie Chart and changed the property to make a stacked chart and changed the datasource also.

When I build and preview the report, the stacked report gives the error.

Le me know what is causing the error and also if I want to change the legend / Bar colors how do i do it. Please refer any document there as good reference for all the above issues.

Thanks in advance. Appreciate, if you can send me the resolutions ASAP.
The code generated by the designer is s below:

namespace ReportsLibrary
{
partial class DashboardReport
{
#region Component Designer generated code
/// <summary>
/// Required method for telerik Reporting designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(DashboardReport));
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.Charting.Palette palette1 = new Telerik.Reporting.Charting.Palette();
Telerik.Reporting.Charting.PaletteItem paletteItem1 = new Telerik.Reporting.Charting.PaletteItem();
Telerik.Reporting.Charting.PaletteItem paletteItem2 = new Telerik.Reporting.Charting.PaletteItem();
Telerik.Reporting.Charting.PaletteItem paletteItem3 = new Telerik.Reporting.Charting.PaletteItem();
Telerik.Reporting.Charting.PaletteItem paletteItem4 = new Telerik.Reporting.Charting.PaletteItem();
Telerik.Reporting.Charting.PaletteItem paletteItem5 = new Telerik.Reporting.Charting.PaletteItem();
Telerik.Reporting.Charting.Styles.ChartMargins chartMargins1 = new Telerik.Reporting.Charting.Styles.ChartMargins();
Telerik.Reporting.Charting.ChartSeries chartSeries1 = new Telerik.Reporting.Charting.ChartSeries();
Telerik.Reporting.Charting.Palette palette2 = new Telerik.Reporting.Charting.Palette();
Telerik.Reporting.Charting.PaletteItem paletteItem6 = new Telerik.Reporting.Charting.PaletteItem();
Telerik.Reporting.Charting.PaletteItem paletteItem7 = new Telerik.Reporting.Charting.PaletteItem();
Telerik.Reporting.Charting.PaletteItem paletteItem8 = new Telerik.Reporting.Charting.PaletteItem();
Telerik.Reporting.Charting.PaletteItem paletteItem9 = new Telerik.Reporting.Charting.PaletteItem();
Telerik.Reporting.Charting.PaletteItem paletteItem10 = new Telerik.Reporting.Charting.PaletteItem();
Telerik.Reporting.Charting.Styles.ChartMargins chartMargins2 = new Telerik.Reporting.Charting.Styles.ChartMargins();
Telerik.Reporting.Charting.ChartSeries chartSeries2 = new Telerik.Reporting.Charting.ChartSeries();
Telerik.Reporting.Charting.Palette palette3 = new Telerik.Reporting.Charting.Palette();
Telerik.Reporting.Charting.PaletteItem paletteItem11 = new Telerik.Reporting.Charting.PaletteItem();
Telerik.Reporting.Charting.PaletteItem paletteItem12 = new Telerik.Reporting.Charting.PaletteItem();
Telerik.Reporting.Charting.PaletteItem paletteItem13 = new Telerik.Reporting.Charting.PaletteItem();
Telerik.Reporting.Charting.PaletteItem paletteItem14 = new Telerik.Reporting.Charting.PaletteItem();
Telerik.Reporting.Charting.PaletteItem paletteItem15 = new Telerik.Reporting.Charting.PaletteItem();
Telerik.Reporting.Charting.Styles.ChartMargins chartMargins3 = new Telerik.Reporting.Charting.Styles.ChartMargins();
Telerik.Reporting.Charting.ChartSeries chartSeries3 = new Telerik.Reporting.Charting.ChartSeries();
Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter();
Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule();
this.textBox7 = new Telerik.Reporting.TextBox();
this.textBox9 = new Telerik.Reporting.TextBox();
this.textBox8 = new Telerik.Reporting.TextBox();
this.yeardatasource = new Telerik.Reporting.SqlDataSource();
this.textBox17 = new Telerik.Reporting.TextBox();
this.textBox18 = new Telerik.Reporting.TextBox();
this.textBox20 = new Telerik.Reporting.TextBox();
this.pageHeaderSection1 = new Telerik.Reporting.PageHeaderSection();
this.textBox1 = new Telerik.Reporting.TextBox();
this.pictureBox1 = new Telerik.Reporting.PictureBox();
this.textBox4 = new Telerik.Reporting.TextBox();
this.detail = new Telerik.Reporting.DetailSection();
this.textBox2 = new Telerik.Reporting.TextBox();
this.crosstab1 = new Telerik.Reporting.Crosstab();
this.textBox6 = new Telerik.Reporting.TextBox();
this.textBox10 = new Telerik.Reporting.TextBox();
this.textBox5 = new Telerik.Reporting.TextBox();
this.SalesPersonDatasource = new Telerik.Reporting.SqlDataSource();
this.textBox11 = new Telerik.Reporting.TextBox();
this.textBox12 = new Telerik.Reporting.TextBox();
this.textBox13 = new Telerik.Reporting.TextBox();
this.chart2 = new Telerik.Reporting.Chart();
this.SalesPersonYChartDataSource = new Telerik.Reporting.SqlDataSource();
this.textBox3 = new Telerik.Reporting.TextBox();
this.textBox14 = new Telerik.Reporting.TextBox();
this.chart3 = new Telerik.Reporting.Chart();
this.StoresYChartDataSource = new Telerik.Reporting.SqlDataSource();
this.textBox21 = new Telerik.Reporting.TextBox();
this.SalesPersonQChartDataSource = new Telerik.Reporting.SqlDataSource();
this.textBox15 = new Telerik.Reporting.TextBox();
this.textBox16 = new Telerik.Reporting.TextBox();
this.textBox19 = new Telerik.Reporting.TextBox();
this.StoresDataSource = new Telerik.Reporting.SqlDataSource();
this.pageFooterSection1 = new Telerik.Reporting.PageFooterSection();
this.StoresQChartDataSOurce = new Telerik.Reporting.SqlDataSource();
this.chart11 = new Telerik.Reporting.Chart();
((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
//
// textBox7
//
this.textBox7.Name = "textBox7";
this.textBox7.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.674990177154541D), Telerik.Reporting.Drawing.Unit.Inch(0.3311711847782135D));
this.textBox7.Style.Font.Bold = true;
this.textBox7.Value = "= \'Q\' + ReportsLibrary.DashboardReport.Qtr(Fields.OrderDate)";
//
// textBox9
//
this.textBox9.Name = "textBox9";
this.textBox9.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.349980354309082D), Telerik.Reporting.Drawing.Unit.Inch(0.3311711847782135D));
this.textBox9.Style.Font.Bold = true;
this.textBox9.StyleName = "";
this.textBox9.Value = "Total";
//
// textBox8
//
this.textBox8.Name = "textBox8";
this.textBox8.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.0083235502243042D), Telerik.Reporting.Drawing.Unit.Inch(0.48742103576660156D));
this.textBox8.Value = "= Fields.SalesPersonFullName";
//
// yeardatasource
//
this.yeardatasource.ConnectionString = "ReportsLibrary.Properties.Settings.AdventureWorks";
this.yeardatasource.Name = "yeardatasource";
this.yeardatasource.SelectCommand = "SELECT \r\n Distinct YEAR(OrderDate) as YEAR\r\n FROM Sales.SalesOrderHeader so\r\nOR" +
"DER BY YEAR asc\r\n ";
//
// textBox17
//
this.textBox17.Name = "textBox17";
this.textBox17.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.674990177154541D), Telerik.Reporting.Drawing.Unit.Inch(0.3311711847782135D));
this.textBox17.Style.Font.Bold = true;
this.textBox17.Value = "= \'Q\' + ReportsLibrary.DashboardReport.Qtr(Fields.OrderDate)";
//
// textBox18
//
this.textBox18.Name = "textBox18";
this.textBox18.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.349980354309082D), Telerik.Reporting.Drawing.Unit.Inch(0.3311711847782135D));
this.textBox18.Style.Font.Bold = true;
this.textBox18.StyleName = "";
this.textBox18.Value = "Total";
//
// textBox20
//
this.textBox20.Name = "textBox20";
this.textBox20.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.0083235502243042D), Telerik.Reporting.Drawing.Unit.Inch(0.48742103576660156D));
this.textBox20.Value = "= Fields.Name";
//
// pageHeaderSection1
//
this.pageHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.90000009536743164D);
this.pageHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBox1,
this.pictureBox1,
this.textBox4});
this.pageHeaderSection1.Name = "pageHeaderSection1";
//
// textBox1
//
this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(1.1000785827636719D), 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(10.466549873352051D), Telerik.Reporting.Drawing.Unit.Inch(0.60000008344650269D));
this.textBox1.Style.BackgroundColor = System.Drawing.Color.White;
this.textBox1.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(135)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
this.textBox1.Style.Font.Name = "Arial Black";
this.textBox1.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(30D);
this.textBox1.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
this.textBox1.Value = " XYZ Sales Report";
//
// pictureBox1
//
this.pictureBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(3.9378803194267675E-05D));
this.pictureBox1.MimeType = "image/bmp";
this.pictureBox1.Name = "pictureBox1";
this.pictureBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.0999606847763062D), Telerik.Reporting.Drawing.Unit.Inch(0.60000008344650269D));
this.pictureBox1.Value = ((object)(resources.GetObject("pictureBox1.Value")));
//
// textBox4
//
this.textBox4.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(0.60011816024780273D));
this.textBox4.Name = "textBox4";
this.textBox4.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(11.566628456115723D), Telerik.Reporting.Drawing.Unit.Inch(0.19988186657428742D));
this.textBox4.Style.BackgroundColor = System.Drawing.Color.Silver;
this.textBox4.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(135)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
this.textBox4.Style.Font.Name = "Arial Black";
this.textBox4.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(10D);
this.textBox4.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
this.textBox4.Value = "(Internal Use Only)";
//
// detail
//
this.detail.Height = Telerik.Reporting.Drawing.Unit.Inch(5.5D);
this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBox2,
this.crosstab1,
this.textBox11,
this.textBox12,
this.textBox13,
this.chart2,
this.textBox3,
this.textBox14,
this.chart3,
this.textBox21,
this.chart11});
this.detail.Name = "detail";
//
// textBox2
//
this.textBox2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D));
this.textBox2.Name = "textBox2";
this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(11.56658935546875D), Telerik.Reporting.Drawing.Unit.Inch(0.3999999463558197D));
this.textBox2.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(135)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
this.textBox2.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(0)))), ((int)(((byte)(64)))));
this.textBox2.Style.Font.Name = "Arial Black";
this.textBox2.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(16D);
this.textBox2.Value = "Top 5 Performing Agents";
//
// crosstab1
//
this.crosstab1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(0.674990177154541D)));
this.crosstab1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(1.349980354309082D)));
this.crosstab1.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(Telerik.Reporting.Drawing.Unit.Inch(0.48742103576660156D)));
this.crosstab1.Body.SetCellContent(0, 0, this.textBox6);
this.crosstab1.Body.SetCellContent(0, 1, this.textBox10);
tableGroup1.Groupings.Add(new Telerik.Reporting.Grouping("= ReportsLibrary.DashboardReport.Qtr(Fields.OrderDate)"));
tableGroup1.Name = "Quarter";
tableGroup1.ReportItem = this.textBox7;
tableGroup1.Sortings.Add(new Telerik.Reporting.Sorting("= ReportsLibrary.DashboardReport.Qtr(Fields.OrderDate)", Telerik.Reporting.SortDirection.Asc));
tableGroup2.ReportItem = this.textBox9;
this.crosstab1.ColumnGroups.Add(tableGroup1);
this.crosstab1.ColumnGroups.Add(tableGroup2);
this.crosstab1.Corner.SetCellContent(0, 0, this.textBox5);
this.crosstab1.DataSource = this.SalesPersonDatasource;
this.crosstab1.Filters.Add(new Telerik.Reporting.Filter("= CStr(ReportsLibrary.DashboardReport.Yr(Fields.OrderDate))", Telerik.Reporting.FilterOperator.Equal, "=cstr(Parameters.ReportYear.Value)"));
this.crosstab1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.textBox6,
this.textBox10,
this.textBox7,
this.textBox9,
this.textBox5,
this.textBox8});
this.crosstab1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.9418537198798731E-05D), Telerik.Reporting.Drawing.Unit.Inch(0.699999988079071D));
this.crosstab1.Name = "crosstab1";
tableGroup3.Filters.Add(new Telerik.Reporting.Filter("= Sum(Fields.SubTotal)", Telerik.Reporting.FilterOperator.TopN, "=5"));
tableGroup3.Groupings.Add(new Telerik.Reporting.Grouping("=Fields.SalesPersonFullName"));
tableGroup3.Name = "SalesPersonFullName";
tableGroup3.ReportItem = this.textBox8;
tableGroup3.Sortings.Add(new Telerik.Reporting.Sorting("= Sum(Fields.SubTotal)", Telerik.Reporting.SortDirection.Desc));
this.crosstab1.RowGroups.Add(tableGroup3);
this.crosstab1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(3.0332939624786377D), Telerik.Reporting.Drawing.Unit.Inch(0.81859225034713745D));
//
// textBox6
//
this.textBox6.Format = "{0:#.}";
this.textBox6.Name = "textBox6";
this.textBox6.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.674990177154541D), Telerik.Reporting.Drawing.Unit.Inch(0.48742103576660156D));
this.textBox6.Value = "= Sum(Fields.SubTotal) / 1000.0";
//
// textBox10
//
this.textBox10.Format = "{0:C0}";
this.textBox10.Name = "textBox10";
this.textBox10.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.349980354309082D), Telerik.Reporting.Drawing.Unit.Inch(0.48742103576660156D));
this.textBox10.StyleName = "";
this.textBox10.Value = "= Sum(Fields.SubTotal) / 1000.0";
//
// textBox5
//
this.textBox5.Name = "textBox5";
this.textBox5.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.0083235502243042D), Telerik.Reporting.Drawing.Unit.Inch(0.3311711847782135D));
this.textBox5.Style.Font.Bold = true;
this.textBox5.Value = "Sales Person ";
//
// SalesPersonDatasource
//
this.SalesPersonDatasource.ConnectionString = "ReportsLibrary.Properties.Settings.AdventureWorks";
this.SalesPersonDatasource.Name = "SalesPersonDatasource";
this.SalesPersonDatasource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
new Telerik.Reporting.SqlDataSourceParameter("@ReportYear", System.Data.DbType.Int32, "=Parameters.ReportYear.Value")});
this.SalesPersonDatasource.SelectCommand = resources.GetString("SalesPersonDatasource.SelectCommand");
//
// textBox11
//
this.textBox11.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(7.8837074397597462E-05D), Telerik.Reporting.Drawing.Unit.Inch(0.40011820197105408D));
this.textBox11.Name = "textBox11";
this.textBox11.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(3.0332546234130859D), Telerik.Reporting.Drawing.Unit.Inch(0.29980292916297913D));
this.textBox11.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(135)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
this.textBox11.Style.Font.Name = "Arial Black";
this.textBox11.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(12D);
this.textBox11.Value = "Sales Amount Quarterly In USD (Thousands)";
//
// textBox12
//
this.textBox12.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.0334122180938721D), Telerik.Reporting.Drawing.Unit.Inch(0.40011820197105408D));
this.textBox12.Name = "textBox12";
this.textBox12.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(4.26658821105957D), Telerik.Reporting.Drawing.Unit.Inch(0.29980292916297913D));
this.textBox12.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(135)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
this.textBox12.Style.Font.Name = "Arial Black";
this.textBox12.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(12D);
this.textBox12.Value = "Yearly Sales Distribution";
//
// textBox13
//
this.textBox13.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(7.3000798225402832D), Telerik.Reporting.Drawing.Unit.Inch(0.40011820197105408D));
this.textBox13.Name = "textBox13";
this.textBox13.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(4.26658821105957D), Telerik.Reporting.Drawing.Unit.Inch(0.29980292916297913D));
this.textBox13.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(135)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
this.textBox13.Style.Font.Name = "Arial Black";
this.textBox13.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(12D);
this.textBox13.Value = "Quarterly Sales Distribution";
//
// chart2
//
this.chart2.Appearance.Border.Visible = false;
this.chart2.BitmapResolution = 96F;
this.chart2.ChartTitle.Appearance.Visible = false;
this.chart2.ChartTitle.Visible = false;
paletteItem1.MainColor = System.Drawing.Color.FromArgb(((int)(((byte)(209)))), ((int)(((byte)(110)))), ((int)(((byte)(25)))));
paletteItem1.Name = "PaletteItem 1";
paletteItem1.SecondColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(166)))), ((int)(((byte)(78)))));
paletteItem2.MainColor = System.Drawing.Color.FromArgb(((int)(((byte)(239)))), ((int)(((byte)(185)))), ((int)(((byte)(39)))));
paletteItem2.Name = "PaletteItem 2";
paletteItem2.SecondColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(223)))), ((int)(((byte)(74)))));
paletteItem3.MainColor = System.Drawing.Color.Maroon;
paletteItem3.Name = "PaletteItem 3";
paletteItem3.SecondColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(64)))), ((int)(((byte)(0)))));
paletteItem4.MainColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(192)))));
paletteItem4.Name = "PaletteItem 4";
paletteItem4.SecondColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
paletteItem5.MainColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));
paletteItem5.Name = "PaletteItem 5";
paletteItem5.SecondColor = System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(255)))), ((int)(((byte)(128)))));
palette1.Items.AddRange(new Telerik.Reporting.Charting.PaletteItem[] {
paletteItem1,
paletteItem2,
paletteItem3,
paletteItem4,
paletteItem5});
palette1.Name = "Palette1";
this.chart2.CustomPalettes.AddRange(new Telerik.Reporting.Charting.Palette[] {
palette1});
this.chart2.DataSource = this.SalesPersonYChartDataSource;
this.chart2.DefaultType = Telerik.Reporting.Charting.ChartSeriesType.Pie;
this.chart2.ImageFormat = System.Drawing.Imaging.ImageFormat.Emf;
this.chart2.IntelligentLabelsEnabled = true;
this.chart2.Legend.Appearance.Border.Visible = false;
this.chart2.Legend.Appearance.ItemTextAppearance.TextProperties.Color = System.Drawing.Color.FromArgb(((int)(((byte)(15)))), ((int)(((byte)(15)))), ((int)(((byte)(15)))));
this.chart2.Legend.Appearance.ItemTextAppearance.TextProperties.Font = new System.Drawing.Font("Arial", 7.75F);
this.chart2.Legend.Appearance.Shadow.Blur = 2F;
this.chart2.Legend.Appearance.Shadow.Distance = 2F;
this.chart2.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.0334117412567139D), Telerik.Reporting.Drawing.Unit.Inch(0.699999988079071D));
this.chart2.Name = "chart2";
this.chart2.PlotArea.Appearance.Border.Visible = false;
chartMargins1.Right = new Telerik.Reporting.Charting.Styles.Unit(140D, Telerik.Reporting.Charting.Styles.UnitType.Pixel);
this.chart2.PlotArea.Appearance.Dimensions.Margins = chartMargins1;
this.chart2.PlotArea.Appearance.FillStyle.FillType = Telerik.Reporting.Charting.Styles.FillType.Solid;
this.chart2.PlotArea.Appearance.FillStyle.MainColor = System.Drawing.Color.White;
this.chart2.PlotArea.Appearance.SeriesPalette = "Palette1";
this.chart2.PlotArea.XAxis.MinValue = 1D;
chartSeries1.Appearance.Border.Color = System.Drawing.Color.White;
chartSeries1.Appearance.DiameterScale = 0.98D;
chartSeries1.Appearance.LabelAppearance.Visible = false;
chartSeries1.Appearance.LegendDisplayMode = Telerik.Reporting.Charting.ChartSeriesLegendDisplayMode.ItemLabels;
chartSeries1.DataLabelsColumn = "SalesPersonFullName";
chartSeries1.DataYColumn = "SalesAmt";
chartSeries1.Name = "Series 1";
chartSeries1.Type = Telerik.Reporting.Charting.ChartSeriesType.Pie;
this.chart2.Series.AddRange(new Telerik.Reporting.Charting.ChartSeries[] {
chartSeries1});
this.chart2.SeriesPalette = "Palette1";
this.chart2.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(4.2665886878967285D), Telerik.Reporting.Drawing.Unit.Inch(1.8999999761581421D));
//
// SalesPersonYChartDataSource
//
this.SalesPersonYChartDataSource.ConnectionString = "ReportsLibrary.Properties.Settings.AdventureWorks";
this.SalesPersonYChartDataSource.Name = "SalesPersonYChartDataSource";
this.SalesPersonYChartDataSource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
new Telerik.Reporting.SqlDataSourceParameter("@ReportYear", System.Data.DbType.Int32, "=Parameters.ReportYear.Value")});
this.SalesPersonYChartDataSource.SelectCommand = resources.GetString("SalesPersonYChartDataSource.SelectCommand");
//
// textBox3
//
this.textBox3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(2.600078821182251D));
this.textBox3.Name = "textBox3";
this.textBox3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(11.566668510437012D), Telerik.Reporting.Drawing.Unit.Inch(0.3999999463558197D));
this.textBox3.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(135)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
this.textBox3.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(0)))), ((int)(((byte)(64)))));
this.textBox3.Style.Font.Name = "Arial Black";
this.textBox3.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(16D);
this.textBox3.Value = "Top 5 Performing Stores";
//
// textBox14
//
this.textBox14.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(3.0001575946807861D));
this.textBox14.Name = "textBox14";
this.textBox14.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(3.0332546234130859D), Telerik.Reporting.Drawing.Unit.Inch(0.29980292916297913D));
this.textBox14.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(135)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
this.textBox14.Style.Font.Name = "Arial Black";
this.textBox14.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(12D);
this.textBox14.Value = "Sales Amount Quarterly In USD (Thousands)";
//
// chart3
//
this.chart3.Appearance.Border.Visible = false;
this.chart3.BitmapResolution = 96F;
this.chart3.ChartTitle.Appearance.Visible = false;
this.chart3.ChartTitle.Visible = false;
paletteItem6.MainColor = System.Drawing.Color.FromArgb(((int)(((byte)(209)))), ((int)(((byte)(110)))), ((int)(((byte)(25)))));
paletteItem6.Name = "PaletteItem 1";
paletteItem6.SecondColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(166)))), ((int)(((byte)(78)))));
paletteItem7.MainColor = System.Drawing.Color.FromArgb(((int)(((byte)(239)))), ((int)(((byte)(185)))), ((int)(((byte)(39)))));
paletteItem7.Name = "PaletteItem 2";
paletteItem7.SecondColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(223)))), ((int)(((byte)(74)))));
paletteItem8.MainColor = System.Drawing.Color.Maroon;
paletteItem8.Name = "PaletteItem 3";
paletteItem8.SecondColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(64)))), ((int)(((byte)(0)))));
paletteItem9.MainColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(192)))));
paletteItem9.Name = "PaletteItem 4";
paletteItem9.SecondColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
paletteItem10.MainColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));
paletteItem10.Name = "PaletteItem 5";
paletteItem10.SecondColor = System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(255)))), ((int)(((byte)(128)))));
palette2.Items.AddRange(new Telerik.Reporting.Charting.PaletteItem[] {
paletteItem6,
paletteItem7,
paletteItem8,
paletteItem9,
paletteItem10});
palette2.Name = "Palette1";
this.chart3.CustomPalettes.AddRange(new Telerik.Reporting.Charting.Palette[] {
palette2});
this.chart3.DataSource = this.StoresYChartDataSource;
this.chart3.DefaultType = Telerik.Reporting.Charting.ChartSeriesType.Pie;
this.chart3.ImageFormat = System.Drawing.Imaging.ImageFormat.Emf;
this.chart3.IntelligentLabelsEnabled = true;
this.chart3.Legend.Appearance.Border.Visible = false;
this.chart3.Legend.Appearance.ItemTextAppearance.TextProperties.Color = System.Drawing.Color.FromArgb(((int)(((byte)(15)))), ((int)(((byte)(15)))), ((int)(((byte)(15)))));
this.chart3.Legend.Appearance.ItemTextAppearance.TextProperties.Font = new System.Drawing.Font("Arial", 7.75F);
this.chart3.Legend.Appearance.Shadow.Blur = 2F;
this.chart3.Legend.Appearance.Shadow.Distance = 2F;
this.chart3.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.0334129333496094D), Telerik.Reporting.Drawing.Unit.Inch(3.2999999523162842D));
this.chart3.Name = "chart3";
this.chart3.PlotArea.Appearance.Border.Visible = false;
chartMargins2.Right = new Telerik.Reporting.Charting.Styles.Unit(140D, Telerik.Reporting.Charting.Styles.UnitType.Pixel);
this.chart3.PlotArea.Appearance.Dimensions.Margins = chartMargins2;
this.chart3.PlotArea.Appearance.FillStyle.FillType = Telerik.Reporting.Charting.Styles.FillType.Solid;
this.chart3.PlotArea.Appearance.FillStyle.MainColor = System.Drawing.Color.White;
this.chart3.PlotArea.Appearance.SeriesPalette = "Palette1";
this.chart3.PlotArea.XAxis.MinValue = 1D;
chartSeries2.Appearance.Border.Color = System.Drawing.Color.White;
chartSeries2.Appearance.DiameterScale = 0.98D;
chartSeries2.Appearance.LabelAppearance.Visible = false;
chartSeries2.Appearance.LegendDisplayMode = Telerik.Reporting.Charting.ChartSeriesLegendDisplayMode.ItemLabels;
chartSeries2.DataLabelsColumn = "StoreName";
chartSeries2.DataYColumn = "SalesAmt";
chartSeries2.Name = "Series 1";
chartSeries2.Type = Telerik.Reporting.Charting.ChartSeriesType.Pie;
this.chart3.Series.AddRange(new Telerik.Reporting.Charting.ChartSeries[] {
chartSeries2});
this.chart3.SeriesPalette = "Palette1";
this.chart3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(5.2665877342224121D), Telerik.Reporting.Drawing.Unit.Inch(1.8999999761581421D));
//
// StoresYChartDataSource
//
this.StoresYChartDataSource.ConnectionString = "ReportsLibrary.Properties.Settings.AdventureWorks";
this.StoresYChartDataSource.Name = "StoresYChartDataSource";
this.StoresYChartDataSource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
new Telerik.Reporting.SqlDataSourceParameter("@ReportYear", System.Data.DbType.Int32, "=Parameters.ReportYear.Value")});
this.StoresYChartDataSource.SelectCommand = resources.GetString("StoresYChartDataSource.SelectCommand");
//
// textBox21
//
this.textBox21.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(3.0334129333496094D), Telerik.Reporting.Drawing.Unit.Inch(3.0001182556152344D));
this.textBox21.Name = "textBox21";
this.textBox21.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(4.26658821105957D), Telerik.Reporting.Drawing.Unit.Inch(0.29980292916297913D));
this.textBox21.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(135)))), ((int)(((byte)(145)))), ((int)(((byte)(164)))));
this.textBox21.Style.Font.Name = "Arial Black";
this.textBox21.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(12D);
this.textBox21.Value = "Yearly Sales Distribution";
//
// SalesPersonQChartDataSource
//
this.SalesPersonQChartDataSource.ConnectionString = "Data Source=NIRMAL-PC;Initial Catalog=AdventureWorks;Integrated Security=True";
this.SalesPersonQChartDataSource.Name = "SalesPersonQChartDataSource";
this.SalesPersonQChartDataSource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
new Telerik.Reporting.SqlDataSourceParameter("@ReportYear", System.Data.DbType.Int32, "=Parameters.ReportYear.Value")});
this.SalesPersonQChartDataSource.ProviderName = "System.Data.SqlClient";
this.SalesPersonQChartDataSource.SelectCommand = resources.GetString("SalesPersonQChartDataSource.SelectCommand");
//
// textBox15
//
this.textBox15.Format = "{0:#.}";
this.textBox15.Name = "textBox15";
this.textBox15.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.674990177154541D), Telerik.Reporting.Drawing.Unit.Inch(0.48742103576660156D));
this.textBox15.Value = "= Sum(Fields.SubTotal) / 1000.0";
//
// textBox16
//
this.textBox16.Format = "{0:C0}";
this.textBox16.Name = "textBox16";
this.textBox16.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.349980354309082D), Telerik.Reporting.Drawing.Unit.Inch(0.48742103576660156D));
this.textBox16.StyleName = "";
this.textBox16.Value = "= Sum(Fields.SubTotal) / 1000.0";
//
// textBox19
//
this.textBox19.Name = "textBox19";
this.textBox19.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(1.0083235502243042D), Telerik.Reporting.Drawing.Unit.Inch(0.3311711847782135D));
this.textBox19.Style.Font.Bold = true;
this.textBox19.Value = "Store Name";
//
// StoresDataSource
//
this.StoresDataSource.ConnectionString = "Data Source=NIRMAL-PC;Initial Catalog=AdventureWorks;Integrated Security=True";
this.StoresDataSource.Name = "StoresDataSource";
this.StoresDataSource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
new Telerik.Reporting.SqlDataSourceParameter("@ReportYear", System.Data.DbType.Int32, "=Parameters.ReportYear.Value")});
this.StoresDataSource.ProviderName = "System.Data.SqlClient";
this.StoresDataSource.SelectCommand = resources.GetString("StoresDataSource.SelectCommand");
//
// pageFooterSection1
//
this.pageFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(3.2104175090789795D);
this.pageFooterSection1.Name = "pageFooterSection1";
//
// StoresQChartDataSOurce
//
this.StoresQChartDataSOurce.ConnectionString = "Data Source=NIRMAL-PC;Initial Catalog=AdventureWorks;Integrated Security=True";
this.StoresQChartDataSOurce.Name = "StoresQChartDataSOurce";
this.StoresQChartDataSOurce.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
new Telerik.Reporting.SqlDataSourceParameter("@ReportYear", System.Data.DbType.Int32, "=Parameters.ReportYear.Value")});
this.StoresQChartDataSOurce.ProviderName = "System.Data.SqlClient";
this.StoresQChartDataSOurce.SelectCommand = resources.GetString("StoresQChartDataSOurce.SelectCommand");
//
// chart11
//
this.chart11.Appearance.Border.Visible = false;
this.chart11.BitmapResolution = 96F;
this.chart11.ChartTitle.Appearance.Visible = false;
this.chart11.ChartTitle.Visible = false;
paletteItem11.MainColor = System.Drawing.Color.FromArgb(((int)(((byte)(209)))), ((int)(((byte)(110)))), ((int)(((byte)(25)))));
paletteItem11.Name = "PaletteItem 1";
paletteItem11.SecondColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(166)))), ((int)(((byte)(78)))));
paletteItem12.MainColor = System.Drawing.Color.FromArgb(((int)(((byte)(239)))), ((int)(((byte)(185)))), ((int)(((byte)(39)))));
paletteItem12.Name = "PaletteItem 2";
paletteItem12.SecondColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(223)))), ((int)(((byte)(74)))));
paletteItem13.MainColor = System.Drawing.Color.Maroon;
paletteItem13.Name = "PaletteItem 3";
paletteItem13.SecondColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(64)))), ((int)(((byte)(0)))));
paletteItem14.MainColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(192)))));
paletteItem14.Name = "PaletteItem 4";
paletteItem14.SecondColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))));
paletteItem15.MainColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));
paletteItem15.Name = "PaletteItem 5";
paletteItem15.SecondColor = System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(255)))), ((int)(((byte)(128)))));
palette3.Items.AddRange(new Telerik.Reporting.Charting.PaletteItem[] {
paletteItem11,
paletteItem12,
paletteItem13,
paletteItem14,
paletteItem15});
palette3.Name = "Palette1";
this.chart11.CustomPalettes.AddRange(new Telerik.Reporting.Charting.Palette[] {
palette3});
this.chart11.DataSource = this.SalesPersonQChartDataSource;
this.chart11.DefaultType = Telerik.Reporting.Charting.ChartSeriesType.StackedBar;
this.chart11.ImageFormat = System.Drawing.Imaging.ImageFormat.Emf;
this.chart11.IntelligentLabelsEnabled = true;
this.chart11.Legend.Appearance.Border.Visible = false;
this.chart11.Legend.Appearance.ItemTextAppearance.TextProperties.Color = System.Drawing.Color.FromArgb(((int)(((byte)(15)))), ((int)(((byte)(15)))), ((int)(((byte)(15)))));
this.chart11.Legend.Appearance.ItemTextAppearance.TextProperties.Font = new System.Drawing.Font("Arial", 7.75F);
this.chart11.Legend.Appearance.Overflow = Telerik.Reporting.Charting.Styles.Overflow.Row;
this.chart11.Legend.Appearance.Position.AlignedPosition = Telerik.Reporting.Charting.Styles.AlignedPositions.Top;
this.chart11.Legend.Appearance.Shadow.Blur = 2F;
this.chart11.Legend.Appearance.Shadow.Distance = 2F;
this.chart11.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(7.300079345703125D), Telerik.Reporting.Drawing.Unit.Inch(0.699999988079071D));
this.chart11.Name = "chart11";
this.chart11.PlotArea.Appearance.Border.Visible = false;
chartMargins3.Right = new Telerik.Reporting.Charting.Styles.Unit(140D, Telerik.Reporting.Charting.Styles.UnitType.Pixel);
this.chart11.PlotArea.Appearance.Dimensions.Margins = chartMargins3;
this.chart11.PlotArea.Appearance.FillStyle.FillType = Telerik.Reporting.Charting.Styles.FillType.Solid;
this.chart11.PlotArea.Appearance.FillStyle.MainColor = System.Drawing.Color.White;
this.chart11.PlotArea.Appearance.SeriesPalette = "Palette1";
this.chart11.PlotArea.XAxis.AxisLabel.Appearance.RotationAngle = 270F;
this.chart11.PlotArea.XAxis.MinValue = 1D;
this.chart11.PlotArea.YAxis.AxisLabel.Appearance.RotationAngle = 0F;
this.chart11.PlotArea.YAxis.MaxValue = 90D;
this.chart11.PlotArea.YAxis.Step = 10D;
this.chart11.PlotArea.YAxis2.AxisLabel.Appearance.RotationAngle = 0F;
chartSeries3.Appearance.Border.Color = System.Drawing.Color.White;
chartSeries3.Appearance.DiameterScale = 0.98D;
chartSeries3.Appearance.LabelAppearance.Visible = false;
chartSeries3.Appearance.LegendDisplayMode = Telerik.Reporting.Charting.ChartSeriesLegendDisplayMode.ItemLabels;
chartSeries3.DataLabelsColumn = "SalesPersonFullName";
chartSeries3.DataYColumn = "SalesAmt";
chartSeries3.Name = "Series 1";
chartSeries3.Type = Telerik.Reporting.Charting.ChartSeriesType.StackedBar;
this.chart11.Series.AddRange(new Telerik.Reporting.Charting.ChartSeries[] {
chartSeries3});
this.chart11.SeriesOrientation = Telerik.Reporting.Charting.ChartSeriesOrientation.Horizontal;
this.chart11.SeriesPalette = "Palette1";
this.chart11.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(4.2665886878967285D), Telerik.Reporting.Drawing.Unit.Inch(1.8999999761581421D));
//
// DashboardReport
//
this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
this.pageHeaderSection1,
this.detail,
this.pageFooterSection1});
this.Name = "DashboardReport";
this.PageSettings.Landscape = true;
this.PageSettings.Margins = new Telerik.Reporting.Drawing.MarginsU(Telerik.Reporting.Drawing.Unit.Inch(0.30000001192092896D), Telerik.Reporting.Drawing.Unit.Inch(1D), Telerik.Reporting.Drawing.Unit.Inch(0.40000000596046448D), Telerik.Reporting.Drawing.Unit.Inch(1D));
this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter;
reportParameter1.AutoRefresh = true;
reportParameter1.AvailableValues.DataSource = this.yeardatasource;
reportParameter1.AvailableValues.DisplayMember = "= Fields.YEAR";
reportParameter1.AvailableValues.ValueMember = "= Fields.YEAR";
reportParameter1.Name = "ReportYear";
reportParameter1.Text = "Sales for Year";
reportParameter1.Type = Telerik.Reporting.ReportParameterType.Integer;
reportParameter1.Value = "2001";
reportParameter1.Visible = true;
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);
this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] {
styleRule1});
this.Width = Telerik.Reporting.Drawing.Unit.Inch(13.566666603088379D);
((System.ComponentModel.ISupportInitialize)(this)).EndInit();

}
#endregion

private Telerik.Reporting.PageHeaderSection pageHeaderSection1;
private Telerik.Reporting.DetailSection detail;
private Telerik.Reporting.PageFooterSection pageFooterSection1;
private Telerik.Reporting.TextBox textBox1;
private Telerik.Reporting.PictureBox pictureBox1;
private Telerik.Reporting.TextBox textBox4;
private Telerik.Reporting.TextBox textBox2;
private Telerik.Reporting.TextBox textBox3;
private Telerik.Reporting.SqlDataSource yeardatasource;
private Telerik.Reporting.Crosstab crosstab1;
private Telerik.Reporting.TextBox textBox6;
private Telerik.Reporting.TextBox textBox7;
private Telerik.Reporting.TextBox textBox5;
private Telerik.Reporting.SqlDataSource SalesPersonDatasource;
private Telerik.Reporting.TextBox textBox8;
private Telerik.Reporting.TextBox textBox10;
private Telerik.Reporting.TextBox textBox9;
private Telerik.Reporting.SqlDataSource SalesPersonYChartDataSource;
private Telerik.Reporting.TextBox textBox11;
private Telerik.Reporting.TextBox textBox12;
private Telerik.Reporting.SqlDataSource SalesPersonQChartDataSource;
private Telerik.Reporting.TextBox textBox13;
private Telerik.Reporting.Chart chart2;
private Telerik.Reporting.TextBox textBox14;
private Telerik.Reporting.TextBox textBox15;
private Telerik.Reporting.TextBox textBox16;
private Telerik.Reporting.TextBox textBox17;
private Telerik.Reporting.TextBox textBox18;
private Telerik.Reporting.TextBox textBox19;
private Telerik.Reporting.SqlDataSource StoresDataSource;
private Telerik.Reporting.TextBox textBox20;
private Telerik.Reporting.Chart chart3;
private Telerik.Reporting.SqlDataSource StoresYChartDataSource;
private Telerik.Reporting.TextBox textBox21;
private Telerik.Reporting.SqlDataSource StoresQChartDataSOurce;
private Telerik.Reporting.Chart chart11;

}
}

I am using the below query for the chart:
SELECT TOP 5 SalesPersonFullName, Q1,Q2,Q3,Q4, SUM(Q1+Q2+Q3+Q4) AS TOTAL
FROM
( SELECT SalesPersonFullName, COALESCE([1],0) AS [Q1] ,COALESCE([2],0) AS [Q2],COALESCE([3],0) AS [Q3],
COALESCE([4],0) AS [Q4]
FROM
(SELECT C.FirstName + ' ' + COALESCE (C.MiddleName, '') + ' ' + C.LastName AS SalesPersonFullName,
SUM(SOH.SubTotal) AS SalesAmt,
CAST((Month(SOH.OrderDate)-1)/3 As int) AS Q
FROM Sales.SalesPerson AS SP
INNER JOIN HumanResources.Employee AS E ON SP.SalesPersonID = E.EmployeeID
INNER JOIN Person.Contact AS C ON E.ContactID = C.ContactID
INNER JOIN Sales.SalesOrderHeader AS SOH ON SP.SalesPersonID = SOH.SalesPersonID
WHERE YEAR(SOH.OrderDate)=@ReportYear
GROUP BY C.FirstName + ' ' + COALESCE (C.MiddleName, '') + ' ' + C.LastName,
CAST((Month(SOH.OrderDate)-1)/3 As int )
) A Pivot ( SUM(SalesAmt) FOR Q IN ([1],[2],[3],[4] )) AS pvt ) B
GROUP BY SalesPersonFullName, Q1,Q2,Q3,Q4

Regards,
Nirmal