Infor SyteLine4 min readNetray Engineering TeamUpdated March 4, 2025

How to Create Scheduled Reports in SyteLine

Scheduled reports in SyteLine automate the generation and distribution of critical manufacturing reports on predefined intervals. Instead of manually running reports each morning, plant managers receive production summaries in their inbox before they arrive at the facility. This guide covers configuring SyteLine's report scheduling engine, defining recurrence patterns, and managing the output distribution to ensure stakeholders receive timely, accurate information.

Configuring the Report Scheduling Engine

SyteLine report scheduling operates through the Task Scheduler framework integrated with the report server. Access the Scheduled Reports form from Administration > Report Scheduling to create new scheduled report definitions. Select the target report from the registered report catalog and configure the execution parameters that will be passed to the report at runtime. Set the SyteLine service account credentials that the scheduler uses to authenticate against the report server and database. Enable the Background Task Service on the SyteLine application server if not already running, as this Windows service manages the scheduling queue and triggers report execution at specified intervals.

Access Scheduled Reports form from Administration > Report Scheduling menu
Select the target report and configure runtime parameters for each scheduled execution
Configure service account credentials with permissions to execute reports and access data
Verify Background Task Service is running on the application server for schedule processing

Defining Schedule Recurrence and Parameters

Configure recurrence patterns matching your reporting cadence using the schedule definition form. Daily schedules support specific execution times with options for business-days-only or every-day patterns. Weekly schedules allow selection of specific days and execution times for recurring reports like Monday morning production reviews. Monthly schedules support specific dates or business-day offsets for financial period-end reporting. For each schedule, define the parameter values that will be used at execution time, including date range calculations using relative expressions like 'Previous Business Day' or 'Current Month to Date' that automatically adjust with each execution.

Configure daily schedules with specific execution times, typically 5:00-6:00 AM before shift start
Set weekly schedules for Monday production reviews and Friday inventory summaries
Define monthly schedules with business-day offsets for period-end financial packages
Use relative date expressions like 'Previous Business Day' for automatic parameter calculation

Managing Output Formats and Distribution

Configure the output format for each scheduled report selecting from PDF, Excel, CSV, or HTML based on the intended audience and use case. PDF format works best for distribution to executives and external stakeholders who need formatted, read-only documents. Excel format enables recipients to perform additional analysis, filtering, and pivoting on the delivered data. Set up distribution lists specifying email recipients for each schedule, with options for direct email attachment or shared folder file drops. Configure output file naming conventions using date stamps and parameter values to organize archived reports chronologically, such as 'ProductionSummary_2024-01-15_PlantA.pdf'.

Select PDF for executive distribution, Excel for analytical users, CSV for system integration
Configure email distribution lists with separate recipient groups per report schedule
Set up shared folder file drops for archival and compliance documentation requirements
Define naming conventions with date stamps and parameters for organized report archives

Frequently Asked Questions

How many scheduled reports can SyteLine handle simultaneously?

The SyteLine Background Task Service can process 3-5 concurrent scheduled reports by default, configurable up to 10 concurrent executions depending on server resources. For organizations running 30-50 scheduled reports, stagger execution times in 5-minute intervals to avoid bottlenecks. A dedicated report server with 16GB RAM and 4 CPU cores typically handles 100+ daily scheduled reports when properly staggered across the day.

What happens when a scheduled report fails to execute?

SyteLine logs failed scheduled report executions in the Background Task Log accessible from Administration. Common failures include database timeout errors for reports exceeding the 300-second default timeout, authentication failures when service account passwords expire, and parameter validation errors when date range calculations produce invalid values. Configure retry logic to attempt re-execution 2-3 times with 10-minute delays before marking the schedule as failed and notifying administrators.

Can I schedule reports to run with different parameters on different days?

Yes, create multiple schedule entries for the same report with different parameter configurations. For example, schedule a production summary report to run daily with single-day parameters and weekly with 7-day range parameters. Each schedule entry operates independently with its own recurrence pattern, parameters, output format, and distribution list. Most implementations use 2-4 schedule variations per core report to serve different stakeholder needs.

Key Takeaways

1Configuring the Report Scheduling Engine: SyteLine report scheduling operates through the Task Scheduler framework integrated with the report server. Access the Scheduled Reports form from Administration > Report Scheduling to create new scheduled report definitions.
2Defining Schedule Recurrence and Parameters: Configure recurrence patterns matching your reporting cadence using the schedule definition form. Daily schedules support specific execution times with options for business-days-only or every-day patterns.
3Managing Output Formats and Distribution: Configure the output format for each scheduled report selecting from PDF, Excel, CSV, or HTML based on the intended audience and use case. PDF format works best for distribution to executives and external stakeholders who need formatted, read-only documents.

Want to automate your SyteLine reporting workflow? Netray can set up comprehensive scheduled reporting systems tailored to your operations.

Talk to an Expert See a Demo

Related Resources

Infor SyteLine