Question

Regarding possibility to schedule reports generated with Report Generator

  • 22 October 2021
  • 1 reply
  • 59 views

Userlevel 7
Badge +17

Hi All,

 

Is it is possible to schedule the report generated with report generator (Refer to the below screen capture)?

 

All the parameters would be same, the only what changes is period.

Report should be run the 4th-5th day of the month for the previous month results (on the 4th of October we run the report for data for September). 

Could you please advise if there is any option to make this as a schedule in IFS?

 


This topic has been closed for comments

1 reply

Userlevel 6
Badge +14

Hi @MadushaDissanayake ,

 

There’s no straightforward way to archive this, but there are several options.

Operational Reporting\Create New Report Schedule will only create the schedule for the report to run but it will not have the possibility to give the required parameters.

 

One way of archiving the parameter requirement is to implement the report logic to get the current date and filter the data set in to SYSDATE- 30

Other option is to go with the ‘Context Substitution Variables’

For an example check the bellow report and the parameter “From Date”. Here we have the already defined context substitution variables.

 

 

If the already defined context substitution variables do not satisfy your requirement, you need to define your own variable.

You can not do this from the application, it needs to be done using an ins file.

After you have the correct variable define in the context substitution variable form for data type Date, you can use this for your report to define the parameters.

Hope this helps.