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

An error has occured while processing TextBox 'textBox1':

1 Answer 623 Views

General Discussions

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

nishant mehta asked on 14 Nov 2009, 06:09 PM

I have downloaded a trial version for using in my application.
datasource need to be bind on runtime and should change on change of a dropdownlist
this is what my classlibrarylooks alike:

namespace

ClassLibrary1

{

using System;

using System.Data;

using System.ComponentModel;

using System.Drawing;

using System.Windows.Forms;

using Telerik.Reporting;

using Telerik.Reporting.Drawing;

/// <summary>

/// Summary description for Report1.

/// </summary>

public partial class Report1 : Telerik.Reporting.Report

{

public string constr;

public Report1(string cnstr)

{

/// <summary>

/// Required for telerik Reporting designer support

/// </summary>

InitializeComponent();

System.Data.OleDb.

OleDbConnection cn = new System.Data.OleDb.OleDbConnection();

System.Data.OleDb.

OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();

System.Data.OleDb.

OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter();

DataTable dt = new DataTable();

cn.ConnectionString = cnstr;

constr = cnstr;

cmd.CommandText =

"Select * from company";

cmd.Connection = cn;

da.SelectCommand = cmd;

da =

new System.Data.OleDb.OleDbDataAdapter("Select * from company", cnstr);

this.DataSource = da;

}

private void Report1_NeedDataSource(object sender, System.EventArgs e)

{

string sql =

@"Select * from company";

//da.SelectCommand = new System.Data.OleDb.OleDbCommand(sql);

System.Data.OleDb.

OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sql,constr);

DataSet dataSet = new DataSet();

da.Fill(dataSet);

(sender

as Telerik.Reporting.Processing.Report).DataSource = dataSet;

}

private void textBox2_ItemDataBound(object sender, EventArgs e)

{

Telerik.Reporting.Processing.

TextBox txtPosition = (Telerik.Reporting.Processing.TextBox)sender;

if (txtPosition.Text.Contains("Developer"))

{

txtPosition.Style.BackgroundColor =

Color.Blue;

}

}

this is how designer code looks :

namespace

ClassLibrary1

{

using System.ComponentModel;

using System.Drawing;

using System.Windows.Forms;

using Telerik.Reporting;

using Telerik.Reporting.Drawing;

partial class Report1

{

#region

Component Designer generated code

/// <summary>

/// Required method for telerik Reporting designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

Telerik.Reporting.Drawing.

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.dataSet = new ClassLibrary1.DataSet();

this.labelsGroupHeader = new Telerik.Reporting.GroupHeaderSection();

this.labelsGroupFooter = new Telerik.Reporting.GroupFooterSection();

this.labelsGroup = new Telerik.Reporting.Group();

this.pageHeader = new Telerik.Reporting.PageHeaderSection();

this.reportNameTextBox = new Telerik.Reporting.TextBox();

this.pageFooter = new Telerik.Reporting.PageFooterSection();

this.currentTimeTextBox = new Telerik.Reporting.TextBox();

this.pageInfoTextBox = new Telerik.Reporting.TextBox();

this.reportHeader = new Telerik.Reporting.ReportHeaderSection();

this.titleTextBox = new Telerik.Reporting.TextBox();

this.detail = new Telerik.Reporting.DetailSection();

this.dataSetTableAdapter1 = new ClassLibrary1.DataSetTableAdapters.DataSetTableAdapter();

this.textBox1 = new Telerik.Reporting.TextBox();

((System.ComponentModel.

ISupportInitialize)(this.dataSet)).BeginInit();

((System.ComponentModel.

ISupportInitialize)(this)).BeginInit();

// dataSet

this.dataSet.DataSetName = "DataSet";

this.dataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;

// labelsGroupHeader

this.labelsGroupHeader.Height = new Telerik.Reporting.Drawing.Unit(0.28125, Telerik.Reporting.Drawing.UnitType.Inch);

this.labelsGroupHeader.Name = "labelsGroupHeader";

this.labelsGroupHeader.PrintOnEveryPage = true;

// labelsGroupFooter

this.labelsGroupFooter.Height = new Telerik.Reporting.Drawing.Unit(0.28125, Telerik.Reporting.Drawing.UnitType.Inch);

this.labelsGroupFooter.Name = "labelsGroupFooter";

this.labelsGroupFooter.Style.Visible = false;

// labelsGroup

this.labelsGroup.Bookmark = null;

this.labelsGroup.GroupFooter = this.labelsGroupFooter;

this.labelsGroup.GroupHeader = this.labelsGroupHeader;

// pageHeader

this.pageHeader.Height = new Telerik.Reporting.Drawing.Unit(0.28125, Telerik.Reporting.Drawing.UnitType.Inch);

this.pageHeader.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {

this.reportNameTextBox});

this.pageHeader.Name = "pageHeader";

// reportNameTextBox

this.reportNameTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.02083333395421505, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.02083333395421505, Telerik.Reporting.Drawing.UnitType.Inch));

this.reportNameTextBox.Name = "reportNameTextBox";

this.reportNameTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(6.4166665077209473, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224, Telerik.Reporting.Drawing.UnitType.Inch));

this.reportNameTextBox.StyleName = "PageInfo";

this.reportNameTextBox.Value = "Report1";

// pageFooter

this.pageFooter.Height = new Telerik.Reporting.Drawing.Unit(0.28125, Telerik.Reporting.Drawing.UnitType.Inch);

this.pageFooter.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {

this.currentTimeTextBox,

this.pageInfoTextBox});

this.pageFooter.Name = "pageFooter";

// currentTimeTextBox

this.currentTimeTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.02083333395421505, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.02083333395421505, Telerik.Reporting.Drawing.UnitType.Inch));

this.currentTimeTextBox.Name = "currentTimeTextBox";

this.currentTimeTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(3.1979167461395264, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224, Telerik.Reporting.Drawing.UnitType.Inch));

this.currentTimeTextBox.StyleName = "PageInfo";

this.currentTimeTextBox.Value = "=NOW()";

// pageInfoTextBox

this.pageInfoTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.2395832538604736, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.02083333395421505, Telerik.Reporting.Drawing.UnitType.Inch));

this.pageInfoTextBox.Name = "pageInfoTextBox";

this.pageInfoTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(3.1979167461395264, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224, Telerik.Reporting.Drawing.UnitType.Inch));

this.pageInfoTextBox.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right;

this.pageInfoTextBox.StyleName = "PageInfo";

this.pageInfoTextBox.Value = "=PageNumber";

// reportHeader

this.reportHeader.Height = new Telerik.Reporting.Drawing.Unit(0.80823493003845215, Telerik.Reporting.Drawing.UnitType.Inch);

this.reportHeader.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {

this.titleTextBox});

this.reportHeader.Name = "reportHeader";

// titleTextBox

this.titleTextBox.Name = "titleTextBox";

this.titleTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(6.4583334922790527, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.78740161657333374, Telerik.Reporting.Drawing.UnitType.Inch));

this.titleTextBox.StyleName = "Title";

this.titleTextBox.Value = "Report1";

// detail

this.detail.Height = new Telerik.Reporting.Drawing.Unit(0.28125, Telerik.Reporting.Drawing.UnitType.Inch);

this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {

this.textBox1});

this.detail.Name = "detail";

// dataSetTableAdapter1

this.dataSetTableAdapter1.ClearBeforeFill = true;

// textBox1

this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.19999997317790985, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.081210456788539886, Telerik.Reporting.Drawing.UnitType.Inch));

this.textBox1.Name = "textBox1";

this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.9000000953674316, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179, Telerik.Reporting.Drawing.UnitType.Inch));

this.textBox1.Value = "[=Fields.[Company Name]]";

// Report1

this.Groups.AddRange(new Telerik.Reporting.Group[] {

this.labelsGroup});

this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {

this.labelsGroupHeader,

this.labelsGroupFooter,

this.pageHeader,

this.pageFooter,

this.reportHeader,

this.detail});

this.PageSettings.Landscape = false;

this.PageSettings.Margins.Bottom = new Telerik.Reporting.Drawing.Unit(1, Telerik.Reporting.Drawing.UnitType.Inch);

this.PageSettings.Margins.Left = new Telerik.Reporting.Drawing.Unit(1, Telerik.Reporting.Drawing.UnitType.Inch);

this.PageSettings.Margins.Right = new Telerik.Reporting.Drawing.Unit(1, Telerik.Reporting.Drawing.UnitType.Inch);

this.PageSettings.Margins.Top = new Telerik.Reporting.Drawing.Unit(1, Telerik.Reporting.Drawing.UnitType.Inch);

this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter;

this.Style.BackgroundColor = System.Drawing.Color.White;

styleRule1.Selectors.AddRange(

new Telerik.Reporting.Drawing.ISelector[] {

new Telerik.Reporting.Drawing.StyleSelector("Title")});

styleRule1.Style.Color = System.Drawing.

Color.Black;

styleRule1.Style.Font.Bold =

true;

styleRule1.Style.Font.Italic =

false;

styleRule1.Style.Font.Name =

"Tahoma";

styleRule1.Style.Font.Size =

new Telerik.Reporting.Drawing.Unit(20, Telerik.Reporting.Drawing.UnitType.Point);

styleRule1.Style.Font.Strikeout =

false;

styleRule1.Style.Font.Underline =

false;

styleRule2.Selectors.AddRange(

new Telerik.Reporting.Drawing.ISelector[] {

new Telerik.Reporting.Drawing.StyleSelector("Caption")});

styleRule2.Style.Color = System.Drawing.

Color.Black;

styleRule2.Style.Font.Name =

"Tahoma";

styleRule2.Style.Font.Size =

new Telerik.Reporting.Drawing.Unit(11, Telerik.Reporting.Drawing.UnitType.Point);

styleRule2.Style.VerticalAlign = Telerik.Reporting.Drawing.

VerticalAlign.Middle;

styleRule3.Selectors.AddRange(

new Telerik.Reporting.Drawing.ISelector[] {

new Telerik.Reporting.Drawing.StyleSelector("Data")});

styleRule3.Style.Font.Name =

"Tahoma";

styleRule3.Style.Font.Size =

new Telerik.Reporting.Drawing.Unit(11, Telerik.Reporting.Drawing.UnitType.Point);

styleRule3.Style.VerticalAlign = Telerik.Reporting.Drawing.

VerticalAlign.Middle;

styleRule4.Selectors.AddRange(

new Telerik.Reporting.Drawing.ISelector[] {

new Telerik.Reporting.Drawing.StyleSelector("PageInfo")});

styleRule4.Style.Font.Name =

"Tahoma";

styleRule4.Style.Font.Size =

new Telerik.Reporting.Drawing.Unit(11, Telerik.Reporting.Drawing.UnitType.Point);

styleRule4.Style.VerticalAlign = Telerik.Reporting.Drawing.

VerticalAlign.Middle;

this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] {

styleRule1,

styleRule2,

styleRule3,

styleRule4});

this.Width = new Telerik.Reporting.Drawing.Unit(6.4583334922790527, Telerik.Reporting.Drawing.UnitType.Inch);

((System.ComponentModel.

ISupportInitialize)(this.dataSet)).EndInit();

((System.ComponentModel.

ISupportInitialize)(this)).EndInit();

}

#endregion

private GroupHeaderSection labelsGroupHeader;

private GroupFooterSection labelsGroupFooter;

private Group labelsGroup;

private PageHeaderSection pageHeader;

private Telerik.Reporting.TextBox reportNameTextBox;

private PageFooterSection pageFooter;

private Telerik.Reporting.TextBox currentTimeTextBox;

private Telerik.Reporting.TextBox pageInfoTextBox;

private ReportHeaderSection reportHeader;

private Telerik.Reporting.TextBox titleTextBox;

private DetailSection detail;

private DataSet dataSet;

private ClassLibrary1.DataSetTableAdapters.DataSetTableAdapter dataSetTableAdapter1;

private Telerik.Reporting.TextBox textBox1;

}

}

now when i try to use this class from webreport viewer :

ClassLibrary1.

Report1 rpt = new ClassLibrary1.Report1(cn.ConnectionString);

rpt.constr = cn.ConnectionString;

ReportViewer1.Report = rpt;

Viewer shows this twice :

An error has occured while processing TextBox 'textBox1':
Missing operator before Name operand.


		An error has occured while processing TextBox 'textBox1': Missing operator before Name operand.

can you tell me whats going wrong wrong?

1 Answer, 1 is accepted

answered on 16 Nov 2009, 09:17 AM

Hello nishant mehta,

First we would like to ask, why you've taken out code from the InitializeComponent() method and placed it in the report constructor? The Report Designer does a great deal of work to simplify common tasks, so that you do not have to deal with the underlying code, which is not always trivial.
In this line of thoughts, if you have used the designer to add the desired fields, then the Value for the textbox would be proper, namely:

this.textBox1.Value = "=Fields.[Company Name]";

The "[]" brackets are used only for the database column name whenever there is a space. Using it to "wrap" the whole expression is simply wrong.

Best wishes,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.