Ask Your Question

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

asked 2017-12-21 22:10:23 +0200

kasloman gravatar image

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.

image description

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-12-21 22:31:33 +0200

Ratslinger gravatar image

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

edit flag offensive delete link more


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


kasloman gravatar imagekasloman ( 2017-12-22 00:30:31 +0200 )edit

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

Jim K gravatar imageJim K ( 2017-12-22 08:53:04 +0200 )edit

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

Ratslinger gravatar imageRatslinger ( 2017-12-22 23:34:29 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-12-21 22:10:23 +0200

Seen: 140 times

Last updated: Dec 21 '17