Sunday, February 3, 2008

Displaying Row numbers in a Business objects report

Steps to add Row number to business objects report:

1). Create a variable with the following formula:

=runningCount(any variable)

2). Add the Variable to the table as the first column.

Steps to reset the row numbers:

1). Add a second argument to the runningCount function:

=runningCount(
any variable;reset variable)

when the value of the reset variable changes , the row count will reset to 0

3 comments:

Don Bowins said...

Receiving an error: "Incorrect reset context at positions 31"


My formula: =RunningCount([Vehicle Number];[Card Number])

Anonymous said...

I appreciate your effort to share some kind of information with us remarkable for revisiting.

www.triciajoy.com

reddy said...

hi
i want to display first 10 rows without ranking for a particular dimention
i have tried options like getting running count of dimetion and applied number les then or equal to 10.once the values in dimentions are changig it's giving incorrect values.
any idea how to get it
thanks in advance......