# SYSPRO Report Writer, Reporting Services and Crystal: Options and Fixes > Source: https://netray.co/erp-help/syspro-report-writer-srs-crystal-and-print-preview-errors > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: ERP Help ## Short answer SYSPRO offers several reporting routes: built-in operational reports, the Report Writer for custom listings, SYSPRO Reporting Services (SRS, built on SQL Server Reporting Services) for formatted documents, and Crystal Reports in some older and customised setups. When SRS printing or print preview fails, check the report server service, its configured URL and credentials, and the permissions of the SYSPRO service account first. ## Kind how-to ## System syspro ## Erp SYSPRO ## Module Reporting / SYSPRO Reporting Services ## Query syspro report writer ## Alternate Queries - syspro reporting services - syspro crystal reports - syspro srs print error - syspro print preview not working ## Applies To SYSPRO 7 and 8 with SQL Server Reporting Services. Details of SRS setup vary by release and by whether the report server is on the same machine. ## Steps ### How to troubleshoot an SRS print or print preview failure **Items:** - Try the same document on another workstation and another user. A failure everywhere points to the server; a single machine points to the client or printer. - On the report server, confirm the SQL Server Reporting Services service is running and the report server web page opens in a browser. - In the SYSPRO reporting setup, check the configured report server URL and the folder where SYSPRO's reports are deployed. A changed server name or certificate often breaks this. - Verify the credentials SYSPRO uses to reach the report server and that the account has browse and run rights on the report folder. - Re-deploy or refresh the SYSPRO report definitions after an upgrade or patch, because missing or old report files cause blank or failed output. - Check printer mapping and default printer for the user session, especially on terminal servers, and test with a PDF output to separate printer faults from report faults. ## Sections ### Which reporting tool to use **Body:** Use the standard SYSPRO reports first. Many questions are answered by an existing inquiry or report with its filters. The Report Writer is for tabular listings across SYSPRO data where you want selected fields without developing a full report. Use SRS when you need formatted business documents such as invoices, purchase orders or statements, and when you want to use SQL Server Reporting Services skills. Use Crystal only where you already have Crystal investments; for new work, most teams prefer SSRS or a BI tool reading the database directly. ### Why SRS print fails **Body:** SRS depends on a chain: SYSPRO client, application server, SQL Server Reporting Services, report definitions and the printer. A break at any link looks the same to the user: an error, a blank preview, or a hang. Work through the chain from the report server toward the printer. The most common causes are an unreachable report server URL after a server rename, expired or changed service account passwords, a browser or viewer component blocked on the client, and permissions on the report folder. After an upgrade, the second most common cause is report definitions not being refreshed. ### Reading the data directly **Body:** For analytical reporting, many teams skip report tools and query SYSPRO's SQL Server tables read-only, or point a BI tool at a reporting copy. This keeps heavy reports away from the transaction database and avoids the dependence on SRS. Do it with a read-only SQL login, never with the SYSPRO operator account, and keep table names in views so a schema change in an upgrade does not break every report. **Code:** -- Example read-only view over supplier master (confirm column names in your database) CREATE VIEW rpt.Suppliers AS SELECT Supplier, SupplierName FROM dbo.ApSupplier; ## Pitfalls - Fixing the printer when the report server is the real fault. - Using the interactive operator account as the report server credential, so a password change breaks printing. - Forgetting to redeploy reports after an upgrade. - Running heavy custom reports against the live transaction database during peak hours. - Testing only on the server session and not from a real user's terminal server session. ## Ai Angle Netray adds a private AI layer to the SYSPRO you already run, including on-prem installs where the SQL Server and application server never leave your network. ERPray answers questions over live SYSPRO data with read-only SQL or e.net queries it shows you, under the operator's own SYSPRO security, so a planner or accountant can ask the question in plain language and see exactly which tables or business objects produced the answer. Any write-back, such as posting a transaction, goes through a human approval step. The model is open-weight and runs on your own GPUs, so company data is not sent to a public AI service. ## Faq ### What is SYSPRO Reporting Services? **Answer:** SYSPRO Reporting Services (SRS) is SYSPRO's formatted reporting layer, built on Microsoft SQL Server Reporting Services. It produces documents such as invoices and statements from SYSPRO data, so its health depends on the report server being reachable and correctly configured. ### Is SYSPRO Crystal Reports still used? **Answer:** Some installations still use Crystal for older or customised documents. New work is more commonly done with SRS or direct SQL reporting. If you rely on Crystal, plan for the runtime installed on clients and for migration over time. ### Why does print preview show nothing? **Answer:** Usually the report server cannot be reached, the credentials lack rights on the report folder, or the report definitions are missing after an upgrade. Test a PDF output and browse to the report server URL to see where the chain breaks. ### Can I report on SYSPRO data without the Report Writer? **Answer:** Yes. A read-only SQL login against the SQL Server database, preferably on a reporting copy, lets BI tools or SQL queries read the data. Keep access read-only and respect your security policy. ## Search terms syspro report writer, syspro reporting services, syspro srs, syspro crystal reports, syspro srs print error, syspro print preview not working, syspro ssrs, syspro custom reports --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json