Question
Santander
BR
Last activity: 18 Apr 2018 16:07 EDT
How export report definition in Pega 7.3 ?
I try export report definition in Pega 7.3. I have report definition in class Sant-ContactC-Work-Contestacao and create a dashboard in Data-Portal. I try call a activity in class Data-Portal so call a activity OOTB MSOExcelFIle for export. But not work.
How I export excel in a link in dashboard
Accepted Solution
CPF
SG
Hi,
If you want export the Report definition results then You can Use the "pzRDExportWrapper" OOTB Activity. Steps tro use this activity is
step 1: Set Parameters Param.pyReportClass, Param.pyReportName.
Step 2: Call pxRetrieveReportData OOTB Activity (step page should be in the context of Rule-Obj-Report-Definition)
Step 3: Call the pzRDxportWrapper Activity .step page should be (pyReportContentPage.pyReportDefinition)
in Pages and classes
pyReportContentPage----Code-Pega-List
pyReportContentPage.pyReportDefinition ----Rule-Obj-Report-Definition
Follow the steps context or step page names as shown in screen Shot
Pegasystems Inc.
US
HI Daniel,
MSOGenerateExcelFile is not intended to be a replacement for the OOTB export to Excel reporting feature.
Your use case, calling MSOGenerateExcelFile in your "Testando" activity to do 'export', will not work.
Thanks,
Susan
Pegasystems Inc.
IN
Hello ,
You can go through below article as a reference
https://collaborate.pega.com/question/how-msogenerateexcelfile-works-719
Accepted Solution
CPF
SG
Hi,
If you want export the Report definition results then You can Use the "pzRDExportWrapper" OOTB Activity. Steps tro use this activity is
step 1: Set Parameters Param.pyReportClass, Param.pyReportName.
Step 2: Call pxRetrieveReportData OOTB Activity (step page should be in the context of Rule-Obj-Report-Definition)
Step 3: Call the pzRDxportWrapper Activity .step page should be (pyReportContentPage.pyReportDefinition)
in Pages and classes
pyReportContentPage----Code-Pega-List
pyReportContentPage.pyReportDefinition ----Rule-Obj-Report-Definition
Follow the steps context or step page names as shown in screen Shot
Santander
BR
Hi Renuka,
I created the "Testando" class in Data-Portal how you recommended.
The activity worked if I go in action and run with you to download the report.
But if I call these same menu activity in the Data-Portal class does not work.
Here is the print of Activity and how I am calling activity in a menu