Skip to Content

Showing multiple lines in Subreport

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 15, 2018 at 02:10 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • How do I do grand totals. Sorry it is just been a while and I left my books at home. Maybe I should group the people instead of putting them it in the footer and then total. I tried doing a variable but that doesn't seem to be working. Sigh.

      Any help is appriciated.

  • Aug 15, 2018 at 05:15 PM

    Abhilash,

    Thank you, the minute I read your answer I said to myself of course.

    Your the best.

    Kim

    Add comment
    10|10000 characters needed characters exceeded