Infor SyteLine3 min readNetray Engineering TeamUpdated March 4, 2025

How to Set Up SSRS Reports in SyteLine

SQL Server Reporting Services (SSRS) provides a modern web-based reporting platform that integrates natively with SyteLine's SQL Server backend. SSRS reports offer interactive features like drill-through navigation, parameter cascading, and direct Excel export that enhance manufacturing analytics. This guide covers the end-to-end setup process from SSRS server installation through SyteLine integration and report deployment.

Installing and Configuring the SSRS Server

Install SQL Server Reporting Services on your report server using the SQL Server installer, selecting the Reporting Services feature. Configure the SSRS instance through Reporting Services Configuration Manager by setting the service account, web service URL, and report manager URL. Create a dedicated SyteLine database connection using shared data sources pointing to your SyteLine SQL Server instance. Configure Windows Authentication pass-through or create a dedicated reporting service account with read permissions on the SyteLine database. Set the SSRS execution timeout to 300 seconds to accommodate complex manufacturing reports.

Install SSRS through SQL Server Setup selecting Reporting Services - Native mode installation
Configure web service URL typically at http://reportserver:80/ReportServer for SyteLine access
Create shared data sources with connection strings pointing to each SyteLine database instance
Set execution timeout to 300 seconds and memory limits to 2GB for large manufacturing datasets

Building SSRS Reports for SyteLine Data

Use SQL Server Data Tools (SSDT) or Report Builder to create SSRS reports connecting to SyteLine data. Design datasets using T-SQL queries against SyteLine tables and views such as item_mst, coitem_mst, jobmatl_mst, and the SyteLine-provided reporting views. Implement cascading parameters where selecting a Site filters available Warehouses, and selecting a Warehouse filters available Items. Add tablix regions for tabular data, charts for trend analysis, and gauges for KPI visualization. Use expressions for conditional formatting to highlight production exceptions like jobs past due or inventory below safety stock.

Create datasets using T-SQL queries against SyteLine views like vw_OpenCustomerOrders and vw_InventoryBalance
Implement cascading parameters linking Site to Warehouse to Item for intuitive user filtering
Add tablix, chart, and gauge report items for comprehensive data visualization
Use SSRS expressions for conditional formatting to flag exceptions and out-of-tolerance values

Integrating SSRS Reports with SyteLine Application

Register SSRS reports in SyteLine through the Report Administration form by specifying the SSRS report server URL and report path. Configure parameter mapping to pass SyteLine form context values like current site, warehouse, or selected item number directly to SSRS report parameters. Set up SSRS subscriptions for automated report delivery via email or file share, scheduling daily production summaries, weekly inventory reports, and monthly financial packages. Enable the SSRS web portal for ad-hoc report access outside the SyteLine application, providing managers with browser-based access to reports without requiring a SyteLine client license.

Register SSRS reports in RSAdmin with the full report server URL path for each report
Map SyteLine form context variables to SSRS report parameters for seamless drill-through
Configure SSRS subscriptions for automated daily, weekly, and monthly report distribution
Enable web portal access for browser-based report viewing without SyteLine client licenses

Frequently Asked Questions

Which SQL Server version is required for SSRS with SyteLine?

SyteLine requires SQL Server 2016 or later for full SSRS integration, with SQL Server 2019 recommended for optimal performance. SSRS 2019 supports modern browsers, mobile report publishing, and Power BI integration. The SSRS instance can run on the same server as the SyteLine database for small deployments under 50 users, or on a dedicated server for larger implementations.

Can SSRS reports replace Crystal Reports in SyteLine?

Yes, SSRS can fully replace Crystal Reports in SyteLine implementations. Migration typically involves recreating 80-150 Crystal Reports as SSRS RDL files, which takes 2-4 hours per report depending on complexity. SSRS offers advantages including no separate licensing cost with SQL Server, better web delivery, and native subscription capabilities. Most migrations complete within 4-8 weeks for a standard SyteLine deployment.

How do I optimize SSRS report performance with SyteLine?

Optimize SSRS performance by creating indexed SQL views for frequently used report datasets. Enable report caching with 15-30 minute expiration for summary reports. Use stored procedures instead of inline queries for complex reports exceeding 5 table joins. Configure SSRS memory limits to 65% of available server RAM and implement report execution logging to identify slow reports averaging over 30 seconds execution time.

Key Takeaways

1Installing and Configuring the SSRS Server: Install SQL Server Reporting Services on your report server using the SQL Server installer, selecting the Reporting Services feature. Configure the SSRS instance through Reporting Services Configuration Manager by setting the service account, web service URL, and report manager URL.
2Building SSRS Reports for SyteLine Data: Use SQL Server Data Tools (SSDT) or Report Builder to create SSRS reports connecting to SyteLine data. Design datasets using T-SQL queries against SyteLine tables and views such as item_mst, coitem_mst, jobmatl_mst, and the SyteLine-provided reporting views.
3Integrating SSRS Reports with SyteLine Application: Register SSRS reports in SyteLine through the Report Administration form by specifying the SSRS report server URL and report path. Configure parameter mapping to pass SyteLine form context values like current site, warehouse, or selected item number directly to SSRS report parameters.

Ready to modernize your SyteLine reporting with SSRS? Contact Netray for SSRS implementation and migration services.

Talk to an Expert See a Demo

Related Resources

Infor SyteLine