web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Number sequence for a ...
Finance | Project Operations, Human Resources, ...
Answered

Number sequence for a customized ssrs report parameter

(4) ShareShare
ReportReport
Posted on by Ramkishor reddy 244
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)
  • Adis Profile Picture
    Adis 5,691 Super User 2025 Season 2 on at
    Number sequence for a customized ssrs report parameter
    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

  • Ramkishor reddy Profile Picture
    Ramkishor reddy 244 on at
    Number sequence for a customized ssrs report parameter
    Hi adis ,
     
    Don't bother about the records to include ,
     
    I need Number Sequence for the Reference number parameter.
     
    Thanks!!
  • Martin Dráb Profile Picture
    Martin Dráb 236,312 Most Valuable Professional on at
    Number sequence for a customized ssrs report parameter
    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?
  • Ramkishor reddy Profile Picture
    Ramkishor reddy 244 on at
    Number sequence for a customized ssrs report parameter
     
    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
  • Martin Dráb Profile Picture
    Martin Dráb 236,312 Most Valuable Professional on at
    Number sequence for a customized ssrs report parameter
    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.
  • Verified answer
    Saalim Ansari Profile Picture
    Saalim Ansari 648 on at
    Number sequence for a customized ssrs report parameter
    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

     
  • Ramkishor reddy Profile Picture
    Ramkishor reddy 244 on at
    Number sequence for a customized ssrs report parameter
     
    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.
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 236,312 Most Valuable Professional on at
    Number sequence for a customized ssrs report parameter
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,157

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 883 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 674 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans