Solved

How to extract Report Generator Reports to Excel?

  • 8 December 2021
  • 5 replies
  • 685 views
N
Rank

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

icon

Best answer by AkilaR 8 December 2021, 06:03

View original
This topic has been closed for comments

5 replies

T
Rank
Userlevel 5
Badge +7

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

 

AkilaR
Rank
Userlevel 6
Badge +11

Hi @nimesh ,

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

N
Rank

Hi @AkilaR Thank you very much. This is perfect!

R
Rank
Badge +2

Can anyone spare how the export button shows in the dialog? I dont see any export button in the dialog.

 

AkilaR
Rank
Userlevel 6
Badge +11

Hi @rifki.pamuntjak ,

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

Terms & ConditionsCookie settings