Column Totals per page

• SSRSDev

  Old Hand

  Points: 344

  More actions

  November 21, 2010 at 7:43 pm

  #231794

  I display whole bunch of records in a table grouped by EmpID. and each EmpID details display in a new page in my report. When I do a Column Total for a Particular column in my Page Footer it displays perfectly. But, if One EmpID details span over multiple pages, I am not able to display the same count per page, instead it displays at the end of all pages.

  So now my question is, How do I display the page totals, if One EmpID details flow to mutiple pages.?????

  Please help.

• only4mithunc

  SSCrazy Eights

  Points: 8434

  More actions

  November 22, 2010 at 10:59 am

  #1253894

  Hi,

  Could you please try this:

  1) Put a table Group on the EmpID.

  2) Add group footer.

  3) Get the total details in the group footer.

  4) Keep a page break for the group.

  Thanks & Regards,
  MC