Recursive group hierarchy and dynamic grouping.

[Steve]

I have a report that's supposed to show a list of employees who haven't swiped in or out, and which swipe they missed. I'm having trouble getting it working the way I need it to work, so I'm hoping someone can help me out. I can't seem to attach the report file here, so I've attached some screenshots. 

The report will be organised in a group hierarchy, but the groups themselves won't be specified in the report. In the attached sample report they're grouped by Location, Building, and Department, which for this example have been specified manually in the GroupTypes and GroupHierarchy CSV sources, but different companies might have different group hierarchies. For example they might only have 'Location' and 'Department', or they could have several other groups. Essentially the report should be able to handle any group hierarchy without needing to update the report manually.  I've seen people saying they solved this by using recursive sub-reports, but so far I haven't been able to get this working. 

The user running the report also needs to be able to select how the results are grouped, so in this example the user might want to display a list of employees in each building, ignoring the department, or they might want to display the employees per location. Would this be possible using the Toggle Visibility action on the group headers? The employees would need to be ordered by name, ignoring any hidden departments. I'm not sure if this is possible with the way the report is structured at the moment.

The actual report will be getting the data using Object Data Source methods, I've created the CSV objects to represent what they look like. The GroupHierarchy and GroupType CSV objects were created for this example, so these can be changed if necessary.

Thanks to anyone who can help me out with this.

[Elena]

Hello Steve,

I've attached a sample report that uses Report Parameter with Fields function that allows you to group dynamically by a column name.

You can also check out these documentation links for more information:

https://docs.telerik.com/reporting/designing-reports-parameters

https://docs.telerik.com/reporting/expressions-report-functions

Regards,
Elena
Progress Telerik