Question

SQL quick report output to file

  • 28 October 2020
  • 2 replies
  • 407 views

Userlevel 3
Badge +6

Is there a way to spool output to a file from an SQL Quick report?  APPS10 UPD5


2 replies

Userlevel 7
Badge +28

You can schedule the report to be emailed or saved to a location.

Search the forum for Schedule Quick Report for a few examples, this post contains one example on one of the replies.

https://community.ifs.com/technology-infrastructure-cloud-integration-dev-tools-50/can-you-create-an-output-channel-in-ifs-that-will-open-file-explorer-and-allow-you-to-save-a-file-without-having-to-open-it-in-an-application-like-excel-first-747

Userlevel 3
Badge +6

Hi Shawn,  Thank you, yes that works with an order report. I have to schedule this job using application server task and then schedule the database server task.  Database Server task does not have the option.  It looks like Application Server Task may have it though.  This did help me look in other places.

Elaine

Reply