This is a migrated thread and some comments may be shown as answers.

Telerik Reporting

2 Answers 16 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Daniel
Top achievements
Rank 1
Daniel asked on 26 Aug 2012, 06:42 PM
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

2 Answers, 1 is accepted

Sort by
0
Daniel
Top achievements
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
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.
Tags
General Discussions
Asked by
Daniel
Top achievements
Rank 1
Answers by
Daniel
Top achievements
Rank 1
Grigore Dolghin
Top achievements
Rank 1
Share this question
or