Number sequence for a customized ssrs report parameter

(4) Share

Report

Posted on by Ramkishor reddy

295

Hello all,

I have requirement in d365 f&o.

For a customized SSRS Report Parameter called Reference Number I need number sequence. Is this requirement feasible? If yes how to make it happen either from the frontend or backend.

Thanks in advance

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (8)

Answers (2)

Adis 6,593 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

The tab "Records to include" is collapsed. Can you check what filters you have in that tab, if you havent already.

Kind regards, Adis

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

Keep in mind that it is possible to mark more than one answer as verified

Was this reply helpful? Yes No
Ramkishor reddy 295 on at

Like (1)

Report
Copy link

Link copied!

Hi adis ,

Don't bother about the records to include ,

I need Number Sequence for the Reference number parameter.

Thanks!!

Was this reply helpful? Yes No
Martin Dráb 239,022 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

What does it mean? Do you want a value that won't be set by a user, because it'll be generated from a number sequence? If so, can't you simply generate it in the RDP class instead of using a report parameter?

Was this reply helpful? Yes No
Ramkishor reddy 295 on at

Like (0)

Report
Copy link

Link copied!

Hi @Martin Dráb

Thanks for your response.

As you said even without parameter if the number sequence comes it it ok for me. But i need unique number for every customer irrespective of how many times I run the report.

For example I ran the report for 1000 customers for the 1st time the final number would be 1000. But If I run the report for the second time the number should start from 1001 not from 1.

Thanks in advance!

Regards

Kishor

Was this reply helpful? Yes No
Martin Dráb 239,022 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

OK, a number sequence can do that. You can find quite a few articles about how to create one, e.g. How To Develop A D365 Number Sequence.

Was this reply helpful? Yes No
Verified answer

Saalim Ansari 689 on at

Like (0)

Report
Copy link

Link copied!
Hi Kishor,

Yes, your requirement is feasible. As Martin rightly pointed out, instead of using a report parameter, you can generate the number sequence in the RDP class or wherever you're processing the data for your SSRS report.

To ensure a unique and continuous number per customer that doesn't reset on each report execution, you should:

Define a custom number sequence (you can scope it at the company or global level).

Use NumberSeq::newGetNum() in your RDP class to generate numbers on the fly.

Each time you run the report, the number sequence will continue from where it left off (e.g., starts at 1001 if last used was 1000).

So even if you run the report multiple times, the numbers won't restart from 1 — they'll keep incrementing.

For reference, you can check this blog which explains how to set up and use number sequences in D365FO:

🔗 https://dynamics365musings.com/develop-a-d365-number-sequence/

Hope this helps

Saalim

Was this reply helpful? Yes No
Ramkishor reddy 295 on at

Like (0)

Report
Copy link

Link copied!

Hi @Saalim Ansari @Martin Dráb

The blogs you pointed out are explaining the number sequence creation for the fields in regular tables. But we use RDP class and temporary table for the report . Then how to make it happen .

Waiting for your responses!!

Regards,

Kishor.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,022 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You create a number sequence for an EDT, not a field, therefore that's not a problem at all.

Then you use code to get a new number (NumberSeq::newGetNum(...).num()) and it's up to you what you'll do with the value. The number sequence framework just gives you the number; it doesn't care whether you put it into a regular table field or not. You can write it to a temporary table, pass to to a contract's parm method or anything else.

Was this reply helpful? Yes No