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
-
