• nathaniel.drehmel (7/31/2012)


    I could, but would direct you to Bill's blog first:

    http://blogs.msdn.com/b/billramo/

    There's a six part series there on migrating MDW reports to SSRS. Bill's approach leverages a new query data collector to take advantage of the 'fingerprint' feature. As my organization already had a large deployment going, I had a need to build on Bill's work (or take away from you might say) by re-writing his reports to work with the out of the box query collector. If you have the ablity to deploy his query colelctor I would encourage you to go that route as the 'fingerprint' feature certainly adds value in aggregating similar, non-parameterized, queries by KPI.

    Thanks for this - we've been doing a lot of SSRS work lately and I'd LOVE to harness this. Definitely going to check it out!

    ------------------------
    David Caughill
    Production DBA
    Grad Student
    Coffee Enthusiast