I need to display subtotals in RDLC reports. My report should display the following data:
Book Student Borrowed
Book1 John 2
Book1 Mary 3
Book1 Bob 1
Total: 6 --how to do it?
Book2 Alex 1
Book2 John 7
Book2 Dan 2
Total: 10 --how to do it?
Grand Total: 16
As you can see, I have data grouped by BookName and StudentName. The last column shows how many times a student borrowed this book last year. Basically, the implementation of Grand Total is a piece of cake, but I cannot determine the subtotal for each book.
Thank.
source
share