Question
How to group by on grouped records in a Report Definition?
Hi All,
I have requirement on a report which says to pull the count of open, resolved and withdrawn sub-cases of every parent case as below. Both the parent case and sub-cases are queried on the same work pool table. We have marked a property (LIQID) on every sub-case which contains the parent case's pyID. PFA doc for design screenshots.
I have two queries in specific in the process of trying a solution for the above.
1. I have tried grouping by on LIQID so that it will pull all sub-cases of a parent LIQ case but the group by clause is not generating just on LIQID but on all other columns. How to achieve this?
2. Once achieving the above, I have to query on each group to pull the count of open, withdrawn and resolved sub-cases in a list-view format.
Parent Case ID | Count of Open Sub-cases | Count of Withdrawn sub-cases | Count of resolved sub-cases
Thanks a lot in advance.
Regards,
Giridhar M
Alternatively, if you want only three columns, namely,
-Parent key
-Child count
-grouped by work status
you can have a single RD in child class with columns pxconverinskey, count of pyid and pystatuswork.
Please find the RD configuration screenshots and the result screenshots.
Adding any more properties makes the Report Definition clumsy and less pleasing to use.
Hope this helps.
--Ravi.
Hi Giridhar,
For this requirement, you have to use the concept of sub-reports.
Have the main report in the parent class and have the sub-report in the child class which does the grouping on work statuses.
Please find the configuration screenshots of both the reports and the result. Using the configuration given in below screenshots answers both your questions.
Hope this helps.
--Ravi.