Necmi Göcek
10/31/2005 8:50:00 AM
You can achieve this without writing a line of code. If you use AutoDesign.
1) Set your Datasource''s order mode property to group by.
2) Add Department and Unit to Sorting node.
3) Right click fields -> New -> Count (Be sure this field int or real!)
4) Set Grand Total property of your AutoDesignSpecs to yes.
5) Add fields (Department, Unit and Counter field) to your design.
6) Set Sum All property of your Counter field to yes.
--
_MIB_
"G" wrote:
> Dear All,
> I am new to x++. I need to understand how grouping works in reports.
> I want to display report with 2 nested groups
> Group 1: Department
> Group 2: Unit (subgroup of department)
> Details : Employees
>
> I need to display count of records in both groups i.e. number of employees
> in each unit and number of employees in each department.
>
> How can I do that
>
> --
> Thank You and Best Regards