[]
        
(Showing Draft Content)

Show Row Numbers

Manually numbering the rows in a table is a time-consuming task. Use the RowNumber function of the Expression Editor to automatically generate the sequence number for each new row in the table. You can also apply this function on grouped data to find the running count of all the rows in the specified scope.

For more details on Expression Editor and its functions, visit this article.

To Show Row Numbers in a Table Data Region

Follow the below steps to add row numbers to a table.

  1. Add a new column to the table using the column handle or the context menu. This column will contain the row numbers.

    Add New Column through the Column Handler

  2. Enter the text, 'RNo', in the header cell of the new column.

  3. Right-click the detail cell of the new column and choose the Cell Expression option from the context menu.

    Select Cell Expression from the context menu

    Note: Alternatively, you can set the Value property in the Properties panel to Expression.

  4. In the Expression Editor, double-click the RowNumber property under Common Functions > Miscellaneous on the left.

    The expression is now displayed on the right of the editor as shown.

    Expression Editor

  5. Click Save to close the editor.

  6. Preview the report.

    Table with Row Numbers

To Show Row Numbers with Scope in a Table Data Region

Follow the below steps to add row numbers in a specified scope. These steps assume that you have already added a row group to the table. For more information on groups, visit this article.

  1. Add a new column to the table using the column handle or the context menu. This column will contain the row numbers for the group.

    Adding new column to table

  2. Enter the text, 'Group RNo', in the header cell of the new column.

  3. In the Group pane on the right of the table, select the row group name.

    Select Row Group Name in the Group Pane

  4. Copy the name of the group name from the Value property of the Properties panel.

    Copy Group Name from the Properties Panel

  5. Right-click the detail cell of the new column and choose the Cell Expression option from the context menu.

    Select Cell Expression from the context menu

    Note: Alternatively, you can set the Value property in the Properties panel to Expression.

  6. In the Expression Editor that opens, double-click the RowNumber (Scope) property under Common Functions > Miscellaneous on the left, and paste the group name enclosed with double quotes as shown.

    Add Row Numbers

  7. Click Save to close the editor.

  8. Preview the report.

    Table with Row Numbers