Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Database Linking 1

Status
Not open for further replies.

zatman

MIS
Nov 6, 2007
2
US
I am trying to do a report in Crystal. I am using ODBC to connect with SQL. I can connect fine. I can see the databases fine. I have four tables to connect. 3 are from one database and the 4th is from another. one of the tables from the 3 has a product number. The fourth table has the Item description. I am pretty ccertain that my linking is correct. But,...when I view the report it does not show the Item description. The heading is there. I am not getting any errors. What am I missing?
I am running Crystal Reports 8.5
 
I believe in Crystal 8.5, you will have to handle the 4th table in a subreport. Crystal 11 allows you to display all fields from both databases.

-lw
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top