The ROW_NUMBER field numbers each line item in a detail dataset and is included by default in every report or query dataset.

Insert this field into any detail region in the template to number the results in the merged output file.

Syntax: {{Row Number}}

Notes: This merge field must be placed in the far left column of a data table.

Usage Example:

Item NumberProduct NameQuantityTotal Price
{{TableStart:OppLineItems}}{{ROW_NUMBER}}{{PRODUCT_NAME}}{{OPPORTUNITY_LINEITEM_QUANTITY}}{{OPPORTUNITY_LINEITEM_TOTALPRICE \# Currency }}{{TableEnd:OppLineItems}}

The merged output file looks like this: