sum a "variable"??? field 1

[basbrian]

Hi, This my first attempt at a report. Firstly I have written a fairly complicated stored procedure to extract the data I want and this is held on the SQL server. Secondly in the report I am executing the SP to get the data.
In this data I have a field called status that I have placed onto a table. I have also added another column with the following in it.

=iif (Fields!status.Value = "Received",1,0)

I want to sum this column but I can not work out how to reference it. This is probably pretty simple but for a newbie that does not know what I am doing .....

 

[RiverGuy]

In this case, I would open up the DataSet tab in your toolbar. Right click your DataSet name and add a new field with your formula. In your details, you can reference this new field by the field name--as opposed to creating the formula in the text box. In your groupings, you can aggregate this new field.

 

[basbrian]

Thanks River Guy, now that I know how to do this, I will do the male thing and now go and read the manual