Options

Main Grouping and sub Grouping in Dynamics nav 5.0

FreakyFreaky Member Posts: 125
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

  • Options
    tinoruijstinoruijs 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
  • Options
    FreakyFreaky Member Posts: 125
    Thanks Tino. It works. Appreciate it.

    Regards,
    Fred.
  • Options
    tinoruijstinoruijs Member Posts: 1,226
    Nice. You're welcome. :-)

    Tino Ruijs
    Microsoft Dynamics NAV specialist
Sign In or Register to comment.