I have created a report that returns the following data from a transaction table, which is great.
Yard ID Stock Code Qty Date
3 001202 60 15/08/2012
The problem is I dont want to show the Yard ID, but the yardName, which is stored in another table.
Is there a way to link the two tables via the yard ID
many thanks in advance
Yard ID Stock Code Qty Date
3 001202 60 15/08/2012
The problem is I dont want to show the Yard ID, but the yardName, which is stored in another table.
Is there a way to link the two tables via the yard ID
many thanks in advance
2 Answers, 1 is accepted
0
Daniel
Top achievements
Rank 1
Rank 1
answered on 30 Aug 2012, 06:26 PM
bump - someone must know how to do this :)
0
Grigore Dolghin
Top achievements
Rank 1
Rank 1
answered on 02 Sep 2012, 06:19 PM
I would use a query that returns the data the way I want it to show. In your case, it should be a LEFT JOIN query.
Select t1.YardID, t2.YardName, t1.StockCode, t1.Qty, t1.Date From tableA t1 Left Join tableB t2 On t1.YardId = t2.YardId
In other words, this has nothing to do with the reporting tool - you should download the data the way you need it. This also makes sense from one more point of view - backend server will do a much better job joining those tables than any reporting tool.
Select t1.YardID, t2.YardName, t1.StockCode, t1.Qty, t1.Date From tableA t1 Left Join tableB t2 On t1.YardId = t2.YardId
In other words, this has nothing to do with the reporting tool - you should download the data the way you need it. This also makes sense from one more point of view - backend server will do a much better job joining those tables than any reporting tool.