Report with nested data grouping
Posted: Wed Mar 20, 2019 3:26 pm
Dear Stimulsoft community,
let me try explain my use case:
I would like to create a report which groups data on different levels (in a nested way).
1. On the first (highest) level the grouping should be upon some "events" which occur periodically during year (e.g. public days).
2. On the second level the grouping should continue on the roles in the company (CEO, CFO, Project Manager, etc.)
3. On the third level the grouping shold be followed upon the working place (sitting place in company, home office, etc.)
And below the third level, all business processes should be written out which have a certain criticality (there I would probably use a filter in the data band).
I am using an XML as a data source. The relevant objects/nodes in the XML for this use case are:
- Criticality
- Business Process
- Roles
- Link_BusinessProcess_Criticality
- Link_BusinessProcess_Role
I was trying to solve this with nested groups headers and group footers, but I am not getting the result I want.
My thoughts when grouping were:
- on the first level (1.) the condition for the group header is based on an attribute (event) from "Link_BusinessProcess_Criticality"
- on the second level (2.) the condition for the group header is based on an attribute (role) from "Role"
- on the third level (3.) the condition for the group header is based also on an attribute (sitting place) from "Link_BusinessProcess_Role"
- and then I'd like to write out the business processes upon the mentioned criticality (with a condition which is only company relevant for their intern criticality)
A pseudo example:
-- EVENT 1 --
----- ROLE 1-----
-------- WORKING PLACE 1-------
------------- BUSINESS PROCESS 1--------
------------- BUSINESS PROCESS 2-------
------------- BUSINESS PROCESS 3-------
-------- WORKING PLACE 2-------
------------- BUSINESS PROCESS 4 -------
------------- BUSINESS PROCESS 5 -------
----- ROLE 2 -----
-------- WORKING PLACE 1 -------
------------- BUSINESS PROCESS 1--------
------------- BUSINESS PROCESS 2-------
------------- BUSINESS PROCESS 3-------
-------- WORKING PLACE 2 -------
------------- BUSINESS PROCESS 1--------
-- EVENT 2 --
...
etc.
The obstacles were/are - I am not sure if it is possible to do grouping over different nodes in the data source (e.g. XML) which I listed above.
I appreciate your time and help!
Kind regards
let me try explain my use case:
I would like to create a report which groups data on different levels (in a nested way).
1. On the first (highest) level the grouping should be upon some "events" which occur periodically during year (e.g. public days).
2. On the second level the grouping should continue on the roles in the company (CEO, CFO, Project Manager, etc.)
3. On the third level the grouping shold be followed upon the working place (sitting place in company, home office, etc.)
And below the third level, all business processes should be written out which have a certain criticality (there I would probably use a filter in the data band).
I am using an XML as a data source. The relevant objects/nodes in the XML for this use case are:
- Criticality
- Business Process
- Roles
- Link_BusinessProcess_Criticality
- Link_BusinessProcess_Role
I was trying to solve this with nested groups headers and group footers, but I am not getting the result I want.
My thoughts when grouping were:
- on the first level (1.) the condition for the group header is based on an attribute (event) from "Link_BusinessProcess_Criticality"
- on the second level (2.) the condition for the group header is based on an attribute (role) from "Role"
- on the third level (3.) the condition for the group header is based also on an attribute (sitting place) from "Link_BusinessProcess_Role"
- and then I'd like to write out the business processes upon the mentioned criticality (with a condition which is only company relevant for their intern criticality)
A pseudo example:
-- EVENT 1 --
----- ROLE 1-----
-------- WORKING PLACE 1-------
------------- BUSINESS PROCESS 1--------
------------- BUSINESS PROCESS 2-------
------------- BUSINESS PROCESS 3-------
-------- WORKING PLACE 2-------
------------- BUSINESS PROCESS 4 -------
------------- BUSINESS PROCESS 5 -------
----- ROLE 2 -----
-------- WORKING PLACE 1 -------
------------- BUSINESS PROCESS 1--------
------------- BUSINESS PROCESS 2-------
------------- BUSINESS PROCESS 3-------
-------- WORKING PLACE 2 -------
------------- BUSINESS PROCESS 1--------
-- EVENT 2 --
...
etc.
The obstacles were/are - I am not sure if it is possible to do grouping over different nodes in the data source (e.g. XML) which I listed above.
I appreciate your time and help!
Kind regards