Report Total (1 Viewer)

Bechert

Registered User.
Local time
Today, 20:20
Joined
Apr 11, 2003
Messages
59
Hello, I am working on a patient billing statement report that will be mailed once a month to those patients with a balance due greater that zero.
The balance due is calculated when the report is created.

The sub report lists the charges and payments made for each item then calculates the balance due in the footer of the sub report.

Is there a way to suppress those statements with a zero balance at the time the report is created?

Thanks for your help.
Bill
 

NauticalGent

Ignore List Poster Boy
Local time
Today, 16:20
Joined
Apr 27, 2015
Messages
6,286
My approach to this type of issue has always been to weed out the unwanted before the report runs. In other words, base the report on a query to only includes those records that will result in a balance that is greater than zero.
 

Gasman

Enthusiastic Amateur
Local time
Today, 20:20
Joined
Sep 21, 2011
Messages
14,047
I would have thought you'd want to ignore them for the report?
I'd create an aggregate query to get the balances and then link back to the patients for those records that will go to the report, ignoring those with a balance of zero in the aggregate query.?
 

Users who are viewing this thread

Top Bottom