Make Reports Available to MinistryPlatform
The last step to deploy reports in MinistryPlatform.
Note: The instructions included here are for the MS Report Builder 3.0 (MSRB) authoring tool.
- In MinistryPlatform, go to System Setup > Reports. You can add an entry there and give the report the name you want to see inside the system. The report path is just the exact path to the report inside of SSRS with a slash (/) at the beginning.Note: You can use spaces.You upload an RDL called "My Report" into a folder called "My Custom Folder," the report path is "/My Custom Folder/My Report".
- Add which pages you want into the tab (sub-page) of that report and they display on that page. Note: Reports are role-based, so you must go to Administration > Role Reports and make sure the roles are set correctly. The roles are the same as the security roles.
- When laying out the object within the report body (tables, matrices, text boxes, lines, and so on), be careful not to make the objects wider than the width of the paper size and orientation of the report. If the report is too wide, the object runs over on to another piece of paper. One way to ensure this does not happen is to run the report and click the Print Layout button. This view indicates if the report fits on the page as expected.
- If you intend to save the file as a PDF file and then print it, you must set some of the report properties so the report prints properly:
- Open the report in MSRB. Right-click in the main authoring background area (anywhere other than on the body of the report), and select Report Properties.
- Set the paper size, units, orientation, and margins. Make note of the paper width and left margins.
- Close the Report Properties window.
- Right-click any blank area in the body of the report page and find body Position property category. Expand Position and Size and make note of the Width property value.As the report prints, the report automatically sets page breaks and prints the report on one or more pages. In other words, the report height and top and bottom margins take care of themselves during the printing process. However, Adobe Reader does not make automatic adjustments to keep the report from being too wide. If the report is too wide, the report breaks between columns or it inserts blank pages. To avoid this, you must add the values of the right and left margins (from the report properties) and add them to width value of the body of the report. This total must be less than or equal to the width value of the report paper size. For example, the image above shows the page is set to the Letter paper sized report with the Landscape orientation. So the total paper width is 11 inches. The right and left margins are each 0.5 inches. That leaves a total of ten inches to print the body of the report. The body width is ten inches, so this report prints without printing blank pages. If the body value were higher than ten inches in this case, then the report width would "run over" on to other pages and print blank pages in Adobe Reader.