Skip to main content
Solved

Quick Report stored as XML File

  • June 4, 2021
  • 2 replies
  • 375 views
A
Sidekick (Customer)
Forum|alt.badge.img+9

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

Best answer by ChanakaAmarasekara

Hi,

At the moment Schedule Quick Reports only support Excel format

Regards.
Chanaka

X
This topic has been closed for replies.

2 replies

ChanakaAmarasekara
Hero (Employee)
Forum|alt.badge.img+15

Hi,

At the moment Schedule Quick Reports only support Excel format

Regards.
Chanaka

- Chanaka Am -
X
D
durette
Superhero (Customer)
Forum|alt.badge.img+19
  • durette
  • Superhero (Customer)
  • July 30, 2021

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;

 

If you find this forum useful, please consider paying back to the community in your own areas of expertise. If you ask for help in a private message, please know that I will likely repost it as a forum question (with your personal details redacted) and answer it publicly. -- Kevin Durette - https://www.linkedin.com/in/kevindurette
Terms & ConditionsCookie settingsAccessibility statement