Im making some modifications to an out the box report(quoteform), i linked the ShipTo table to pull the customers name and address.
However both the QSalesRP table and ShipTo table have a field called “Name” and only the QSalesRP Name field is passed to the report.
I cant figure out how to get Name from the ShipTo table to show up. Any help would be appreciated, thanks!
In Report Builder, DataSet, query, you’ll see all of the fields being selected in the SQL query there. You probably have something like T4.Name, T7.Name, etc. Change one of them to “T4.Name as ShipToName”. Then in the field list for the dataset, under the source column, change it to the same name you gave the field in the SQL statement, such as “ShipToName”. This technique is giving your field names an alias so that they can be referred later uniquely.
That worked, Thanks a bunch!