Hyperlinks in custom reports

One feature introduced in SQL Server 2005 is reporting in management studio. You have a set of standard reports that allow you to see in a nice report format output from dmvs and the default system background trace. Whats neat is that you can write your own custom reports. For those that long after the taskpad view of a database from SQL 2000 Enterprise manager with the help from Jasper Smith I created this http://sqlblogcasts.com/blogs/simons/archive/2007/03/28/Update-to-the-taskpad-custom-report.aspx


The custom report feature is almost fantastic, there are 3 main features I think make them awkward to use.


1. You can select text from the report and copy it
2. You can't add additional parameters to allow additional filtering, i.e. filter audit changes for today.
3. You can't have hyperlinks.


The last one I raised a connect item for https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=240407.


If we had this you could write reports that had links to KB articles, blog posts, or internal KB systems. Similar to what most monitoring systems provide.


If you think this is a good idea then please vote on the connect item. I've been asked by the tools team to see if it is something people want.


Some other connect items that you might be interested in supporting if you think they are worthwhile.


Use expressions for data sources – https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=238233


Be able to combine data from different data sources – https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=240268


Be able to run reports against SQL 2000 database – https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=240476


 







Leave a Reply

Your email address will not be published. Required fields are marked *


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>