I am trying to add a Restriction to my report to block all Zero balances from printing.
Asking it to Exclude the Zero Balances thru the Sales Analysis Report Options is not excluding ALL the zeros.
I get no accounts listed.
TY again for your assistance. Y'all are life savers.
Try using the Current Trx Amount field in the RM Open table.
Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITSASCI, Inc. * PO Box 600965 * Dallas, TX 75360 * 972-814-8550 * firstname.lastname@example.org
I used the Customer Balance filed from the Customer Master Summary table.
Of course now the report does not give me a total. Is this a calculated field?
How do I give this report a total?
Are you printing the report in Summary, or in Detail?
If you are printing in Detail, I think you will be better served by using the Current Trx Amount field in the RM Open table.
If you are still having problems with this, I would be happy to take a peek at it for you. If you would like me to do that, please e-mail me the package file. email@example.com
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics