none
Report Row number RRS feed

  • Question

  • I have a report that I can't display the sequence of number.
    1) I like to display number start with 1, 2, 3, 4, 5 .... (basically previous + 1)
    2) Data that display in microsoft report is in Group.
    (group by CustomerName but display sorted by the TotalAmount of each customer)

    I tried RowNumber("table1") but does not work

    Please advice.


    Eg:
    No.   CustomerName     Total Amount
    1      Adam                   200
    2      John                     152
    3      Thomas                110
    4      Megan                  90
    5      Toda                    50
    Monday, August 31, 2009 1:12 AM

All replies

  • Try RowNumber("CustomerName")..
    Aftab Ansari
    Monday, August 31, 2009 9:15 AM
  • you can't because a scope parameter that is not valid for an aggregate function...
    but RowNumber(Nothing) is ok... but does not show in order 1, 2, 3, 4, 5, 6,....
    Monday, August 31, 2009 11:00 PM

  • I have a report that I can't display the sequence of number.
    1) I like to display number start with 1, 2, 3, 4, 5 .... (basically previous + 1)
    2) Data that display in microsoft report is in Group.
    (group by CustomerName but display sorted by the TotalAmount of each customer)

    I tried RowNumber("table1") but does not work

    Please advice.


    Eg:
    No.   CustomerName     Total Amount
    1      Adam                   200
    2      John                     152
    3      Thomas                110
    4      Megan                  90
    5      Toda                    50

     

    try

    =RunningValue(Fields!CustomerName.Value, CountDistinct, "AllTable")

    Friday, September 10, 2010 10:25 AM
  • THANK YOU!!!  This is exactly what I needed - worked perfectly!

    =RunningValue(Fields!CustomerName.Value, CountDistinct, "AllTable")

    Thursday, October 25, 2012 10:20 PM