sql server reporting services: how to total fields within footer -- sql server reporting services

how to total fields within footer

silverblatt NO[at]SPAM att.net
8/3/2006 1:21:27 PM

sql server reporting services:

I have a report footer which includes a number of totals fields. Each
of those fields is computed based on various fields in the data set,
using some rather long expressions.

What I need now is to add a new "super total" field that displays the
sum of three of the other total fields. The only way I can reference
the other three fields in the new field's Value property (without
getting a build error) is with an expression like:

=ReportItems("txtTotal1").Value+ReportItems("txtTotal2").Value+ReportItems("txtTotal3").Value

But even then, the new field shows "#Error" anyway. Does anyone know
how to make this work?

RE: how to total fields within footer

magendo_man
8/4/2006 4:40:02 AM

Try:

=ReportItems!txtTotal1.Value+ReportItems!txtTotal2.Value+ReportItems!txtTotal3.Value

HTH,
Magendo_man

[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 in the sql server reporting services group.