crystal report

[charvi]

hi
i have 3 tables and linked
first table fields
id
date
second table
masterid
projectid
duration
third table
project id
file no
here id=masterid and table2.projecti d=table3.projec tid .here second table also contains records where projectid is empty.i got the records where project id is present in crystal report.can i also get theremaining records with project id empty in the same crystal report where it is stored in seperate column
is it possible
pls help

[mafaisal]

Hello,

u can Use in Tables Link Options Put Link as Left Outer join then U can Got
All thing even Projectid is empty
then u sort or group by using Projectid,

I think this can help, if no ignore

Faisal

hi
i have 3 tables and linked
first table fields
id
date
second table
masterid
projectid
duration
third table
project id
file no
here id=masterid and table2.projecti d=table3.projec tid .here second table also contains records where projectid is empty.i got the records where project id is present in crystal report.can i also get theremaining records with project id empty in the same crystal report where it is stored in seperate column
is it possible
pls help