Data page as the source of Report
We have a requirement to execute a Stored Procedure which takes parameters. This stored procedure returns Oracle Table Types as return, I am able to execute the stored procedure using activity, rdb-list and get data in resultset. But requirement is to display the data using report definition as they want all the OOTB functionalities of report viewer viz Export to Excel, Export to pdf, filter etc.
Is there a way to execute a report on a Data set or resultset instead of directly querying the database table ?
Accepted Solution
Pegasystems Inc.
US
Hi Vikash,
I had cross checked the report definition functionality in 7.2.2 also, but i dont see any option to source the Data-set or resultset to report definition.
Suggestion1:
- Use the Data Page(list type) as source to the repeat grid in the section
- Try to add the functionalities of ExportToExcel(pzViewExportToExcel activity), ExportToPdf(pzViewExportToPdf activity) with the help of these activites and by default grid will have the filter condition.
Suggestion2:
- If possible try to map your external database table with the Pega class structure using Database Class Mapping wizard as explained here.
- With the help of this class you can write your own report definition.
Hope this might be helpful to you.
Regards
Mahesh
Pegasystems Inc.
IN
Hello Vikash,
Are you looking for dataset execute method then please have look into below article .
https://community.pega.com/sites/default/files/help_v722/procomhelpmain.htm
or your requirement is something else please let us know .
Thanks,
Arun
Cisco Systems Inc
US
Hi Arun,
I am not looking for dataset execute method. I am just looking a way to use report definition rule to display data fetched from a stored procedure instead of directly executing the report on a database table.
Thanks
Vikash
Accepted Solution
Pegasystems Inc.
US
Hi Vikash,
I had cross checked the report definition functionality in 7.2.2 also, but i dont see any option to source the Data-set or resultset to report definition.
Suggestion1:
- Use the Data Page(list type) as source to the repeat grid in the section
- Try to add the functionalities of ExportToExcel(pzViewExportToExcel activity), ExportToPdf(pzViewExportToPdf activity) with the help of these activites and by default grid will have the filter condition.
Suggestion2:
- If possible try to map your external database table with the Pega class structure using Database Class Mapping wizard as explained here.
- With the help of this class you can write your own report definition.
Hope this might be helpful to you.
Regards
Mahesh
Cisco Systems Inc
US
Thanks Mahesh, I know I can use the activities like ExportToExcel(pzViewExportToExcel activity), ExportToPdf(pzViewExportToPdf activity) etc, but since there are 18 such reports, i wanted to avoid them. But looks like there is no such way in Pega to show resultset data on Report Viewer. Thanks for your reply