I've just done the Microsoft SSRS training course, and now that I'm back an work I'm trying to put a few things into practice.
I've downloaded the Adventureworks2008R2 and AdventureWorkDW2008R2 databases and have been trying to work through your example. (It looks great BTW.)
However, I haven't got very far... Your SQL in Figure 3, refers to a table that doesn't exist in the AdventureworksDW2008R2 database: dbo.DimTime. Exercises in SSRS training course Mod 4 refer to it, but none of the supplied scripts create it.
Is this just a version difference? between 2008 and 2008R2 sample db's. Is there a script I need to run?
Any help or suggestions would be greatly appreciated.