Can An Outer Join be done to Link a Sub report?

[cinbh]

I have a situation where I have to link more than 9 tables (Visual FoxPro issue) so to get around this I need to bring in a subreport for the additional tables, but not all the records in the Main report have records that occur on the sub report. We are using Crystal 8.5. When I link the subreport in I don't see an options area on Linking is there a way to do this?
Thank you,
Cindy

 

[lyanch]

You always get all the records in the main report.. and only those in the subreport that match.. in essence an outer join

Lisa

 

[cinbh]

Thanks for the quick response Lisa! My end users really appreciate it also!
Cindy