Column Report Total End of 2nd Column

[Bingo]

I have a column report set to two columns that sums PBO by state. I want to
have a total sum at the end of the report (after the last state listed). A
report total will be on a second page since the first column is the page's
length but the second column is only half a page.

I have a report header, detail, report footer. A query provides the summed
PBO by state. I want to have the total shown in the simple example below:

MD 5 NC 1
TX 4 WV 2
CA 3 TOTAL 17
SC 2

Thanks

 

[Marshall Barton]

I have a column report set to two columns that sums PBO by state. I want to
have a total sum at the end of the report (after the last state listed). A
report total will be on a second page since the first column is the page's
length but the second column is only half a page.

I have a report header, detail, report footer. A query provides the summed
PBO by state. I want to have the total shown in the simple example below:

MD 5 NC 1
TX 4 WV 2
CA 3 TOTAL 17
SC 2

Create a group with footer (View menu - Sorting and
Grouping) using a constant expression such as =1. Then add
your total text box with expression =Sum(PBO) to the group
footer.

 

[Bingo]

Worked great - thanks

Create a group with footer (View menu - Sorting and
Grouping) using a constant expression such as =1. Then add
your total text box with expression =Sum(PBO) to the group
footer.