You could use the FILTER funtion to remove those that are <= 0. Here is an example that works in the Adventure Works sample cube:

SELECT

[Measures].[Internet Sales Amount] on columns,

FILTER([Promotion].[Promotion].children,...

Nope. It was suggested that I uninstall and re-install.

Thanks. It was named that way because if you do not follow all the steps you will encounter a 401. We maybe should have added something about upgrading...

ERROR: Client found response content type of '', but expected 'text/xml'.

We did encounter this error. You have to ensure that your proxy or application is referencing the...

This only applies to SSRS 2008. SSRS 2005 uses IIS, therefore these options would be set there. shoot me an email at pleblanc@tsqlscripts.com if you need help.

Not without searching extensively through the error log. I would suggest using the Profiler or as you stated in your posts events, specifically extended events if you are running...

yes

Thanks, this will come in handy with some of my complex warehouse transformations.

Thanks

Thanks. That is what I was looking for.

Can a SQL Server 2005 database engine host the ReportServer and ReportServerTempDB database for a SQL Server 2008 Reporting Service installation?

Sorry for the confusion.

Great Video. I have a question. We have a group of developers that rollout scripts to specific servers. I need to grant them permissions that will allow...

Thank you.

Thanks for the post, I found the answer that I needed. I am going to Alter my database and set a maximum size. This will prevent it from...

Datafile.

Thanks for the reply