How to set Left outer Join as default in Crystal Report 8.5

[elangesk]

Hai All...

I want the details about set Left Outer Join as Crystal Report's Default Join in crystal report 8.5. Any one Know about it, make slove my thread.

Thanx a lot....

 

[TheBlondOne]

As far as i'm aware there is no setting to default the join type to Left Outer, it is defaulted to equal because in the majority of cases you only want to report on information where there is a match in id's, where as a LO will give you a different set of results.

 

[Madawc]

If you're using a particular left-outer link a lot, make a model report with this relationship already set. Use 'Save As' to create each new report from this model report.

I did this for both Crystal 8.5 and Crystal 10. We take daily, weekly and monthly copies of the mainframe database, and records are 'date stamped' so that we can check out old values as well as current values. This means that most reports begin with the load-control record and I defined a model report with that already set up.

Madawc Williams (East Anglia, UK)