Wednesday, August 19, 2009

Data View Web Part

I came across a web part for our dashboard development that makes access to SQL data a little easier. It’s from a company named Lightning Tools Ltd, and it’s the LT Data Viewer Web Part. Its claim to fame is not requiring SharePoint Designer to drop a table, view, or stored procedure on to a SharePoint site.

In the screenshot below, I’ve used the web part to display data from a stored procedure, showing recent batches run on our demo system. The web part has the ability to highlight values or whole rows based on expressions. In this case, I’ve highlighted batches whose duration has exceeded a predetermined limit. Makes it easy to quickly identify the outliers.

Of course, it would be really neat if I could just click on the Batch ID in the list and get access to a report or launch a tool like History Analysis…

No comments: