Just wondering if anyone out there would be willing to share the standards they've established with their SQL Server Reporting Services environment.
Like Report Naming Conventions?
SSRS SQL Server Stored Procedure naming conventions for SSRS Reports?
SSRS Data Source naming conventions?
Things like that.
Thanks for your review and am hopeful for a reply.
Hi Bobby,
I have seen SSRS at more than 50 different customers and I can tell you that no one really sets a standard for SSRS. The same rules for procs apply, meaning don't use sp_ and keep your procs in the database where they belong and not in a system
db.
If you're looking for a standard how about the following:
- Place reports in logical business folders (accounting, hr, sales, ...) This will allow you to manage security easily.
- Give the reports a friendly name so they appear that way in Report Manager.
- Prefix report procs with "rpt" or "report" or "ssrs".
- Prefix data sets with "ds".
- Prefix data sources with "cn" or "conn"
- Avoid using sub-reports heavily as this can increase workload. Instead use nested data regions.
I hope that helps!!
I hope you found this helpful! If you did, please vote it as helpful on the left. If it answered your question, please mark it as the answer below. :)
