Data View Web Part, Part II

So we’ve done some more playing around with the data view web part. I think I’m warming up to it because it does have a lot of capabilities and Drew’s doing the heavy lifting.

So we’ve put together a really good Batch Duration example. It’s a combination of 3 data view web parts, feeding each other in series. The first data view allows the selection of a formula, which populates the second data view with a list of batches that meet the formula criteria. By clicking on a particular batch id then populates the third data view showing durations. We even took advantage of the web part to highlight durations that exceed a fixed amount of time. Great for doing batch to batch comparisons.

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…