Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

For most standard reports of the system, developers reports have implemented the ability to set fields by which data in the report will be grouped.

Predefined groupings are available to the user in the Quick Settings panel:

In the default "Group by" section user may select attributes that would be used for group data in the report and the user may set the order of groups (move them using the up and down arrows Image Removed).

Grouping of data in the report by selected fields will be applied in the order in which they are located in the Group by section.

...

To adjust grouping settings, open the Grouping Fields tab. Depending on the report's structure level (upper area), you can add or change groupings.

For example, if you want to To add a grouping by folder in which to the item is located , in the inventory balance report, follow these steps:report Balance of Inventory (By warehouse) report, do the below steps-

Open the Change Report Variant and navigate to the Grouping Fields tab.

Since this grouping should be at a level above Item (in the Balance of Inventory report, this would be the Warehouse level), select the level above Item and click Add to introduce the new grouping.

Image RemovedSelect the Add button in the top panel of the screen, and then choose the new grouping option (To keep it above the item level, select the higher level field and click Add)

Image Added


On the Grouping Fields tab, you can edit a new grouping and choose its type: Elements, Hierarchy, or Hierarchy Only.

Image RemovedImage Added

Image Added

Note that when : When a new report grouping is added, it will appear on show up in both the Grouping Fields tab and the Report Structure. You can edit modify the grouping in either areasection.

After saving Once you save the changes, the report will include incorporate the new grouping (e.g., Item. Folder), and this grouping will also be available appear in the Group By section of the Quick Settings panel.

Image RemovedImage Added

The user can save their settings as anew report variant for later use.

Thank you for being a FirstBit customer!