Skip to main content

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

Hi,

At the moment Schedule Quick Reports only support Excel format

Regards.
Chanaka


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;