DateTime format ignored when pzRDExportWrapper is used to export to excel
Hi,
We have a requirement to export the results of the search screen which is presented using a Table(repeating grid) sourced from a Report Definition to an excel file and one of the columns is datetime which is formatted(DateTime Control) in Report definition as dd-MMM-yyyy. On click of a button we are calling pzRDExportWrapper activity which is exporting the excel but datetime column in the excel is missing the format mentioned in the report definition. But the formatting is preserved when exported to excel via Report Browser.
Hi,
We have a requirement to export the results of the search screen which is presented using a Table(repeating grid) sourced from a Report Definition to an excel file and one of the columns is datetime which is formatted(DateTime Control) in Report definition as dd-MMM-yyyy. On click of a button we are calling pzRDExportWrapper activity which is exporting the excel but datetime column in the excel is missing the format mentioned in the report definition. But the formatting is preserved when exported to excel via Report Browser.
Do I need pass any parameters to the activity for datetime column in the exported excel to have the same formatting mentioned in Report Definition?
Virtusa
AU
I tried using pzRDExportWrapper as I have got issues with MSOGenerateExcelFile. In my case when I used MSOGenerateExcelFile the excel generated displays the datetime field as 20170921T180901.000 GMT, so wanted to try pzRDExportWrapper. I'm getting some error with pzRDExportWrapper, am I missing something here(attached screenshot)? I tried with the step page of type Rule-Obj-Report-Definition, Primary etc but it fails to execute.