Hi all,
I am working on a report that has rows that need to be conditionally hidden. The data I'm working with is this.
[Customer],[PymtDate],[PastDue],[CurrentBalance]
I want to get the sum of all of the [CurrentBalance] records but I want to hide the rows from displaying in the report where [PymtDate] & [PastDue] are blank.
Sample data:
[Customer],[PymtDate],[PastDue],[CurrentBalance]
Doe, John,6/1/2011,-1,1000.00
Doe, John,1/1/2011,-1,2000.00
Doe, John,,,500.00
Doe, Jan,6/1/2011,-1,1000.00
Doe, Jan,6/15/2011,-1,300.00
Desired Output in Report:
Doe, John -- $1,000.00
Doe, John -- $2,000.00
Doe, John -- Totals: $3,500.00
Doe, Jan -- $1,000.00
Doe, Jan -- $1,300.00
Doe, Jan -- Totals: $2,300.00