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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: crystallearner
- Content: Threads
- Order by date
-
Crystal 11 and Gupta doesn't allow more than one outer join
Hi, I have been trying to join 3 tables together with an outer join from table 1 to table 2 and then another outer join from table 2 to table 3. When I try and run the report I get an error "Failed to retrieve data from the database" Followed by: "Failed to retrieve data from the database...- crystallearner
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 2 Data Access
-
join a number in a string field to a database field
Table 1 has name(string), timeslot(number) fields Table 2 has schema a string field that contains 96 ASCII characters Table 3 has ID(number), Description(string) the result of: asc(mid({table2.schema}, {table1.timeslot}+1, 1)) gives me the ID number for table 3 I am trying to report name and...- crystallearner
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 4 Other topics
