Post reply

SSRS custom code and page wise subtotal

  • February 16, 2012 at 1:59 am

    #264518

    i want to show per page wise sub total writing custom code.

    the output would be like

    Page 1

    Employee Name Salary

    ------------- -------

    keith 2000

    Robin 4000

    Mou 3000

    Sub Total 9000

    Page 2 i mean next page

    Employee Name Salary

    ------------- -------

    Markc 1000

    Poll 2500

    Sam 1500

    Sub Total 5000

    i want to declare a shared variable and a function and i need to call my function after each rows render and i will pass the the salary to that function and that function sum the salary and put the output in shared variable which i will display at the table footer. when i will go to next page then shared variable will be re initialize again and hold the sum of salary for that page. if i can do it then per page wise sub total can be shown. i am new in SSRS so i dont know how to associate my function call when each row render......please guide with code and full instruction in detail.

  • February 16, 2012 at 6:57 am

    #1447846

    You don't really need custom code to show page level subtotals.

    Assuming the value field that you want to sum by page is called txtRowValues, put a text box in the report footer with the expression of =SUM(ReportItems!txtRowValues.Value)

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply