Scheduled report (Fields)

The following field for a scheduled report can be edited.

Report

The report to run. This field is mandatory.

To

Enter the email addresses of the people who will receive the scheduled report when executed on the live environment. In the event multiple recipients are added they must be separated by ; (semi-colon) 
Note: Max number of characters that may be entered here is 4000 (includes spaces)

Bcc

Enter the email addresses of the people who are to be Bcc'd on the scheduled report when executed on the live environment. In the event multiple recipients are added they must be separated by ; (semi-colon) 
Note: Max number of characters that may be entered here is 4000 (includes spaces)

Cc

Enter the email addresses of the people who are to be Cc'd on the scheduled report when executed on the live environment. In the event multiple recipients are added they must be separated by ; (semi-colon) 
Note: Max number of characters that may be entered here is 4000 (includes spaces)

Test system to

On the user test environment, only the recipients specified here will receive the report. On the live system, this setting is ignored. The main reason for this setting is that if you copy the live database to the user test environment, if tends to be confusing for the recipients of the report if they also receive copies of the report from the test environment, as well as from the live environment. So, we prevent that the test environment sends reports, unless explicitly configured for using this field.

CronTab schedule

Schedule in CronTab scheduling expressions-format in UTC. For example: 0 8 1-7 * 1 for every first Monday of the month at 08:00. See Crontab.guru for more information. 

Remarks

Enter remarks to the scheduled report you would like to show in the scheduled reports grid.

Is enabled

Check the box if you want the scheduled report to be enabled. Uncheck the box to de-activate the scheduled report.

Start ASAP

Check this box and click Save to let FBO One generate and send the report straight away, disregarding the schedule. Generation of the report will start in 3 minutes on average. This is useful for testing the scheduled report or to restart a report that for some reason failed. 

  • You can check if the report is running by refreshing the page in the browser using the F5 button every few seconds. 
Include Excel file

Check this box if you want to include the generated Excel file of the report to the email.

Include Pdf File

If true, the generated Pdf file will be attached in the email when the report is an RDL. Default is True. 

Include Rdl Output File

If true, the 'RDL Report Output Format' defined for the report will be attached in the email.

Subject template text

Here you can set the text for the subject of the email. If blank, the name of the report is used.

Body template text

Here you can set the text the email should contain. To include a link to the Excel file in the body of the email you can add the following text: 

Send to server

Flag that allows the upload of the generated report file(s) to a specific server defined in the fields below

Server

Has the connection details to the receiving server. These details are used by FBO One Live system.

  • Values are to be specified separated by ; (semi-colon): Example: type=sftp; host=mysftp.domain.com;
  • Required fields:
    • type: for example SFTP. This is the only supported option for now.
    • host: the Url or IP address of the server
    • port: the port number on which the communication between FboOne and the server should take place
    • username: the username to use when connection to the server
    • folder: the folder in which to place the generated report (if not specified, the root folder of the server will be used)
    • canOverrideFilesAtDestination: default value is true.When the report already exists on the server, it will be overridden by the new run of the scheduled report.
Server password

The password required to connect to the server when on Live environment

Test server

Connection details used when FBO One is a TEST system.

Test server password

The password required to connect to the server when on UserTest environment


See also

Scheduling reports

How to configure a scheduled report