Thanks bmg002. I will check out all the various logs in the morning.
I've only looked at the job history in SSMS.

Thank you Anthony.

I had a look through the DB last week, but nothing jumped out at me. Will check again.

Hi Jason,

Basically what I've got now is a report that translates the paper usage for a period into an amount of trees killed, oil, water, electricity and landfill space used.

I've...

Thanks Steve,

Exactly what I was looking for. I was trying out different IIF expressions, but couldn't get one to work.

only4mithunc, I tried that. Still does exactly the same thing.

I should have maybe mentioned that it is SQL Reporting Services 2005 Express.

Hi Elliot,

I see what you're saying. So it is in fact better to remove 3 milliseconds for the end date. Then to remove 1 month from the end date for...

Nigel & Elliot (I got your names right this time), I tried Nigel's second suggested bit of code.

Except that I changed it from subtracting 3 milliseconds, to subtracting 1 day...

Nigel & Elliot (I got your names right this time), I tried Nigel's second suggested bit of code.

Except that I changed it from subtracting 3 milliseconds, to subtracting 1 day...

Nigel & Elliot (I got your names right this time), I tried Nigel's second suggested bit of code.

Except that I changed it from subtracting 3 milliseconds, to subtracting 1 day...

Nigel & Elliot (I got your names right this time), I tried Nigel's second suggested bit of code.

Except that I changed it from subtracting 3 milliseconds, to subtracting 1 day...

Nigel & Elliot (I got your names right this time), I tried Nigel's second suggested bit of code.

Except that I changed it from subtracting 3 milliseconds, to subtracting 1 day...

Okay, firstly I'm an idiot. Was looking at the wrong places for your names. You can feel free to mock me mercilessly. Thanks, Elliot & Nigel. 🙂

I took Nigel's second...