hide empty rows in account schedule

gemini_shootergemini_shooter Member Posts: 149
Hello guys,

I am wondering if there is an easy way to hide Empty ROWS in a account schedule.

I created an account schedule for a profit and loss statement and want to hide the rows which do not have values in the accounts for a period.

for e.g. my acct schedule goes like this:

Sales Products
Sales Shipping
Sales Storage
....
....

I want to hide the row sale shipping if it does not have values for a period on the print out.
Thank you

Comments

  • ara3nara3n Member Posts: 9,256
    You need to modify the account schedule report and add an option for the user to check to hide zero rows.

    Then onPresection of every body section of the report add code that looks like this. There about 4 body sections.
    If HideZeroColumn then begin 
      NonZeroFound := false;
      for I := 1 to Arraylen(ColumnValuesAsText) Do
        if ColumnValuesAsText[I] <> 0 then
          NonZeroFound := true;
    
     CurrReport.showoutput(not NonZeroFound);
    end;
    
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • ara3nara3n Member Posts: 9,256
    Actually I just looked in account schedule there is a Show field and has an option If Any Column Not Zero. Set that and it will work :D
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.