Answered by:
SQL Server Reporting Services Standards

Question
-
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.
Monday, November 2, 2015 2:20 PM
Answers
-
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. :)
- Proposed as answer by Qiuyun YuMicrosoft contingent staff Tuesday, November 3, 2015 2:33 AM
- Marked as answer by Qiuyun YuMicrosoft contingent staff Tuesday, November 10, 2015 11:55 AM
Monday, November 2, 2015 3:00 PM -
Hello,
Please read/view the following resources:
https://channel9.msdn.com/Events/TechEd/Europe/2009/DAT306
https://technet.microsoft.com/library/Cc966445
https://www.mssqltips.com/sqlservertip/1315/sql-server-reporting-services-development-best-practices/
https://msdn.microsoft.com/en-us/library/ms154047(v=sql.120).aspx
https://msdn.microsoft.com/en-us/library/ff714051.aspx?f=255&MSPPError=-2147217396
Hope this helps.
Regards,Alberto Morillo
SQLCoffee.com- Proposed as answer by Qiuyun YuMicrosoft contingent staff Tuesday, November 3, 2015 2:33 AM
- Marked as answer by Qiuyun YuMicrosoft contingent staff Tuesday, November 10, 2015 11:55 AM
Monday, November 2, 2015 4:04 PM
All replies
-
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. :)
- Proposed as answer by Qiuyun YuMicrosoft contingent staff Tuesday, November 3, 2015 2:33 AM
- Marked as answer by Qiuyun YuMicrosoft contingent staff Tuesday, November 10, 2015 11:55 AM
Monday, November 2, 2015 3:00 PM -
That's a GREAT start Daniel!
Thanks. I appreciate it. We are on the "cutting edge" of getting started with SSRS. Maybe "cutting edge" is the wrong words. But we are just getting started in implementing SSRS and we are looking for anything that can get us started.
Monday, November 2, 2015 3:28 PM -
Hello,
Please read/view the following resources:
https://channel9.msdn.com/Events/TechEd/Europe/2009/DAT306
https://technet.microsoft.com/library/Cc966445
https://www.mssqltips.com/sqlservertip/1315/sql-server-reporting-services-development-best-practices/
https://msdn.microsoft.com/en-us/library/ms154047(v=sql.120).aspx
https://msdn.microsoft.com/en-us/library/ff714051.aspx?f=255&MSPPError=-2147217396
Hope this helps.
Regards,Alberto Morillo
SQLCoffee.com- Proposed as answer by Qiuyun YuMicrosoft contingent staff Tuesday, November 3, 2015 2:33 AM
- Marked as answer by Qiuyun YuMicrosoft contingent staff Tuesday, November 10, 2015 11:55 AM
Monday, November 2, 2015 4:04 PM