Question
MacQuarie Bank Ltd
AU
Last activity: 23 Mar 2022 1:32 EDT
Excel Update in Pega Report
Hi All,
In my application we are exporting the report results to excel enabling macros, which is working only on IE with the help of the addon prImportManagerOCX.ctlobj.
As IE is getting disable any idea how to work with this.
If anyone has any addon supporting Edge browser please shareit.
Thanks in advance.
Mallikarjun
***Edited by Moderator Marije to add Capability tags***
Updated: 14 Mar 2022 11:45 EDT
Pegasystems Inc.
GB
The prImportManager OCX was replaced in Pega 7.1.7 with the Data Type Record Editor
PrImportManager was previously used for editing data tables with the data table editor. This feature was replaced by the new data type record editor in Pega 7.1.7.
I'm assuming that you are already familiar with the Client Side Technologies article.
As per the Platform Support Guide 7
Microsoft Edge will not support Silverlight.
See Pega Platform Client Operating System and Browser Support
Also see this forum question Silverlight alternative post 2021
How are you exporting your report to Excel?
The prImportManager OCX was replaced in Pega 7.1.7 with the Data Type Record Editor
PrImportManager was previously used for editing data tables with the data table editor. This feature was replaced by the new data type record editor in Pega 7.1.7.
I'm assuming that you are already familiar with the Client Side Technologies article.
As per the Platform Support Guide 7
Microsoft Edge will not support Silverlight.
See Pega Platform Client Operating System and Browser Support
Also see this forum question Silverlight alternative post 2021
How are you exporting your report to Excel?
Are you not able to use the suggestions listed in question How export report definition in Pega 7.3 ?
Also see support article: SA-55493: Report definition works incorrectly with custom control HTML
MacQuarie Bank Ltd
AU
Thanks for you reply.
But currently we are using Listview that is copied from older version.
Do i need to update those listviews to Report Definition.
And can you please share me any existing or example to refer.
Can you please share any more related document related to data table editor. How to use in Pega 7.3.
MacQuarie Bank Ltd
AU
Sharing the screenshots that is being used in the project to update the data currently.
Step1: Click on Report
Step2 : Click on Export to Excel
Step3: Modify the data
Step4: Click on Update
This will update the record in database directly.