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 ?
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.
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.
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.
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.
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