Skip to Content
Sep 04, 2018 at 06:42 AM

How to hide empty row from grouping in SAP Business One HANA "Excel Report" Add-In?

110 Views Last edit Sep 04, 2018 at 09:25 AM 2 rev

Hi Dear Experts!

May be you know if it is possible via "Excel Report" Add-In in SAP Business One HANA to hide empty grouping rows?

I have a requirement from the Customer to create a report with grouping data by Department - Level 1, Department - Level 2, Department - Level 3.

But not all departments have 3 levels, some of them have only 1 or 2 levels.

We manage departments via custom UDTs: the first one UDT - @DEPARTMENT contains a list of all possible entities, the second one - @ORGSTRUCTURE contains relations (parent, child...) between departments for each financial year.

The calculation view has the following fields:

  • Date
  • Region
  • Department - Level 1
  • Department - Level 2
  • Department - Level 3
  • AMOUNT ....

If I create report with groups in rows, in preview mode it shows empty rows for departments that do not have level 3 or level 2.

We need to group data by Year, Month, Region, Department - Level 1, Department - Level 2, Department - Level 3 and do not show empty rows if departments Department - Level 2 and/or Department - Level 3 are empty.

Do you know is it possible or not to do in in "Excel Report" Add-in? Thank you in advance.

Kind regards, Anastasia