Posted: 13 Jun 2018 1:14 EDT Last activity: 26 Jun 2018 15:33 EDT
Custom section in report definition output
Is anyone aware of any section extension points in a report definition output? The purpose is to display custom summary of the results.
E.g.: After I run a report definition to display all the workobjects in a class group, I want to report a count of the number of cases in a certain status. I would like this count to be displayed either at the top of the results or at the bottom after the list view.
I know that one way to achive this is to display the content at the top using 'display filter using custom section' and disabling filter changes but this will not work if I do actually want to enable filters.
You could try retrieving the report definition content in an activity
Call Rule-Obj-Report-Definition.pxRetrieveReportData OR Call Rule-Obj-Report-Definition.pxShowReport.
When you call the pxRetrieveReportData, all the report data will get stored in pyReportContentPage. Also, data will be mapped to the page mapped to "pyPageName" parameter in the method call. This pagelist could be configured in the UI display the content.
You could retrieve or manipulate the data according to your business requirement by iterating and maintaining the count. Then store the count and other value in a property to be displayed in the UI.
I just tried to give an idea, though didn't implement in-house. Kindly notify, if it works.
I'm afraid there are no extension points in the report viewer.
For list reports, you might try enabling grouping under the Report Viewer tab and setting the sort order of the status column to 1. This would group items in the list by status and display a count next to each status.