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.

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

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.

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

expressions for data sources –

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

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 *