Thursday, November 10, 2005 5:14 PMI 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
Friday, November 11, 2005 1:43 AMThis seems like something you want to do in the sql query rather than the report. Not sure, exactly how...
Friday, November 11, 2005 2:02 AMSince 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 11:44 AMHi,
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:39 PMThank you for your assistance. "RunningValue" is not available in Report Builder.
Monday, August 06, 2007 8:45 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
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?
Tuesday, August 07, 2007 8:35 AM
If you add RowNumber("DSName") in the first column then it should work...
Tuesday, August 07, 2007 11:05 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.