sql server reporting services: Sum in report footer -- sql server reporting services

Sum in report footer

Ron Wilson
9/21/2007 1:36:05 PM

sql server reporting services:

I have seen this question asked several times but none of the solutions have
worked for me.

I am running SRS 2005 and have a very basic report written. I am wanting to
sum a detail field in the footer. My code in the footer goes something like
this:

=sum(fields!<fieldname>.value)

Where <fieldname> is the name of the detail field I want to sum. I get a 0
for an sum whether I have 1 item or 100 items in the group.

Can anyone help? Is this enough info to help?

Thanks,

RE: Sum in report footer

Ron Wilson
9/21/2007 1:40:03 PM

Let me update that...sorry! I do not get a 0 value in the summed footer. I
appears that I get all of the data in the dataset summed. Meaning if there
are 1000 rows in the data set, but only 100 rows are generated on the report
per the parameters, it still appears to sum all 1000 rows.

[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.