Line numbers in Report Builder


  • I have a report in which the user community would like line numbers associated with each row.  Has anyone done this or have any ideas how to accomplish this?

    Line Item   Manufacturer
    1               Mazda
    2               Ford
    3               BMW

    Thursday, November 10, 2005 5:14 PM


All replies

  • This seems like something you want to do in the sql query rather than the report.  Not sure, exactly how...
    Friday, November 11, 2005 1:43 AM
  • Since you drag elements into the design area and Report Builder is not based on a query, there is no way to create line item numbers within Report Builder.

    Is that what you are saying?
    Friday, November 11, 2005 2:02 AM
  • Hi,

    You can use RunningValue function as the text value of the line number column.

    If you want a numbering for rows within a dataset, you can use

    =RunningValue(1, SUM, "Employees")

    where Employees is the dataset name.

    If you have groups in your reports, say one of the groups has a name "EmployeesByCity", then you can replace the last part of the RunningValue with this group name shown as below

    =RunningValue(1, SUM, "EmployeesByCity")

    You can check the below link for a sample

    Friday, November 11, 2005 11:44 AM
  • Thank you for your assistance.  "RunningValue" is not available in Report Builder.
    Friday, November 11, 2005 11:39 PM
  • I've got a similar issue that RunningValue won't work for. Basically, what the business users want is a line number for each line in the report. Independant of the groupings.  I believe this has to be done during the rendering of the report as it has to cross groups after all the report processing has been done. Here's a small sample of what they want it to look like.


                                           Column A      Column B      Column C

    1 Group 1 Header

    2         Group 2 Header

    3                   Detail

    4                   Detail

    5                   Detail

    6         Group 2 Footer

    7 Group 1 Footer


    The count can reset at the begging of each page, or continue, doesn't really matter. I'm trying everything I can think of.

    Any ideas out there?



    Monday, August 06, 2007 8:45 PM
  • If you add RowNumber("DSName") in the first column then it should work...


    Tuesday, August 07, 2007 8:35 AM
  • Unfortunately, it's not that easy. Doing that, you get the total #f rows for each group on the group level headers. I need the count to be a straight rendered line number count and not be tied the underlying data set or grouping structure.



    Tuesday, August 07, 2007 11:05 AM