Telerik Reporting

3 posts, 0 answers
  1. Daniel
    Daniel avatar
    9 posts
    Member since:
    Oct 2011

    Posted 26 Aug 2012 Link to this post

    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. Daniel
    Daniel avatar
    9 posts
    Member since:
    Oct 2011

    Posted 30 Aug 2012 Link to this post

    bump - someone must know how to do this :)
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Grigore Dolghin
    Grigore Dolghin avatar
    19 posts
    Member since:
    Mar 2010

    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.
Back to Top