Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 302 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
How to modify reports in D365BC using VS Code
jordi79
Member Posts: 275
How do we modify reports dataset in d365bc using VS Code?
I cannot find anything official from any of Microsoft Training videos. The only training I can find is just to create a list report, and I think this is too simple an example.
I searched and found in other forums to create the report in old c/side and to use txt2al to export to AL. But in D365BC Oct2019 Release, you can no longer export objects from the database. I tried to execute the PS command Export-NAVApplicationObject, but this command is no longer recognised in this release.
Jordi
I cannot find anything official from any of Microsoft Training videos. The only training I can find is just to create a list report, and I think this is too simple an example.
I searched and found in other forums to create the report in old c/side and to use txt2al to export to AL. But in D365BC Oct2019 Release, you can no longer export objects from the database. I tried to execute the PS command Export-NAVApplicationObject, but this command is no longer recognised in this release.
Jordi
0
Best Answer
-
SanderDk
Member Posts: 502
HI jordi79
You cannot (yet) change a report, you do need to create you own report.
A way of doing that is to copy a standard report and do you modification.
If your report have a report selection, you can change the report there, if not then you need to do a bit of coding and hook into the Report Management Codeunit.
You can get the standard report in a couple of different ways, person I like do this in a container with the script from Freddy:
https://freddysblog.com/2019/07/31/preview-of-dynamics-365-business-central-2019-release-wave-2/
a different way is like waldo descrip here:
http://www.waldo.be/2019/03/01/business-central-as-an-app-getting-to-the-al-source-code/For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.5
Answers
You cannot (yet) change a report, you do need to create you own report.
A way of doing that is to copy a standard report and do you modification.
If your report have a report selection, you can change the report there, if not then you need to do a bit of coding and hook into the Report Management Codeunit.
You can get the standard report in a couple of different ways, person I like do this in a container with the script from Freddy:
https://freddysblog.com/2019/07/31/preview-of-dynamics-365-business-central-2019-release-wave-2/
a different way is like waldo descrip here:
http://www.waldo.be/2019/03/01/business-central-as-an-app-getting-to-the-al-source-code/
I followed the blogpost from Freddie. The objects are stored in -->
C:\ProgramData\NavContainerHelper\Extensions
After running New-NAVContainer as per Freddie's blogpost.
Thanks.
Jordi
You mark the answer or answers that help you solve your problem