Thanks for getting back to me so quickly...

There is a month field in the dataset too but how would i write the switch function to include the relevant month? I...

Not the end of the world, I'm just being lazy!!

Thanks again...

I'll give it a go!

Thanks for your help!

Thanks for the prompt response!

Is this possible in a text box where there won't be an associated dataset?

Cheers for that - I'll give it a go...

Thanks again for all your help!

Thanks for getting back to me!

I'm a little confused about the RAG paramater on the other report. The report shows a matrix table with month names acros the top (columns)...

It seems i have to Save As the reports as rdl and they will return to the original format. Still have no idea why it happened but at least i...

I have tried that and the report runs but no image - i may be referencing the image incorrectly - although i would have thought this would be flagged at...

Cheers for that - explains why i can't find it!!

Gila too!!

Cheers Ryvled - very helpful..

I'll have a play around and see what i can come up with..

Thanks for your help...

Thanks for your quick response.

I'm actually using it in a Where clause where the datediff is > 65 days but it doesn't seem to be quite working because i know...

Hi

I simply want to learn the nested ISNULL variation

Sorry Jeff - realized after I had sent the reply....

Thanks again.