Skip to main content
Solved

Scheduling Quick Report for Save using Application Server Task


samglk
Sidekick
Forum|alt.badge.img+3
  1. I created a AST as below for a quick report in IFSAPPS 9
  2. After executing the schedule, following message has been created.
    1. How can I use the report result to save in to a file? Message Response is transferred to  BizAPI: ExcelQuickReport: RenderExcelQuickReport. How can I use this?

 

Best answer by ChanakaAmarasekara

Hi,

A scheduled quick report will output an Excel. This Excel can either be emailed or checked in to document management (docman).

Regards,

View original
Did this topic help you find an answer to your question?

9 replies

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

Hi,

A scheduled quick report will output an Excel. This Excel can either be emailed or checked in to document management (docman).

Regards,


samglk
Sidekick
Forum|alt.badge.img+3
  • Author
  • Sidekick
  • 7 replies
  • April 24, 2020

@ChanakaAmarasekara  Thank you for the reply. That means, my second solution should be developed. I will get the file out from PL/SQL side. 


samglk
Sidekick
Forum|alt.badge.img+3
  • Author
  • Sidekick
  • 7 replies
  • April 24, 2020

Hi @ChanakaAmarasekara, But I wonder what happens to the Message Response that is transferred to  BizAPI: ExcelQuickReport: RenderExcelQuickReport ?  can we use it?


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

Hi @ChanakaAmarasekara, But I wonder what happens to the Message Response that is transferred to  BizAPI: ExcelQuickReport: RenderExcelQuickReport ?  can we use it?

Hi

I’m not sure you can, but you can try it and see.

Or you can try writing code to call the RenderExcelDocument manually and save to disk but you might not be able to schedule it.

 

Regards,


Forum|alt.badge.img+11
  • Hero (Customer)
  • 142 replies
  • August 28, 2020
ChanakaAmarasekara wrote:

Hi,

A scheduled quick report will output an Excel. This Excel can either be emailed or checked in to document management (docman).

Regards,

@ChanakaAmarasekara  Do you have any quick guide on how to do this process or do you know if it is in the standard online help documents? 


Forum|alt.badge.img+11
  • Hero (Customer)
  • 142 replies
  • August 28, 2020

@ChanakaAmarasekara I found the detail in other posts and on the IFS Documentation. Thanks.

 


Forum|alt.badge.img+5
  • Do Gooder (Customer)
  • 13 replies
  • October 31, 2022

@samglk - this maybe too old post :) But I would like to know whether you implemented the solution you have mentioned here. That is, to save the Quick Report result into an excel file (schedule this job also)

I also need a similar solution and just wants to check whether you have done anything :)

 

Regards,

Rajika.


LevFredrB
Sidekick (Partner)
Forum|alt.badge.img+4
  • Sidekick (Partner)
  • 9 replies
  • December 27, 2022
ChanakaAmarasekara wrote:

Hi,

A scheduled quick report will output an Excel. This Excel can either be emailed or checked in to document management (docman).

Regards,

OMRRAJIKA wrote:

@samglk - this maybe too old post 🙂 But I would like to know whether you implemented the solution you have mentioned here. That is, to save the Quick Report result into an excel file (schedule this job also)

I also need a similar solution and just wants to check whether you have done anything :)

 

Regards,

Rajika.

Hi!

Yes, would be really interesting to know if it is possible to render an Excel doc (by calling the the available RenderExcelDocument service) from the PL-SQL code and put the reslut on disc or into a blob. 

Has anyone done this and want to share the code?

/Fredrik


Forum|alt.badge.img
  • Do Gooder (Customer)
  • 2 replies
  • May 4, 2023

giving .xlsx extension in file name will give you a excel output 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings