You’re offline. This is a read only version of the page.
5
For
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
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.
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?
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/.../
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (