Newbie question about SUMs
I have a report that lists several fields for a bunch of records, most of
the fields being currency fields. What I want to do is show the SUM of each
of the currency fields at the end of the report. Ideally, I would like these
SUMs to appear directly below the last record's values (separated by a
divider line). When I put the the SUM fields in the Footer of the report,
they of course appear at the end of each page with the totals to that point.
How do I accomplish what I'm after here...must be simple and I'm missing
something. Perhaps using some bogus Group that would include every record
and then use the Group Footer?
the fields being currency fields. What I want to do is show the SUM of each
of the currency fields at the end of the report. Ideally, I would like these
SUMs to appear directly below the last record's values (separated by a
divider line). When I put the the SUM fields in the Footer of the report,
they of course appear at the end of each page with the totals to that point.
How do I accomplish what I'm after here...must be simple and I'm missing
something. Perhaps using some bogus Group that would include every record
and then use the Group Footer?
This discussion has been closed.
Comments
I am also new to the ReportBuilder, but I had the same problem, but solved
this by using the "Summary" band from RB designer menu Report, Summary. This
works fine !
Petter
as the Summary Band was appearing below the Footer Band...silly me!
Nice to be able to help.
Petter