Relations use Inner Joins

[jamesk]

It appears that the Relation component uses an Inner Join rather than a Left or Right Join. Is it possible to select what type of Join is used, so that when I create the relation, then I can select which type of relationship it is?

I'll give you an example of what I am working with.

I have a WorkOrders table and WorkOrderServices table. It is possible to create a WorkOrder record and have any number of WorkOrderService records linked to that WorkOrder record. You can even have a WorkOrder without any WorkOrderService records.

I am trying to display All Open WorkOrders, regardless of whether they have services or not. Currently the report I created is showing only open Work Orders that have Services assigned to them. This is because I created two datasources and one relation and then I have the Master component of one band pointing to the other band.

How does one create a Master-Detail record that shows all the Master records regardless if they have Detail records or not?

Thanks

[Brendan]

I believe you need to set the Print If Detail Empty property on the WorkOrder Databand to True.
This will print all Work Order rows where they have a Service related to it or not.

[Vital]

Brendan give you right answer. Please set Print If Detail Empty to true.

Thank you.

[jamesk]

Thanks Brendan and Vital.

That did exactly what I needed. This product is so cool!