Tag Archives: SSRS

Automatically Using the Latest Version of an SSRS Template

The ability to add Templates to SSRS (such as documented here and here and here) is a neat feature.  Basically, you just create an RDL and put it in the “C:Program Files (x86)Microsoft Visual Studio 9.0Common7IDEPrivateAssembliesProjectItemsReportProject” directory… now you can … Continue reading

Posted in Uncategorized | Tagged | Comments Off on Automatically Using the Latest Version of an SSRS Template

Prevent SSRS 2008 from Overwriting Datasets

Report development is one of my favorite areas of Business Intelligence and I have to say I’ve been fairly happy with the new interface for SSRS 2008.  Except for when it comes to MDX queries.  Off the top of my … Continue reading

Posted in SSRS | Tagged , , , , , , | Comments Off on Prevent SSRS 2008 from Overwriting Datasets

How to Pivot Data in SSRS

Pivoting data can be tricky to say the least, whether the actual pivot is done in SQL Server or Reporting Services. There are cases to be had for both approaches, only to be constrained by your reporting design requirements. I’ve … Continue reading

Posted in Uncategorized | Tagged | Comments Off on How to Pivot Data in SSRS

How to implement cascading parameters in a SQL Services Reporting Services MDX Report

Background Last week, I needed to prototype a report against an Analysis Services 2005 cube for a client.  The report wasn’t too complicated… I just had the requirement to allow a user to drill down a hierarchy by selecting a … Continue reading

Posted in Uncategorized | Tagged , , | Comments Off on How to implement cascading parameters in a SQL Services Reporting Services MDX Report