Hi,

You should be able to do this by using a drived table which is basically making your query into a table on the fly.

Basiacally it would be

select *...

Hi,

I think you need to use a nested iif statement something like the following can be used:

=iif(Fields!Count.Value >0,"Green",

iif(Fields!Count.Value =0, "orange",

iif(Fields!Count.Value >-10, "orange",

"red")))

This should work, let me know how...

The history page you have mentioned only contains settings, I have checked the tickbox

'Store all report execution snapshots in history '

This requires a default parameter which I have...

Thanks Guys

much appreciated.

Thanks that may well do the trick

🙂

Thanks the dateadd function works fine!

🙂

I just discounted it as it had date in its title

:blush: