I have a subreport that I wrote formulas to look at a date range and pull the amount pledged. It works except it shows a row for each year. So if a person has a pledge payment for 6 years the first column is 2018 it is showing a row for 6 years starting with 2017.
2018 2019
$0.00 $0.00
$25,000 $0.00
$0.00 $25,000
So on and so forth
I would like each year to be on the same row with the pledge amount.
Thank you for any advise
Hi Kim,
Insert a 'Summary' for each year column.
Use the Max/Sum function on the Pledge Amount field and place the summary field on the group footer/report footer.
Suppress the details section.
That should give you a single row for every year with the dollar amounts.
-Abhilash
Abhilash,
Thank you, the minute I read your answer I said to myself of course.
Your the best.
Kim
Add a comment