Forum Discussion

DeannaK's avatar
DeannaK
Trusted Cover User
6 years ago
Solved

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

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.

 

  • 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.

2 Replies

Replies have been turned off for this discussion
  • DeannaK's avatar
    DeannaK
    Trusted Cover User
    6 years ago

    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.

  • 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.