Tuesday, 27 January 2009

SQL Reporting Service Reports - SourceSafe Version

This is a good way of keeping track of SQL Reports. It displays the SourceSafe version of the report in the footer.



Simply put a text box in the footer and enter the following into it's Value property:

="Report: "+Globals!ReportName+", Version:"+Replace(Mid("$Revision: 2 $", 11)," $","")

1 comment:

  1. Don't forget to enable keyword expansion in vss for rdl files.

    It's in Vss Admin->Options->General->"Expand keywords in files of type:" - add *.rdl to the list).

    ReplyDelete