I am trying to get the terms from the sales order onto the packing slip, because the company wants to use it as a commercial invoice. The OrderHed table is present in the RDD already, so I figured it would be easy to add a relationship to the RDD and a join in the RDL. The columns are included, the relationship is there, and the query syntax is all correct…but I am getting an error:
Query execution failed for dataset ‘ShipHeadShipDtl’. —> System.Data.SqlClient.SqlException: Invalid column name ‘OrderNum’.
Has anyone else had issues with this RDD?