Nice catch. Just responded to some questions about this the other day in the SSRS MSDN forums - Making a subreport problem. If you have questions about the...

Are you trying to configure custom clickthrough reports? If so, this is an Enterpirse Edition only feature and clickthrough is not available in Standard Edition.

Working with Clickthrough...

You already have that in one of your many sub-select statements 'SELECT ( STRTOSET(@YearMonth, CONSTRAINED) ) ON COLUMNS'. You could simply remove that and place this parameter into your...

I know this is an old link, but is this one of the hacks you are talking about - Data Driven Subscriptions in SQL RS 2000 Standard.

Explanation

This error occurs when you create a schedule for a subscription, for report history generation, or for refreshing a report execution snapshot. You can schedule or automate report processing...

If you need to see the different levels in the hierarchy then there is no way around this unless you ran this through a stored procedure instead using a linked...

Here is the Configuring Reporting Services to Use SSIS Package Data link. This will work with 2005.

The other links I had sent were referencing 2005.

I would always make sure that you have the latest service pack installed. Do you have any service packs installed? I would download and install SP3 and see...

This should provide you with all of the information you need to setup the reports to use SSIS and pass in parameters:

Configuring Reporting Services to Use SSIS Package Data

Using a...

No problem. Jamie has tons of excellent content, examples, and downloads available to review in regards to SSIS and that is why he is an MVP:) He monitors...

You should be able to go in the following location (depending on where your install was done, but assuming just the default) - C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\ and within...

Do you have any additional information or details that you can provide? SP3 for SQL Server 2005 was released in December 2008, is this what you are trying to...

Seems like it would be very logical to implement the Foreach Loop Container. I would recommend looking around on Jamie Thompson's blog and finding examples and information that will...

You need to install and configure the Oracle client tools on your SSRS front-end servers.

If you are trying to access the SSAS information by using a stored procedure in your database I know how you can do this in SQL Server, but not sure...