this was for ninja RGR_US

This worked a treat for all the totals that i am using....thank you so much for your help.

Thanks but Taking the quotes of 0.00 worked for the sub total for each cost code, but not the grand total.

its a calulated field.

=iif(Fields!valuehome.Value>0,Fields!valuehome.Value,"0.00")

Not sure where to define what type of field it is

Its is in BIDS(Business Intelligence Delvelopment Studio) 2008. Reporting Services tool.

The report is grouped by a field called costcode, then I have fields such as Supplier, Customer, Value.

each cost...

Hiya

its just shows as '#error' in the cell.

It is pounds values

When i right click on the footer i dont have the options for parameters.

But i have dragged the parameter onto the report footer, but still get the error message!! 🙁

yes sorry that is what I meant I was putting the wrong table.

But Ive still got a problem it runs perfectly within qeury designer, but when i actually run th...

its ok, I was writing the wrong field

Thanks for you help

Thank you but it keeps saying error ' Ambiguous column name 'period' '

Any ideas