Lowell, that's great, I'll look into that.

Do you happen to know if there's an event log dedicated just to Management Studio? I couldn't see one, I wanted to see what...

That's really helpful, I wasn't aware of that built in field, thanks 😀

I think this was a two stage process really. In the first instance we were trying to ascertain how many errors and at what severity were occurring, based on that...

Boo! That's what I thought after some playing around for a while.

Is there any third party app which would achieve this or do all the SPs need to be edited...

Specifically defining columns, at no point in any of the stored procedures would select * be used (well, except in cases of a temp table but this wouldn't be in...

Ah, as I thought then :/

The view idea (if we ever get Enterprise or it's a feature in 2012) is a cool idea though!

Different reports within the same folder, however, Data Driven Subscriptions are in the enterprise version I believe? Which is a shame as there's been a few other areas I could...

Thanks Micah, that's very helpful. I think for my application ASCII may be a little limiting, someone on the Microsoft SSRS forum said I could use UTF-7 instead of 8....

Sorry to bump an old thread but I found this linked to via the technet forums, sadly the developer barn link doesn't seem to work, can anyone give me some...

Thanks for the reply, I should have responded sooner, I sussed out how to do this, I've basically been tweaking it and playing with it since. The problem was actually...

I looked into it some more and it seems SSRS puts "" around cases where it's required, I think the problem may have been trying to import without specifying "...

Ah, I see, this makes sense now, so I was sort of on the right lines, so I'd use the Calendar table to build up a collection of exclusion days,...

Can anyone give me any pointers on how I'd use a calendar table as suggested to accomplish this?

I can see how I could use one to identify the number of...

Many thanks Burninator, the second approach seems to work well, I'm not too sure why I didn't think of just making the chart look to the parameters rather than just...

I'll hassle some of our in-house developers, I've never touched dot net in my life (besides reading the odd bit of it here and there to try and see what...