i was trying to customize the sales invoice line Report.
what i wanted was to pull details of charges and hide the columns when value are zero in the footer part of the report?
I put the hidden condition for all the rows in footer.
I created a new table for the charges which will display details in the group footer.
Values are getting pulled as required, but the issue is either of these -
- Either i am getting blank lines if the values are empty.
- If the body have multiple rows the charges details are getting overlapped in the footer section.
Please let me know if someone know how it can be resolved.
Thanks & Regards,