0

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

Neo
  • 15,491
  • 59
  • 215
  • 405

1 Answers1

1

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.

Konrad Z.
  • 1,592
  • 4
  • 20
  • 34
  • Thanks i'm new to rdlc please tell me how can I use row grouping in my case? – Neo Jan 02 '14 at 08:36
  • 1
    1. Add new table to your report. 2. Go to tablix properties 3. Select your dataset name and click ok 4. Click on your table, so that you'll see in Row Groups area, group named "Details" 5. Right click on this group and go to group properties. 6. Click Add button to add field by which you want to group values. – Konrad Z. Jan 02 '14 at 09:01
  • getting error The definition of the report '' is invalid. More than one dataset, data region, or grouping in the report has the name ‘Group1’. Dataset, data region, and grouping names must be unique within a report. – Neo Jan 02 '14 at 10:05
  • All groups, datasets etc must be unique within the report. You need to change the name for the "Group1". – Konrad Z. Jan 02 '14 at 10:41
  • yea but i'm not getting name in properties :( also please tell me – Neo Jan 02 '14 at 10:47
  • i'm getting this error after adding new table in rdlc :( and i do not find Group1 name anywhere :( – Neo Jan 02 '14 at 10:59
  • 1
    Try to create new rdl file. – Konrad Z. Jan 02 '14 at 11:12
  • I did :( same error could you please share any link which is similar to my question – Neo Jan 02 '14 at 11:46
  • Try to restart visual studio. Sometimes it caches reports and displays incorrect results. – Konrad Z. Jan 02 '14 at 12:15