Finance | Project Operations, Human Resources, ...

SSRS report sequence number

(1) Share

Report

Posted on by Voltes

195

Hello everyone,

When creating SSRS report in D365FO development, is there a trick (or tips) to automatically display number sequence (order number) on each of the row displayed ?

Or the only way is to insert these order number when we processing the report as I'm using RDP class ? so it's means inserting these number when insert TmpTable for the report ?

Need advice.

Thanks.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Mohamed Amine Mahmoudi 26,431 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Yes you must insert the number in your temporary table, and than you can display it in the report.

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

You can make use of RowNumber or RunningValue function in the report designer for your requirement.

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

You can use this expression = RowNumber(Nothing).

As in the below blog:

https://d365ffo.com/2022/06/10/ax-d365fo-add-row-numbers-to-ssrs-report/

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
Raj Borad 1,428 on at

Like (1)

Report

Hi all,

The solution provided by Waed Ayyad is correct and I tried it previously also.

It is used for the print Row numbers in table.

Thank you,

Raj

Was this reply helpful? Yes No
Suggested answer

Nisha Soni 2709 on at

Like (0)

Report

hello,

you can use RowNumber() expression of SSRS report.

RowNumber("Nothing") or RowNumber("GroupName") according to your requirement.

https://www.itdeveloperzone.com/2015/12/rownumber-in-ssrs.html

Was this reply helpful? Yes No
Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi Raj,

Since my answer helped you, verify it in order to help other who will face the same case.

Thanks,

Waed Ayyad

Was this reply helpful? Yes No