Skip to main content

I would like to schedule a quick report to run daily.  Can this be done in Apps8?

Most of the examples I am finding are for 9 or 10.

 

Hi Community,

I am also looking for the same


I checked an environment of a customer of mine who is using App 8 SP2.

For this version I can say it is not possible in IFS standard.
You only can use scheduled tasks and scheduled reports (where the reports need to be coded reports *_REP).

 

From App9 on you could use scheduled sql statements
Foundation1 / Administration Guide / Reporting / Adhoc Reporting / Scheduled Quickrhttps://wit.ifsworld.com/f1docs/apps9/Foundation1/040_administration/250_reporting/020_adhoc_reporting/030_scheduled_quickreports/default.htm

 

In earlier versions I assume you could create a database method to execute the quick report SQL and send a mail from database directly. The database method you could set permissions on and run it as a scheduled task. 

But that would be like a small hard-coded interface functionality.

 

Kind Regards,

Andi


https://docs.ifs.com/techdocs/Foundation1/040_administration/255_br_and_a/005_adhoc_reporting/030_scheduled_quickreports/default.htm


Thank you Durette, I think that this link is only for apps9 or apps10.  In Apps 8 i do not see the same selections as in the screen shots. :-(  

 


This is possible.

 

You need to use a dynamic database task to execute the report and dispatch the results to the relevant user.

 

We've done this for both Crystal and SQL Quick Reports.

 

Give me a shout if this is something you are interested in looking at.


Reply