The bug I was seeing was fixed when I applied SP1 to SQL 2005 Reporting Services.

I dont quite understand the question.

It may help if you give an example of your desired output.

e.g. Do you want one row per division?

On each row what do you want...

sa is a server login, dbo is a database owner which is a particular database user.

You need to understand that logins and database users are not the same.

If you look...

Thanks alzdba - I am changing the job owners where possible.

We also have problems with jobs that use linked servers relying on integrated auth.

I would like to hear if people...

Its a bit late for this post but I have a similar problem.

It seems to happen when I schedule OLAP processing through SQL Agent processing xmla commands.

I can work around...

One way to stop it from happening is to change the parameter data type to String. This means the date picker wont display.

I suspect this bug has to do with...

I enjoyed the article and the discussion.

MS has lots of nice goodies and its the way of the future so I tend to use it and only drop back to...

I am in a similar situation.

I think in the designer the format of the datepicker depends on the locale of the machine running VS2005.

When the report is deployed the format...

I tried this (Kirks original post) and it works.

I had not used the scripting task before but managed to get it to work quite quickly. With a bit of effort...

Thanks Kirk that looks spot on. Im going to try it this weekend.

Ill be looking for the book too.

I tried tracing as cliffb suggested.

Several steps were executed on analysis services, including serialising the output. The trace recorded error=1 on the final step and also success=1, but no meaningful...

Thats a good point. I should have mentioned I used "Use the security context of the current user"

Has anyone actually got this to work?

Thanks for the article - Ive been looking for an easy way to do this for ages.

If it hadnt been called best kept secret, I probably wouldnt have bothered to...

I am surprised there is so much discussion of SQL injection when a simple coding technique can always be used to avoid it.

The most important point Michael makes is "be...

We are running SP3a + hotfix.

Not SP4 yet.

The output is truncated at the same point when I use the profiler interactively and also if I save the trace to a...