Reports Troubleshooting
Having some problems with reports? Here are a few things you can try.
- The RDL file (the report) stored on the SSRS server.
- The metadata record in the Setup Area of MinistryPlatform. This indicates the RDL file name, location, and pages the report deploys to, as well as Security Roles authorized to run the report.
- One or more stored procedures in the MinistryPlatform database per data set needed in the report.
Getting a certificate error or "untrusted" message when launching reports? When you renewed your SSL Cert on the MinistryPlatform Web Server, you have to bind it to the SSRS using the SSRS Configuration Manager. Make sure, on the Web Service URL page, the SSL certificate in the Report Server Web Service Site Identification section is bound to the MinistryPlatform Web Server.
You may have issues running a report in a Chrome browser. Chrome doesn't handle some reports due to the need for .NET coding on the server and workstation. Try using the latest version of another browser to run those reports.
- Setup and configuration issues.
- Authentication issues.
- Performance issues.
- Stored procedure issues related to changes in underlying data objects.
- HTML in a field that doesn't expect HTML.
If you're having trouble printing a label report from a PDF, try clearing the Fit to Page print option and select Actual Size instead.
If images are blurry in your report PDF, try saving the images as BMP files and reattaching them to the records. Generally, images are clearest when the image type is a BMP. Also, reports do not support TIFF images.
- Clear your selections.
- Reboot your machine daily.
- Clear your cache before running any reports.