Thanks Matan, interesting link and I think I've solved it.

I was originally looking for a way to display historic data in an SSRS report, but I've now just added a...