Hi,
Is there a way to extract these ‘report generator’ reports to Excel? Any workaround like use of the results key may be? Please advise.
Thank You
Regards
Nimesh
Solved
How to extract Report Generator Reports to Excel?
Best answer by AkilaR
Hi
You can extract the data from Report Archive. Go to Report Archive, Select the report you run > RMB on it and the select Report Parameters. You will get a dialog box and in there Select the Export button which will provide you a option to save the data in excel format or extract directly to Excel.
Hope this will help.
Regards,
Akila
This topic has been closed for comments
Hi,
You can extract the report data in XML_Report_Data_tab to the excel from the data base directly. Or do you need to extract report to excel from client side? Is this report with huge data set?
thanks and regards,
thilini
+11Hi
You can extract the data from Report Archive. Go to Report Archive, Select the report you run > RMB on it and the select Report Parameters. You will get a dialog box and in there Select the Export button which will provide you a option to save the data in excel format or extract directly to Excel.
Hope this will help.
Regards,
Akila
1 person likes this
+2Can anyone spare how the export button shows in the dialog? I dont see any export button in the dialog.
+11Hi
Above solution is only capable for Report Generator type reports only. For other reports you will have to extract data using INFO_SERVICES_RPV view via Quick Report.
Hope this will help.
Regards,
Akila
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.