Adding a Field to a Report from a Different Table

navdarren

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.

davmac1

You need to add a read:
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.

navdarren

Perfect, thank you!