If you have issues with long file names in your SharePoint environment, then you probably have deeper issues with your Information Architecture.

There have been one or two instances in my implementation of SharePoint for my current employer where I have seen it as a failure.

The idea I came up with, was to store data in a custom List in SharePoint, and create a VBA macro that captures Calendar additions automatically, and uploads them straight to the SharePoint List.

This was something that seemed impossible for Sharepoint to do, but with a little trickery with XPath under the bonnet of Sharepoint Designer, proved incredibly simple.

Since then I’ve been picking up what is actually possible using the Data List View Webpart in Sharepoint Designer, largely with help from Marc D Anderson and Laura Rogers and their respective blogs.

After reading a fantastic post by Laura Rogers on displaying a roll-up web part using Sharepoint Designer and the all-powerful DataViewWebPart, I came across a need to produce a similar (but summarised) view of a Roll-up on another site.