Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
Options
Adding a Field to a Report from a Different Table
navdarren
Member Posts: 3
I have a report called Quote Analysis that's made up of two DataItems: "Sales Header" and "Sales Line".
The report shows information such as "Quote Number", "Customer Name", "Quote Date" etc.
I'd like to add a new column to the report called "Branch", which needs to come from the Customer table from a field also called "Branch", but I can't work out how to do this.
I've tried adding a new Variable within "C/AL Globals" called "CustomerBranch" and set the DataType to "Record" and the Subtype to "Customer" table. I then added a new TextBox to the report, and set the SourceExpr as "CustomerBranch.Branch". When I run the report the Branch field is empty; I presume I'm missing some code which will show the data.
I'd really appreciate any help with this.
I'm using NAV 5.0 SP1.
Many thanks.
The report shows information such as "Quote Number", "Customer Name", "Quote Date" etc.
I'd like to add a new column to the report called "Branch", which needs to come from the Customer table from a field also called "Branch", but I can't work out how to do this.
I've tried adding a new Variable within "C/AL Globals" called "CustomerBranch" and set the DataType to "Record" and the Subtype to "Customer" table. I then added a new TextBox to the report, and set the SourceExpr as "CustomerBranch.Branch". When I run the report the Branch field is empty; I presume I'm missing some code which will show the data.
I'd really appreciate any help with this.
I'm using NAV 5.0 SP1.
Many thanks.
0
Comments
CustomerBranch.GET("Sell-to Customer No.") to the code in the sales header data item.
You should also download or buy some manuals / books on C/AL programming.
The original training manual will lead you through all the basic concepts.
http://mibuso.com/blogs/davidmachanick/