Posted: 8 Nov 2019 9:53 EST Last activity: 24 Mar 2020 11:34 EDT
Ask the Expert - Reporting with Sumanth KRVB
Join Sumanth KRVB (@Sumanth) in this Ask the Expert session (18th - 22nd Nov) on Reporting!
Meet Sumanth: Sumanth is a Senior Software Engineer at Pegasystems and responsible for Reporting capabilities in the platform. He has good hands-on experience in the User Interface and mobile areas of the Platform as well. He has over 8 years of development experience and recently celebrated his 6th anniversary with PEGA.
Message from Sumanth: Hello Everyone! I am excited to be part of this Ask the Expert session. I am looking forward to answer any questions that you may have with the Reporting and Charting capabilities in the Pega platform.
Me and my team have been working in parallel different projects using the Pega Platform, and because we want consistency on the UI on all applications.
We need to identify which component styles is being used in each section.
I did found an option, and is by going straight to that component and on the actions dropdown, you click on the List sections. And this will generate you a list of section where the selected component is being used.
Once the list is generated, I copy and paste it in a excel file. (So I complete list in a single file and there is no export option to generate this report)
Because I am copy & pasting, I wanted to know if there is already a feature in Pega where it can automate this process.
The data we get in the "List Sections" popup is dependent on two parameters "component" and its "format".
We get different lists for different formats.
So, even if the "Export" option is available in the popup, you might end up creating multiple excel files for different component formats and merge them into a single file.
I agree that, it would have been nice if we had that option, but it might not help you much with your usecase.
Please let me know if you need any other information on this.
On a side note, we always recommend to use UI-Kit that gives you greater consistency across different screens/applications. This might just limit your manual effort to handling minimal customizations(if there are any).
I have requirement in Report Definition to show the Grand total for Columns I have, let's say i have an Rd with 3 Columns which holds 3 records fetched from DB table. so I need display 4th row as Grand total which holds the sum of respective column values. Attached Screen shot for reference. I believe it can be done using Function, KIndly let me know if there is any pega provided OOTB function to sum up the column values or I can tweak form any other java code available.
I guess you could just summarize the required columns with "Sum" option.
In your example, you can do it for iphone, oneplus, redmi columns.
And the report looks like this.
I know it looks different from how you are expecting. Reports directly get the data from the table records and so you can only have good control over columns, like what data any column should have, applying formats and functions etc.
Coming to row capabilities, you can fetch/avoid few rows based on the filtering criteria. But it is not possible to display heterogeneous row data(in your example, total sales count for one row and provider sales count for other rows) in a report unless the summarization is applied.
If you slightly tweak your example to add total sales for each provider in a separate column, this is achievable by using sum function as a source for the fifth column(i.e., Total) that takes all the three column sales as inputs.
Hope this helps! Please let me know if you have any other questions on this.