[Solved] How to remove last 0.00 line in detail section
I am trying to understand why do that 0.00 appears in my report, and how to remove it. Any ideas?
For those of you facing this issue with your reports, here's the solution that worked for me:
=IIf([ARTran.InventoryID]<> Null, [ARTran.CuryTranAmt], '')
Hope this helps other people!
Hi Gustavo, it's good that you solved your own problem, but seeing as you are dealing with what I am sure is a custom report, IMHO, the better way to solve this is to filter the data from the report. In other words add a condition to the Filters tab to exclude any rows with InventoryID is null.
That's also a great way for solving this issue! Thanks a lot!