Hi,
Is there a way to create a conditional LOJ? I know the joins reside in Visual Linking. I have the following parent / child relationship and want all parent records but don't want all the children records (only those with Fieldb = '2') Ex.
P.Fielda C.Fielda C.Fieldb
REC1 REC1 1
REC1 2
REC1 3
REC2 REC2 1
REC3 REC3 2
REC4 REC4 1
REC4 REC4 2
desired outcome
REC1
REC2
REC3
REC4
If I add Fieldb='2' into the Record Selection then desired records are omitted. If I perform a LOJ on the key field then I get repeated records(the nature of LOJ). I can accomplish this via sql but want to try keeping everything in Crystal. After writing this I suppose I could create a subreport for the field.
sql: LEFT OUTER JOIN child ON
parent.fielda = child.fielda AND
child.fieldb = 2
provides the 3 records above.
Thanks in advance
Is there a way to create a conditional LOJ? I know the joins reside in Visual Linking. I have the following parent / child relationship and want all parent records but don't want all the children records (only those with Fieldb = '2') Ex.
P.Fielda C.Fielda C.Fieldb
REC1 REC1 1
REC1 2
REC1 3
REC2 REC2 1
REC3 REC3 2
REC4 REC4 1
REC4 REC4 2
desired outcome
REC1
REC2
REC3
REC4
If I add Fieldb='2' into the Record Selection then desired records are omitted. If I perform a LOJ on the key field then I get repeated records(the nature of LOJ). I can accomplish this via sql but want to try keeping everything in Crystal. After writing this I suppose I could create a subreport for the field.
sql: LEFT OUTER JOIN child ON
parent.fielda = child.fielda AND
child.fieldb = 2
provides the 3 records above.
Thanks in advance