Nice article. Do you have any recommendation regarding CTEs vs. temporary tables in 2005 or 2008?

No problem. Glad it worked.

I'm not sure, but I think you might be able to achieve this in SSRS 2008, if you have the option of installing SSRS 2008.

Excellent. If it looks like you'll have something ready and the "posting/publishing" is delayed, can you e-mail something in the interim. 🙂

When do you think you'll have the SSAS article in a draft form?

I echo all of your sentiments. Having been a BI consultant for over 10 years, I'm very excited about the opportunity that SQL Server and SharePoint now present many customers...

I see, so you want to see Jan, Feb and Mar, but without a line running across the bottom representing no data. Is that it?

You can't modify the dataset to only return the values you want to plot on the chart?

Have you tried combining the PIVOT function (see basic example on http://msdn.microsoft.com/en-us/library/ms177410.aspx) with SSRS totals for your "footer"? The PIVOT syntax takes some getting used to, but it...

Does this starting month vary based on any parameters selected for the current report? If not and there is some relative date logic associated with the relevant months (e.g. rolling...