Best practice of using SQL Reporting Services
Introduction
Working with reports for several years has given us the possibility to provide and share our best practice guidance in this area.
Element | Description |
Define an administrator of the site | Point out a person to be responsible for the management of this site, to ensure the structure created will be maintained and continually useful. |
The life cycle for reports | Some reports may live for a week others for a year. Due to the fact that several different people might use the report differently, it is important to ensure a process for managing, deploying, using, deleting, and retiring report is created and used. |
Tree view structure | It is important to create a structure on the Report Manager website which is easy to use and will add value to the business. Ask the users of the report on how they will use the reports. |
Define useful user groups and folders | Based on the needs of a business logical folder must be created. Ensure names are logical and recognizable. |
Setup security | Different business areas are allowed to use different information. After the creation of the structure, and before going live, ensure the security is set up correctly. |
Awareness | Make sure the business is informed about the Report Manager website and the area you have created for them. Follow up on the feedback and continue to improve the reports to meet the needs of the users. Having reports and data available is essential for effective management, but if you do not know the information is available, you cannot use it. |