Posted 02 Sep 2012
Link to this post
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.