sql server reporting services: Hi,

How do I create a subtotal field for my report. I have a field distance. So
I need to display a total distance field as sub total.

How do I do that..is there any settings in the reports for this?

Thanks in advance.

[quoted text, click to view]


If you have grouping in the report, right-click one of the fields used
in the group and select 'Subtotal.' If there is not any grouping in
the report, you should be able to use a sum expression like the
following:
=Sum(Fields!Distance.Value)
Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant