Post reply

Outer Join Functionality in SSRS 2005 Report Builder Model?

  • October 7, 2008 at 2:17 pm

    #193985

    Hello,

    MSSQL 2005/SP2; SSRS Report Builder tool

    I've noticed that the default behavior of a SSRS Report Builder model appears to be an INNER JOIN ... any thoughts on a work-around if i need it to mimic an OUTER JOIN for a client?

    ie:

    2 tables:

    Customer table = CUST; PK = CustID

    Orders table = ORD; PK = OrdID; FK = CUST.custID

    A customer can have 0 or many orders.

    I would like to allow the client to build a report, from a model, using Report Builder, which would return all the records from the customer table EVEN if they have not placed an order.

    ie:

    SELECT c.CustID, o.OrdID

    FROM CUST c

    LEFT JOIN ORD o ON o.CustID = c.CustID

    Also, has anybody heard if OUTER JOIN feature will be available in a later service pack/fix or in mssql2008?

    Many thanks. Jeff

  • October 7, 2008 at 4:26 pm

    #882033

    I have assumed you could create views with outer join and use it as your datasource but I could not find docs for it. However I found what you are looking for.

    http://blogs.digineer.com/blogs/markv/archive/2007/05/24/outer-join-functionality-in-ssrs-2005-report-builder.aspx

    Kind regards,
    Gift Peddie

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply