BASE REPORT WRITER How to add the Total of a column in footer

[kasloman]

I am basing a report on a number of fields, some of which I want totals on. Is there any way to add a sum(field) to the footer of the report. Like adding a calculated field.

It seems to me it takes two queries to do this, but how do you base a report on two queries?

Thanks for help, R

[Ratslinger]

Do this in Report Builder not query. Steps & sample on this post.

[kasloman]

Thanks much, I now see what a text box can do!!

R

[jimk]

@kasloman: It sounds like this answer helped, so please mark the answer correct, as explained in guidelines for asking.

[Ratslinger]

If this answers your question please tick the (upper left area of answer). It helps others to know there was an accepted answer.