October 7, 2008 at 2:17 pm
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
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.
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