SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Report Naming Standards!!!?


Report Naming Standards!!!?

Author
Message
greg.perry
greg.perry
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 44
I have inherited a mess in the SQL Server Report Monitor and the current company that I have recently started.

There are hundreds of reports spread out accross many directories with names like (ad hoc) or (Live), and a number of other non-descript names for the folders within Reporting Manager, also the way the actual rdl's are named is equally confusing making it almost impossible to find a report or figure out what the report is supposed to contain by looking at the name.

Can someone point me to or suggest some directory and file naming standards that I can put into place so that a user could look at a file or directory and tell what it's for and or what it contains?

I'm hoping someone works in an environment that has some pretty good standards in place that I can imulate...

Any help would be appreciated,

Thanks in advance,
SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)

Group: General Forum Members
Points: 67835 Visits: 18570
The best thing you can do there is to do what you think makes logical sense --- after discussing it with interested parties. It needs to make sense to you and anybody else using the reports. Then you document your new standards and then you enforce what you decided to make as the standards.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

greg.perry
greg.perry
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 44
Ok, Thanks for the advice, I didn't know if there was some kind of SQL standards out or some kind of best practices that could be used.

I'll definitely take your advice,

Thanks
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search