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.
Employee view only: When a Customer Reports an Error Running All Reports
Here are some things to review and try.
-
Ensure that the Web Server has permissions to the ReportServer Database.
- When a customer reports an error running a report, that error may or may not be descriptive. Initial troubleshooting should determine that the error is specific to one report. ACS Technologies only troubleshoots reports created by our personnel.
- Customer should send a screenshot which illustrates the parameters they passed to the report (if that was possible), as well as the error message they saw on their screen. ACS Technologies or a member of the customer's support team may follow the steps below to troubleshoot a specific report issue.
- Run the report from the MP Demo instance to ensure the issue is isolated to a single customer.
- Run the report from the customer's system using your browser and the same parameters as the customer. Copy the URL to your clipboard. The URL contains the following:
- The exact name of the RDL file (this can be different from the report name in MinistryPlatform).
- The parameters passed to the RDL file.
-
Work through the following questions while logged onto the report server from its internal web address on the SSRS server.
- Does the RDL file exist on customer's server?
- Is the RDL file connected to DataSources/Datasource01?
- Can you run the RDL file from the report server with the parameters you copied when running it from MinistryPlatform? You may have to go to "manage" the report then find and add parameters.
- What error do you get? If it is an error with a data set, then the problem may be with a stored procedure or underlying database objects. The error visible on screen when on the reporting server's internal address is likely to be more descriptive than the original error.
-
Working through data set issues from customer's SQL Server:
- What SP does the data set call upon? If unsure or unclear, download the RDL file from the report server and do a search for that data set name in the RDL file opened in notepad.
- Go to the MinistryPlatform database and confirm the SP exists and look at properties of the SP to be sure MPReports has rights to execute it.
- Attempt to manually run the SP. You will need the parameters copied from the URL and you may need to pass some additional parameters. You'd likely get the real error at this point.
Correcting the issue with the SP will generally resolve the issue. Once this is done, go back to the report server and attempt to run the report from SSRS (not MinistryPlatform) and see if the error resolves. If it does, go back to the report run from MinistryPlatform and make sure it can be run from there as well.
At any point during this process when you have a real, actionable error message you may submit this error to the report authoring personnel at ACS Technologies to assist with a final resolution.