Server-side Printing

The following describes what you need to do to enable server-side printing (essentially creating a new __SRS operator that will be used for server-side reporting).

1. From the SYSPRO System Setup program, select the Reporting tab.
2. At the Reporting configuration field, select the Server-side reporting using SQL option.

3. At the Database connection and Database authentication fields, enter the required details.

   Use the Test SQL connection function to confirm that you can connect to SQL.

4. At the Reporting service field, indicate the reporting service address and port.

   Use the Test connectivity function to confirm that you can connect to the service.

5. At the Scheduler authentication fields, indicate the relevant credentials.

   These are the Windows Task Scheduler permissions that allow the operator to create and maintain schedules on the server.

6. Save your changes and restart the reporting host service.

   Log in with the new __SRS operator and load the company information.

You would typically follow this procedure if you need to delete and prioritize reports in the report queue.

1. From the Operator Maintenance program, highlight the operator against whom you want to configure SRS permissions and select Change from the Edit menu.
2. Select the Security tab.
3. From within the Activities group, select List at the Selection field and then Edit at the Configure Activities field.
4. Locate the Reporting Service module and enable the SRS Allowed to change report priority and SRS Allowed to purge report options.
5. Save your changes.

Because Microsoft Outlook is not used to email reports from the server, you need to enable SMTP to use the mail server to email reports.

1. Open the Setup Options program (SYSPRO Ribbon bar > Setup).
2. Locate the Company category.

3. Within the Company category, open the General form and locate the Email/SMTP settings heading.

   Enter the required details:

   Option	Description
   SMTP server IP address	This is the default IP address of the specific SMTP server that SYSPRO will use to send messages.
   Outgoing email address	This is the email address of the sender of the message.
   User name	This is the user name for the email account and the SMTP server port to be used.
   Password	This is the password for the email account and the SMTP server port to be used.

4. Save your changes.

You would typically follow this procedure to change the frequency at to which reports are processed on the server and appear in the report queue.

1. Open the SYSPROReportingServiceHostService.exe.config file in your preferred text editor and change the service refresh time.

   By default the file is located in the Program Files\SYSPRO folder and the default refresh time is 1 minute (0.00: 01:00).

2. Save your changes and restart the service.

1. Select the report to be printed from the client.

2. Define the report and output options you require.

   Ensure that the printer you have selected is on the server. This would typically be set up by an administrator.

3. Select Process and confirm that the report has been added to the report queue and moved to the server.

4. Open the SRS Report Queue program (SYSPRO Ribbon bar > Home).

   A list of all the reports are displayed in the report queue. The refresh time as defined in the SYSPROReportingServiceHostService.exe.config file indicates how often the list view is updated.

5. Select View report against the report you want to print.
6. Print the report.

• Ensure that you have enabled the operator activity: SRS Allowed to purge report. You can delete a report from the report queue list view if it has been printed.

1. From the SRS Report Queue program (SYSPRO Ribbon bar > Home) highlight the report you want to delete.
2. Select Delete from the toolbar.

• Ensure that you have enabled the operator activity: SRS Allowed to change report priority.

You can change the priority of any report in a status of In Queue. If a report is urgent and there are many reports in the queue, you can change the priority of the report to move it to the front of the report queue.

1. From the SRS Report Queue program (SYSPRO Ribbon bar > Home) click in the Priority column of the report you want to maintain.

2. Select the relevant priority.

   You can select Low, Medium or High. The server will then re-prioritize the list view based on the priority (e.g. high priority reports will appear and be processed first, followed by medium and low reports).

You would typically follow this procedure to resolve an error against a report and print it again from the report queue without re-processing it from the client.

1. From the SRS Report Queue program (SYSPRO Ribbon bar > Home) highlight the report you want to re-run, and the select Re-run report.

   The Re-run report option is only enabled if there is an error against the report.

You can export a report and save it on the server in the chosen exported format.

1. Select the report to be exported from the client.
2. Define the report options required
3. Select the Output options tab and enable the Export report option.
4. Select the format to which the report must be exported and select Process.
5. Open the SRS Report Queue program (SYSPRO Ribbon bar > Home).

6. Select View in the Exported report column against the relevant report.

   The report opens in the application to which you chose to export it.