Main Grouping and sub Grouping in Dynamics nav 5.0

Freaky
Freaky Member Posts: 125
edited 2014-12-01 in NAV/Navision Classic Client
Hi guys, I can group by a field in a report but I have challenges having sub groups under a main group in a report. Please kindly assist.

For example: I have a field called locations an another field called JobTitle so I want to group by locations and then have sub groups of each JobTitle under a location. Finally I want to be able to count all employees within a particular job title.

Both fields are from one table.


Thanks in advance.

Regards,
Fred.

Answers

  • tinoruijs
    tinoruijs Member Posts: 1,226
    You can create a key for locations and JobTitle.
    Then use a wizard to create a new report which uses this new key.
    The wizard will create the needed code in the report for grouping.
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • Freaky
    Freaky Member Posts: 125
    Thanks Tino. It works. Appreciate it.

    Regards,
    Fred.
  • tinoruijs
    tinoruijs Member Posts: 1,226
    Nice. You're welcome. :-)
    Tino Ruijs
    Microsoft Dynamics NAV specialist

Categories