Main Grouping and sub Grouping in Dynamics nav 5.0

Freaky

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.

tinoruijs

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.

Freaky

Thanks Tino. It works. Appreciate it.

Regards,
Fred.

tinoruijs

Nice. You're welcome. :-)