Reportviewer groupby first letter of first field RRS feed

  • Question

  • Hi there, i hope you can help me on this.

    I have a table that look like the image above, i am grouping by the first field that is employeecode, but the reportviewer is separating each unique code, so i have the next condition in the group expression, by the first letter of the field, in this group will be C .


    It does what i want, but, i when i do the sum of the totals it returns duplicataed rows,the first row of the subtotal is correct, but the other sums are duplicated,like this:

    Im making the sums of the "total" field in the respective group footer, with this sentence 
    =Sum(Cdbl(Fields!total.Value),"Group_Z"), chaging the parameter for each group.

    I hope you can help me. Thanks in advance

    Saturday, January 19, 2013 5:48 PM