asked
SSRS concatenating fields for specific field
Hello, We have a column for customer names. And customer named John Smith has made 8 purchases, so we have 8 rows for John Smith with different amounts in amount paid column for John Smith. How can I sum-up all amounts paid by John, next customer and so on. And show total for each client in his/her row? Thanks
If you don't need the details, just the totals per customer, you could use GROUP BY in the query. If you need the details and the totals, you can add a group to the table in the report.
1. Select the detail rows on the tablix. 2. Right click and select add group 3. Click Parent Group 4. select the group by column as customer name 5. Tick add the group header and click ok 6. Delete additional column just got created at the left corner of the group 7. Enter customer name and sum(amount) into the columns of the new group.
17 People are following this question.
