Check out http://blogs.msdn.com/deanka/archive/2009/01/13/diagnosing-and-troubleshooting-subscriptions.aspx.

You need to add code to the DrillThrough event in your web app. See http://www.codeproject.com/KB/aspnet/DrillThroughReport.aspx for an example.

Goodluck,

MWise

I highly recommend the William Pearson articles on MDX, Analysis Services and Reporting Services on Database Journal. Here's the link for his MDX series

I used the method in http://msdn.microsoft.com/en-us/library/ms345182.aspx

go down about halfway to the section titled: "To loop through Excel tables by using the Foreach ADO.NET Schema Rowset enumerator"

Try http://msdn.microsoft.com/en-us/library/ms345182.aspx

How do you accessing the exporting the reports: embedded report viewer, Report Manager, subscription? I've done this via a Data Driven Subscription.

Basically you need to get those dates with empty values into your dataset so the matrix can display them. How are you retrieving the data? If it is...

This is a good resource for dealing with Excel export issues: http://blogs.msdn.com/chrisbal/archive/2006/07/08/659545.aspx.

I've fixed a lot of issues by making sure all of my text boxes line up....

MS has some sample reports for database tables and columns plus some reports for SSRS usage. Try http://msdn.microsoft.com/en-us/library/ms161561(SQL.90).aspx

Have you updated the web.config for your site and changed the maxRequestLength value in the HTTPRuntime section? I believe that the default is 4MB. We had a report...