Balance sheet level 3 & 4 report not displaying all numbers.

[DeannaK]

I am trying to generate a Balance Sheet at level 3 detail.  The Totals in the far right column (the 3rd column) are not displaying properly.  They are actually only showing the digits of the cents.  So where the number "$8,761,333.68" should be, it is showing "68".  I have changed margins and changed to landscape but the numbers display the same.  I have the  same problem with level 4.  Level 1 & 2 are ok.

I can export the report to Excel and all the figures come across correctly, so this is my work around for the moment.

[Komal_S · Accepted solution]

Hi @DeannaK 

This happens as the column widths don't auto scale while displaying reports. In order to resolve it, you would have to manually adjust columns in the Insert/Modify tab each time you run the report in level 3 or 4 as shown:

Please let me know if you have additional questions.

[DeannaK]

Thank you @Komal_S ,

I went in to the balance sheet report and can see where to adjust the column widths, as you described.

Of course today all of the numbers are fitting & displaying perfectly so there is not problem!

I will remember the column width adjustment for the future.