Group all non zero values 1

[manjulam]

I have a report with a field "cost" which can be >= 0. i want all non zero rows to be grouped under the name "paid" and the rest in "free". I created a group with expression "cost>0" but now, each row with a non zero value is a group. That is not what I intended. Any ideas?

 

[RiverGuy]

Go to your "DataSets" window in your toolbar, and right-click your dataset's name to add a new field. Give this field a new name such as "CostType." Make this a calculated field, and in the calculation, enter the following expression:

=iif(Fields!Cost.Value > 0, "Paid", "Free")

You now have a new field for your report. You can group on this new field.

 

[manjulam]

That worked like a charm. Thanks a lot!