Row number in WebI Table

building reports webintelligence
1

Hi

We have a table, in which we want to display the row number as a first column in a table. Tried using LineNumber() and rowindex() functions, but didn’t help. Appreciate your inputs.

Thanks
Ganesh

gan_j (BOB member since 2007-02-19)

2

What do you mean, did you not get any numbers?

Mak 1 :uk: (BOB member since 2005-01-06)

3

Initially had only one row, but after including RowIndex() in a column, the no. of rows became three. I got 0 in all the three rows

gan_j (BOB member since 2007-02-19)

4

Hi,

LineNumber() should give you what you need.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

5

LineIndex = Number of a given row in a table. Note: Header’s count as rows! (At least in XIR2)

RowIndex = Row number from the data provider’s result.

JPetlev (BOB member since 2006-11-01)

6

If I’m using rowindex() function in a report, where only data provider is used its working. Its not working, if multiple data providers are present.

Appreciate, your inputs.

Thanks
Ganesh

gan_j (BOB member since 2007-02-19)

7

Sounds like it is working as expected then, it returns the row number of the query which is unrelated to your merged queries.

So, does line number not give you what you need?

Mak 1 :uk: (BOB member since 2005-01-06)

8

What about “=RowIndex()+1” as a variable.

I can see desired results in the report.
Just want to know… Is this correct as per the BOB Standards !!!

yourajai :india: (BOB member since 2011-03-09)

9

if you know the number of header rows then just subtract that amount :

For example if you had 2 header rows…then your formula would be

=LineNumber()-2

dslane (BOB member since 2010-11-03)

10

Oh hi,
:wave:

Here are a few steps to resolve this:

  1. Report Element/Call/Blank
  2. Click Report to place the cell in a desired location
  3. Enter the following formula to:
  4. =NumberOfRows ()
  5. Drop your business object inside of the “()”
  6. =NumberOfRows ([Your Business Object])
  7. Validate

Hope this clears it up.

Cheers,
Keamo

keamo (BOB member since 2013-02-22)