1 of 1 people found this helpful
What I did was go inside the console and turn on the Column names inside of the console so when i built reports inside of it I could see what was related to what inside the database. Then when I was inside of crystal reports I could easily make the associations needed. As far as turning on show column names in the console I am positive there is a guide on the forums.
There is an article which mentions switching on the show real database names setting in query designer:
Here are some articles which give advice about creating reports including some database schema information: