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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
joins not showing up in SQL
I can't find that field anywhere on the report, the section experts, I even opened the report explorer. I swear, it's nowhere but in the SQL statement. I think I will have to use the command, as you suggested. I just didn't want to have to start over. But, at this point, it should be faster...- JJBorn2
- Post #7
- Forum: Business Objects: Crystal Reports 2 Data Access
-
joins not showing up in SQL
I can't paste it, I would have to re-type it (long story - separate networks, etc.) The gist is this: Select main.field1,main.field2, main.field3 from main inner join vendors on main.id = vendors.id, main inner join serialnos on main.id = serialnos.id and so on I now have 3 versions I am...- JJBorn2
- Post #5
- Forum: Business Objects: Crystal Reports 2 Data Access
-
joins not showing up in SQL
Thanks, but that didn't help.- JJBorn2
- Post #3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
joins not showing up in SQL
Hi, I have a report in CR11 that I had to rework a little because of getting a new computer and configurations being different, etc. One table has changed, and the changes show up when I use 'Verify Database'. I map the changes and that part's OK. The table that has changed links to 12...- JJBorn2
- Thread
- Replies: 7
- Forum: Business Objects: Crystal Reports 2 Data Access
