CODEWITHSUNDEEP
sql-serverreporting-servicesrdlcreportingservices-2005dynamic-rdlc-generation
Neo
Neo

Reputation: 16239

Need to show sum of column value at end rdlc file?

I'm working on rdlc file getting values from stored procedure from that i have created dataset to show all values on rdlc file.

Need to show AVG of column value at end rdlc file how to do this?

I tried with AVG aggregate function using expression but problem is how to group by my column ?

guide me. enter image description here

Upvotes: 0

Views: 5068

Answers (1)

Konrad Z.
Konrad Z.

Reputation: 1652

Try: =sum(Fields!Time.Value)/CountDistinct(Fields!groupingField.Value), where Fields!Time.Value is your field with time values and Fields!groupingField.Value is your field that you use for row grouping.

Upvotes: 1

Related Questions