Solved

Quick Report stored as XML File

  • 4 June 2021
  • 2 replies
  • 285 views

Userlevel 4
Badge +9
  • Sidekick (Customer)
  • 76 replies

Hi all,

 

(Using IFS10, UPD7)
 

I would like to get a Quick Report generated daily and stored as an XML File on a Server.

I can create an Application Server Task to have it daily generated and send as an XLS file, but looking for it to be stored as XML file.

 

Anyone who can guide me in the right direction?

 

Arend

icon

Best answer by ChanakaAmarasekara 6 June 2021, 11:09

View original

This topic has been closed for comments

2 replies

Userlevel 7
Badge +15

Hi,

At the moment Schedule Quick Reports only support Excel format

Regards.
Chanaka

Userlevel 7
Badge +18

You could try doing the XML conversion inside your SQL, then export that as plain text.

SELECT dbms_xmlgen.getxml('SELECT * FROM customer_order WHERE rownum <= 5') AS xml
FROM DUAL;