none
RDLC - sum of table columns without duplicates

    Question

  • Hi,

    I am creating an RDLC that interfaces with a SQL server view. 

    The view returns duplicate invoice items but I eliminate it by using the details grouping of the table.

    Now, if I have to find the total invoice amount using sum(), it is calculating the sum of all the fields, including the duplicates.

    i.e. Say that the rows are duplicated twice by the view, I display it only once using details grouping in table. Now, I have:

    service_name subtotal

    service 1  $240.00

    service 2 $100.00

    TOTAL $680.00

     

    I want the TOTAL to be $340.00

    How do I solve it?

     

     

    Wednesday, December 21, 2011 7:05 PM

All replies