When linking tables (or views or stored procs) in crystal the joins are not enforced automatically. They will become enforced once any field is used from both linked items anywhere in the report (e.g. on the report canvas or in a formula or the select statement, ...) OR if you make them enforced in the crysal linking process.
Go into the Database > Database Expert Links tab
First verify that the correct one-to-one link is being used.
If it is not fix it.
If it appears OK try this test.
remove the view field from your report that is causing the issue.
View the reprot and verify that it appears correcty.
Now go intop the DB expert Open the Link Options and CHange the Enforce Join to Enforce Both and save the change.
View report again. Did it go haywire again? If so then it has to do with the Join not being a 1-1.
Edited by DBlank - 04 Mar 2010 at 7:13am