Zero Reports Available

PTS 5 makes use of SSRS (SQL Server Reporting Services) to generate its reports. SSRS has many moving parts, and can fall out of working order for several different reasons. The most common faults and their solutions are discussed on this page.

Symptoms

On the reports screen, you will be able to search and filter your prescription sample but you will not be able to select a report type, and the tab will read "Reports (0)".

Later version of PTS 5 will also direct you to this very page.

Causes

1. The service account that was setup for this purpose has either been disabled, or the password has expired or been changed
2. On the SSRS server, the "SQL Server Reporting Services" Windows service has been stopped, disabled, or set to manual start type
3. If the server is using SSL, the certificate details may be invalid
4. The SSRS was in evaluation mode which has expired, and a software license is now required

Solutions

1. This happens all the time and should be your first assumption if the issue has occurred for no apparent reason.
   Go to PTS's Applications Settings page (Setup > Application Settings) and make a note of the user details stored in the following settings:
   • SSRS Reports Service User
   • SSRS Reports Service Password

   These details represent a domain user account. It may be the case that the account has been disabled, the password has expired or been changed, or the account is otherwise not in good order. IT should be able to reactivate the account for you, and ideally make changes so that the password doesn't expire.
   In the event that a new password is associated with the user account, make sure to apply it back to the SSRS Reports Service Password setting.
   

   Sometimes, a reactivated account will need to be manually logged in to a PC at least once to bring it back into good order.
2. Log in to the SSRS server and make sure the "SQL Server Reporting Services" Windows service is started and is set to start automatically. You can identify the name of your SSRS server via the "URL of SQL Reports Server" setting in Application Settings in PTS.
3. In SQL Reporting Services Configuration Manager, go to the Web Service URL tab and verify that a current, working SSL certificate is selected in the certificate dropdown. Next, click the Advanced button and make sure the correct certificate is bound to an IP address range and HTTPS port (likely to be all IPv4 addresses and port 443).
4. This issue will be reported in SQL Reporting Services Configuration Manager, but it is rather discrete: check the "Edition" on the main page for the word "Evaluation". The SSRS error logs in its installation path may also reveal this issue, and 503 errors when accessing the web portal are also a symptom. It goes without saying at this point, but you need to purchase a license for SSRS. It's widely understood that you need to fully re-install SSRS at this point to plug in a license key, but we have seen occasions where you can simply enter the key by "Modifying" the app installation in Control Panel.