Question
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
How can we do export to excel in the "Testando" activity?
Was there an example?
Thanks
Daniel
Hello ,
You can go through below article as a reference
https://pdn.pega.com/community/product-support/question/how-msogenerateexcelfile-works
Accepted Solution
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
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
Sorry, it is work activity now
I no has checked CheckBox "Allow direct invocation from the client or a service"
Thanks
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