We can use "ShowExcelView" (with the above parameters) activity instead of ViewExportToExcel to build a table from the query results and send it to MS Excel but this works only for List View and Summary View report types but not Report Definitions.

Please share your thoughts to export to Excel with report definition (or data page) as a source.

Got the solution for exporting to Excel with report definition (or data page) as a source using OOTB activity pzDownloadDataRecordsAsCSV.

This activity can be referenced using pxConvertResultsToCSV activity

Hi Kiran,

Tried solution provided by you, but nothing is downlloading. Called activity by passing required parameters through button click.

Thanks,

Gireesh.

Hi Gireesh, First try running the activity independtly without any button clicks and let me know.

I hope that are doing everything as mentioned in pzDownloadDataRecordsAsCSV activity i.e. loading the report defintion on a page first

yeah loading RD on a page first.  While running activity alone its downloading excel file in separate window.  What I have to do to work it on button click.

Please refer to the following article for your issue (export to excel - on button click)

https://pdn.pega.com/forums/activity/unable-to-call-export-to-excel-activity-on-the-click-of-button-the-standalone-activity-works-fine

Hi Kiran,

I got the excel downloaded through url. But where we need format the column headings, and if we want to format the date fields etc....... Could you please suggest how we can do this.

Thanks,

Gireesh.

Hi,

Call 'pzRDExportWrapper' through another wrapper activity on 'Open URL in New Winow' action on the page 'pyReportContentPage.pyReportDefinition' (Use the Page where ever you have the results of report) and pass 'excel' as parameter