How To display the Sum Of Columns in Each Pages in RDLC

Question

Hi All...

I want to show item reports in use of RDLC,i need each pages total like the following structure.

Page 1:
--------------------
Item name rate
--------------------
Book 35
Pencil 10
Pen 40
--------------------
Total 85
Page 2:
--------------------
Item name rate
--------------------
Book 20
Pencil 10
Pen 40
--------------------
Total 70
Page 3:
--------------------
Item name rate
--------------------
Book1 30
Pencil1 10
Pen1 40
--------------------
Total 80

Page 4:
--------------------
Item name rate
--------------------
Book2 40
Pencil2 10
Pen2 40
--------------------
Total 90;

The Last page of RDLC is Showing the Grade Total like this
Grade Total = 325
Send Your ideas...

sathish kumar · Answer

I got the solution.. Step 1: Create the table and insert data into that table normally. Step 2: Create Page footer and also crate one textbox in that footer.and go to that textbox expression and past the following code. SUM(ReportItems! rate .Value) Here rate=Field nameso the field name changed based upon user.