SQL SERVER 2005 Reporting -- sql server reporting services

bjones
10/25/2006 3:05:44 PM

I can't seem to use the ReportItems method of accessing other populated cells on SQL 2005. ie. ReportItems!textbox88.value. I get the following error:

[rsRuntimeErrorInExpression] The Value expression for the textbox ‘textbox139’ contains an error: Input string was not in a correct format.

Can you help me? TIA

From http://www.developmentnow.com/g/115_2006_9_0_0_0/sql-server-reporting-services.htm

Posted via DevelopmentNow.com Groups

Amarnath
10/25/2006 10:08:01 PM

Try to give some thing like this

=First(ReportItems("Textbox88").Value)

Amarnath

[quoted text, click to view]

bjones
10/26/2006 7:09:14 AM

I tried it, but it didn't work. The exact expression is:

=cdbl(reportitems("textbox119").Value) / cdbl(reportitems("textbox126").Value)

From http://www.developmentnow.com/groups/viewthread.aspx?newsgroupid=115&threadid=839799

Posted via DevelopmentNow.com Groups

Bruce L-C [MVP]
10/26/2006 9:24:28 AM

What are you trying to do. Are you just trying to have one field in a table
equal this expression. Use the expression builder and select the appropriate
fields. I never refer to the control, I refer to the dataset field.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : SQL SERVER 2005 Reporting