Finance | Project Operations, Human Resources, ...

How do we Increment a number sequence for a field in RDP SSRS Report for record selected in form?

(0) Share

Report

Posted on by Prachi Gupta

For

General Ledger > Journal > General Journal form

when i select a record and click on a button in the form, a report is created, a number sequence should be created in the report.

So everytime i click on a record (single record can be selected at a time) , a report will be created and then the number sequence (for the field invoice number )will increment and a new one will be seen in the report .

eg:

record: 0001 when selected , then the report will contain a field with invoice number = Inv0001

when record :0006 is selected , then report will contain a field with invoice number = Inv0002

when record :0001 is selected again , then report will contain a field with invoice number = Inv0003

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

nmaenpaa 101,172 Moderator on at

Like (1)

Report
Copy link

Link copied!

This doesn't seem like a normal use case for "invoice number". But I assume you already discussed the functional requirement with financial experts of your company. If not, please do so.

In general you can solve this requirement by developing a new number sequence, setting it up in your module's parameters, and then asking for a new number from this number sequence in the generation of your report. Assuming it's a temp table based report, you need to store the number in the temp table.

This blog explains how to do it: daxbeginners.wordpress.com/.../

Was this reply helpful? Yes No
PrachiGupta97 154 on at

Like (0)

Report
Copy link

Link copied!

How do we ask for a new number from this number sequence in the generation of your report? Could you give me the code and where do we write it?

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

The code is in the blog that I shared. It must be called during the execution of your report, during population of your temp table. If you don't have a temp table, I believe you can develop a display method in the table that the report is based on, and put the logic there.

You can google for how to use display methods in SSRS reports. Then apply the knowledge about number sequences (from the blog post) and you're good to go.

Was this reply helpful? Yes No