locked
SSRS 2.0 - Tell Row Count in Table Footer? RRS feed

  • Question

  • User1826967303 posted

    Greetings,

    I am trying to figure out how to determine how many rows have been shown (running count) and have it displayed in my table footer in SSRS 2.0.  

    For example:

    [Team Name][Player Name][Player Number][Position]

    NY Homerunners - Joe Baseball - 12 - 1st Base

    .....

    ...

    [     Showing 13 players                                          ]  <--  Footer shows count of "13" thus far, next page would be 26 (e.g.)

    When I try to use an expression like: ="Showing " & RowNumber("MyTablix") & "players." it just shows me my total row count on each page.  The help says scope should be the containing group, but I don't think I have a containing group for the table footer.  If I add a row within my group, it repeats after every data row.  

    Is it possible to do what I am trying to achieve in SSRS 2.0?

    Thx,

    Rob

    Friday, April 10, 2015 10:38 AM

Answers

  • User1711366110 posted


    When I try to use an expression like: ="Showing " & RowNumber("MyTablix") & "players." it just shows me my total row count on each page.  The help says scope should be the containing group, but I don't think I have a containing group for the table footer.  If I add a row within my group, it repeats after every data row.  
    Is it possible to do what I am trying to achieve in SSRS 2.0?

      As per your case, you can try the following steps :

    1.To display the running rowcount value on every page, you can use the page footer.

    2.Add a page footer to your report. In BIDS you can select, Report, Add Page footer.

    3..Insert a  text box (for Current Page count ) to the page footer.

    4.Open the expression definition of the first text box. In this text box you will define count of  PlayerNumber of the current page.

    ="Page Current Total: " + cstr(Count(ReportItems!PlayerNumber.Value))

    5.Or If you want to Displaying Fixed Number of Rows per SSRS Report Page then Click here to refer.

    --
    with regards,
    Edwin

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, April 12, 2015 10:59 PM