or
public string ConnectionString { get; set; }private void Rpt_CustomerAccountsReport_NeedDataSource(object sender, EventArgs e){ try { if (Report.ReportParameters["MarketListID"].Value == null && Report.ReportParameters["BranchID"].Value == null && Report.ReportParameters["CustomerGroupID"].Value == null && Report.ReportParameters["CustomerID"].Value == null) { ErrorMsg("Error! This report cannot be run without parameters. Please select a Branch, Marketing list or Customer group."); } else { SqlData data = new SqlData(ConnectionString); // Shared getdataset function dsMain = data.GetDataSet("spRpt_CustomerAccountsReport", CommandType.StoredProcedure, "@EmployeeUserID", Report.ReportParameters["EmployeeUserID"].Value, "@MarketListID", Report.ReportParameters["MarketListID"].Value, "@CustomerID", Report.ReportParameters["CustomerID"].Value, "@BranchID", Report.ReportParameters["BranchID"].Value, "@CustomerGroupID", Report.ReportParameters["CustomerGroupID"].Value, "@EmployeeID", Report.ReportParameters["EmployeeID"].Value); // ** Moving the max record limit to the stored procedure so we can change / make it user configurable without a re-compile if (dsMain.Tables[0].Rows.Count > 40000) { ErrorMsg("Over 40,000 results were returned. The report cannot render. Please select more specific criteria."); } else { Report.DataSource = dsMain.Tables[0]; } } // They provided parameters } catch (Exception ex) { ErrorMsg(ex.Message); }}private void GroupHeaderArea1_ItemDataBinding(object sender, EventArgs e){ try { // Get the section Telerik.Reporting.Processing.GroupSection section = (sender as Telerik.Reporting.Processing.GroupSection); if (section != null) { // Get the customer ID for this section object id = section.DataObject["CustomerID"]; if (id != null) { int CustID = (int)id; // Filter out sub-report data DataRow[] drContacts = dsMain.Tables[1].Select("CustomerID=" + CustID.ToString()); DataRow[] drCrossSell = dsMain.Tables[2].Select("CustomerID=" + CustID.ToString()); DataRow[] drAccounts = dsMain.Tables[3].Select("CustomerID=" + CustID.ToString()); Rpt_CustomerAccountsReportAccountSummary rptAcct = new Rpt_CustomerAccountsReportAccountSummary(); Rpt_CustomerAccountsReportContacts rptContact = new Rpt_CustomerAccountsReportContacts(); Rpt_CustomerAccountsReportCrossSell rptCrossSell = new Rpt_CustomerAccountsReportCrossSell(); rptAcct.DataSource = drAccounts; rptContact.DataSource = drContacts; rptCrossSell.DataSource = drCrossSell; srContacts.ReportSource = rptContact; srCrossSell.ReportSource = rptCrossSell; srAccountSummary.ReportSource = rptAcct; } } } catch (Exception ex) { ErrorMsg(ex.Message); }}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.Drawing.TextWatermark textWatermark1 = new Telerik.Reporting.Drawing.TextWatermark(); Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule(); this.textBox1 = new Telerik.Reporting.TextBox(); this.textBox3 = new Telerik.Reporting.TextBox(); this.textBox4 = new Telerik.Reporting.TextBox(); this.pageHeaderSection1 = new Telerik.Reporting.PageHeaderSection(); this.detail = new Telerik.Reporting.DetailSection(); this.panel11 = new Telerik.Reporting.Panel(); this.pictureBox1 = new Telerik.Reporting.PictureBox(); this.table1 = new Telerik.Reporting.Table(); this.textBox5 = new Telerik.Reporting.TextBox(); this.textBox6 = new Telerik.Reporting.TextBox(); this.textBox7 = new Telerik.Reporting.TextBox(); this.pageFooterSection1 = new Telerik.Reporting.PageFooterSection(); this.objectDataSource1 = new Telerik.Reporting.ObjectDataSource(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // textBox1 // this.textBox1.Name = "textBox1"; this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.79998695850372314D), Telerik.Reporting.Drawing.Unit.Inch(0.29996046423912048D)); this.textBox1.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox1.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; // // textBox3 // this.textBox3.Name = "textBox3"; this.textBox3.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.79998695850372314D), Telerik.Reporting.Drawing.Unit.Inch(0.29996046423912048D)); this.textBox3.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox3.Style.BorderStyle.Left = Telerik.Reporting.Drawing.BorderType.None; this.textBox3.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; // // textBox4 // this.textBox4.Name = "textBox4"; this.textBox4.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.79998695850372314D), Telerik.Reporting.Drawing.Unit.Inch(0.29996046423912048D)); this.textBox4.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox4.Style.BorderStyle.Left = Telerik.Reporting.Drawing.BorderType.None; this.textBox4.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; // // pageHeaderSection1 // this.pageHeaderSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.30000004172325134D); this.pageHeaderSection1.Name = "pageHeaderSection1"; // // detail // this.detail.Height = Telerik.Reporting.Drawing.Unit.Inch(8.99375057220459D); this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.panel11, this.pictureBox1, this.table1}); this.detail.Name = "detail"; this.detail.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Inset; // // panel11 // this.panel11.Bindings.Add(new Telerik.Reporting.Binding("Location", "= Rexroth.Hydraulics.PumpsAndMotors.CalculationPrograms.Leist.Views.Report11.RepositionPanelFactor(Fields.ObjData.Count, ReportItem)")); this.panel11.Docking = Telerik.Reporting.DockingStyle.Bottom; this.panel11.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0D), Telerik.Reporting.Drawing.Unit.Inch(7.8937501907348633D)); this.panel11.Name = "panel11"; this.panel11.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(6.2677168846130371D), Telerik.Reporting.Drawing.Unit.Inch(1.1000001430511475D)); this.panel11.Style.BackgroundColor = System.Drawing.Color.Silver; this.panel11.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Inset; // // table1 // //this.table1.Anchoring = Telerik.Reporting.AnchoringStyles.Top; this.table1.Docking = Telerik.Reporting.DockingStyle.Fill; this.table1.Bindings.Add(new Telerik.Reporting.Binding("DataSource", "=Fields.ObjData")); this.table1.Bindings.Add(new Telerik.Reporting.Binding("Location", "= Rexroth.Hydraulics.PumpsAndMotors.CalculationPrograms.Leist.Views.Report11.RepositionTableFactor(Fields.ObjData.Count,ReportItem)")); this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(0.79998701810836792D))); this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(0.79998701810836792D))); this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Inch(0.79998701810836792D))); this.table1.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(Telerik.Reporting.Drawing.Unit.Inch(0.29996046423912048D))); this.table1.Body.SetCellContent(0, 0, this.textBox5); this.table1.Body.SetCellContent(0, 1, this.textBox6); this.table1.Body.SetCellContent(0, 2, this.textBox7); tableGroup1.ReportItem = this.textBox1; tableGroup2.ReportItem = this.textBox3; tableGroup3.ReportItem = this.textBox4; this.table1.ColumnGroups.Add(tableGroup1); this.table1.ColumnGroups.Add(tableGroup2); this.table1.ColumnGroups.Add(tableGroup3); this.table1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.textBox5, this.textBox6, this.textBox7, this.textBox1, this.textBox3, this.textBox4}); this.table1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.067756019532680511D), Telerik.Reporting.Drawing.Unit.Inch(7.2937507629394531D)); this.table1.Name = "table1"; tableGroup4.Groupings.Add(new Telerik.Reporting.Grouping(null)); tableGroup4.Name = "DetailGroup"; this.table1.RowGroups.Add(tableGroup4); this.table1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(2.39996075630188D), Telerik.Reporting.Drawing.Unit.Inch(0.599920928478241D)); this.table1.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid; // // pictureBox1 // this.pictureBox1.Docking = Telerik.Reporting.DockingStyle.Top; this.pictureBox1.Bindings.Add(new Telerik.Reporting.Binding("Size", "= Rexroth.Hydraulics.PumpsAndMotors.CalculationPrograms.Leist.Views.Report11.ResizePictureFactor(Fields.ObjData.Count,ReportItem)")); this.pictureBox1.Bindings.Add(new Telerik.Reporting.Binding("Value", "=Fields.MyImage")); //this.pictureBox1.Bindings.Add(new Telerik.Reporting.Binding("Location", "= Rexroth.Hydraulics.PumpsAndMotors.CalculationPrograms.Leist.Views.Report11.RepositionPictureFactor(Fields.ObjData.Count,ReportItem)")); this.pictureBox1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0.0067756019532680511D), 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(6.1999607086181641D), Telerik.Reporting.Drawing.Unit.Inch(7.1999607086181641D)); this.pictureBox1.Sizing = Telerik.Reporting.Drawing.ImageSizeMode.Stretch; this.pictureBox1.Style.BorderColor.Default = System.Drawing.Color.Maroon; this.pictureBox1.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid; this.pictureBox1.Style.BorderWidth.Default = Telerik.Reporting.Drawing.Unit.Point(1D); this.pictureBox1.Value = "=Fields.MyImage"; // // textBox5 // this.textBox5.Name = "textBox5"; this.textBox5.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.79998695850372314D), Telerik.Reporting.Drawing.Unit.Inch(0.29996046423912048D)); this.textBox5.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox5.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox5.Value = "=Fields.Speed"; // // textBox6 // this.textBox6.Name = "textBox6"; this.textBox6.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.79998695850372314D), Telerik.Reporting.Drawing.Unit.Inch(0.29996046423912048D)); this.textBox6.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox6.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.None; this.textBox6.Style.BorderStyle.Right = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox6.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox6.Value = "=Fields.Power"; // // textBox7 // this.textBox7.Name = "textBox7"; this.textBox7.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(0.79998695850372314D), Telerik.Reporting.Drawing.Unit.Inch(0.29996046423912048D)); this.textBox7.Style.BorderStyle.Bottom = Telerik.Reporting.Drawing.BorderType.Solid; this.textBox7.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.None; this.textBox7.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.textBox7.Value = "=Fields.Torque"; // // pageFooterSection1 // this.pageFooterSection1.Height = Telerik.Reporting.Drawing.Unit.Inch(0.2999996542930603D); this.pageFooterSection1.Name = "pageFooterSection1"; // // objectDataSource1 // this.objectDataSource1.DataSource = typeof(Reports.MyObjects); this.objectDataSource1.Name = "objectDataSource1"; // // Report1 // this.DataSource = this.objectDataSource1; this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.pageHeaderSection1, this.detail, this.pageFooterSection1}); this.Name = "Report11"; this.PageSettings.Landscape = false; 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(0D)); this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.A4; textWatermark1.Text = "Approved"; this.PageSettings.Watermarks.Add(textWatermark1); 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(6.2677168846130371D); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }