Calculating problem in tables

Hi,
in my report I have two tables, that look like this
--table1
x y z (=y-x) where x is a database field, y is a hard number
en z is the result of y-x
--table2
x y z (=y-x) where x is a database field, y is a hard number
en z is the result of y-x
--
I want to sum the x, y and z values in another table.
the sum of the database field (x) isn't a problem, but
the sum of y and z doesn't work,
I've tried this: (textbox1.Value, "table1")+(textbox2.Value, "table2")
but it's not possible to do this with textboxes.
Can anyone help me with this problem?Dirkjan van Groeningen wrote:
> I've tried this: (textbox1.Value, "table1")+(textbox2.Value, "table2")
> but it's not possible to do this with textboxes.
> Can anyone help me with this problem?
I dont know...have you tried an expression like this?
=Fields!textbox1.Value + Fields!textbox2.value
regards
Frank
www.xax.de|||Hi Frank,
I've tried it, even with the expression , "table1" behind the textboxes to
set the dataset scope. Got the following error
The value expression for the textbox â'textbox11â' refers to the field
â'textbox9â'. Report item expressions can only refer to fields within the
current data set scope or, if inside an aggregate, the specified data set
scope.
"Frank Matthiesen" wrote:
> Dirkjan van Groeningen wrote:
> > I've tried this: (textbox1.Value, "table1")+(textbox2.Value, "table2")
> > but it's not possible to do this with textboxes.
> >
> > Can anyone help me with this problem?
> I dont know...have you tried an expression like this?
> =Fields!textbox1.Value + Fields!textbox2.value
> regards
> Frank
> www.xax.de
>
>|||Try:
=ReportItems!textbox1.Value + ReportItems!textbox2.value
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Frank Matthiesen" <fm@.xax.de> wrote in message
news:34i2d5F4aqquuU1@.individual.net...
> Dirkjan van Groeningen wrote:
>> I've tried this: (textbox1.Value, "table1")+(textbox2.Value, "table2")
>> but it's not possible to do this with textboxes.
>> Can anyone help me with this problem?
> I dont know...have you tried an expression like this?
> =Fields!textbox1.Value + Fields!textbox2.value
> regards
> Frank
> www.xax.de
>