ReportItems and Columns - URGENT!

I have a textbox in a table with one group, I am using the Switch( ) command
to get a numeric result for that textbox. at the end of the report I want to
add those values for that text box.
I tried using Sum(ReportItems!Textbox1.Value) but I keep getting an error,
I need to do this in SRS, not in a storeproc, how do I add up the colum?
Remeber that the textbox inherits different number values, I used to be able
to do this in access.
VZSince I have no responses, let me explain it more simple...
|--|
| Total (Header) | This is where I want my total (Sum of TextBox1)
|--|
| TextBox1 (Details) | This is where my Formula calculates a number.
|--|
The formula uses...
Switch
(
a=1,"325",
a=2,"500",
a=3,"488"
)
etc.
Why cant I sum up the total value of ReportItems!Textbox1.Value '?
I has to be simple.
VZ
"DragonVic" wrote:
> I have a textbox in a table with one group, I am using the Switch( ) command
> to get a numeric result for that textbox. at the end of the report I want to
> add those values for that text box.
> I tried using Sum(ReportItems!Textbox1.Value) but I keep getting an error,
> I need to do this in SRS, not in a storeproc, how do I add up the colum?
> Remeber that the textbox inherits different number values, I used to be able
> to do this in access.
> VZ