No join needed in the report. Doing it in the RDD makes the ShipHead.TrackingNum a field in the ARForm data set in the report. Think of the RDD as a data view. It combines all those tables in the RDD into one dataset, named ARForm. Actually, several datasets but the others are “overhead” (Company and RptParameter).
The fields of the added table should be part of “T1” in the dataset expression. So just do steps 3 - 6 below.
- In the Report Data pane, expand Datasets, right-click the OrderHed dataset and select Dataset Properties.
- In the Dataset Properties dialog box, verify that Query is selected on the left, and then click the fx button under Query on the right. The Expression dialog box opens.
- Add the OrderDate field to the expression:
a. Resize the dialog box to make the expression (SQL query) in Set expression for: Query.Command.Text easier for you to read.
b. In the expression, find T1.Calc_HeadComment, and immediately following that field type T1.OrderDate, (be sure to include the ending comma).
In this expression, T1 is the alias for OrderHed table.
c. Click OK to save your change and close the Expression dialog box. - Back at the Dataset Properties dialog box, add OrderDate to the dataset:
a. Select Fields on the left.
b. On the right, click Add to create a new row at the bottom of the field list.
c. In the new row, type OrderDate for both Field Name and Field Source.
d. Click OK to add the new field and close the Dataset Properties dialog box.