repco
asked on
Linking Multiple Tables
Hi,
Crystal Reports 11
I have 3 tables
1st table (Orders) has
Order Number, Customer Number, Employee Number, etc.
2nd Table (Employees) has
Employee Number, Name, Address, etc.
3rd Table (Customers) has
Customer Number, Name, Address, etc.
From Databse Expert, I link the (Orders) Customer Number to (Customers) Customer Number and display the Customer name on the Report
I link the (Orders) Employee Number to (Employees) Employee Number and display the Employee name on the Report.
The report will work fine if i only use only 1 of the 2 fields, Employee Name and Customer Name, but will not display both at the same time.
I get error msg. Failed To Retrieve data from Database. Details: 42000:[SoftVelocity Inc][TopSpeed ODBC Driver][Expected lexical element not found: <identifier> [Database Vendor Code: 10015 ]
P.S. I see that the Customer Number from the (Customers) is indexed with a red flag, also the Employee Number (Employees) is also indexed with a red flag.
thanks!!!
Crystal Reports 11
I have 3 tables
1st table (Orders) has
Order Number, Customer Number, Employee Number, etc.
2nd Table (Employees) has
Employee Number, Name, Address, etc.
3rd Table (Customers) has
Customer Number, Name, Address, etc.
From Databse Expert, I link the (Orders) Customer Number to (Customers) Customer Number and display the Customer name on the Report
I link the (Orders) Employee Number to (Employees) Employee Number and display the Employee name on the Report.
The report will work fine if i only use only 1 of the 2 fields, Employee Name and Customer Name, but will not display both at the same time.
I get error msg. Failed To Retrieve data from Database. Details: 42000:[SoftVelocity Inc][TopSpeed ODBC Driver][Expected lexical element not found: <identifier> [Database Vendor Code: 10015 ]
P.S. I see that the Customer Number from the (Customers) is indexed with a red flag, also the Employee Number (Employees) is also indexed with a red flag.
thanks!!!
ASKER
Hi, Thanks for the quick reply but unfortunatly, the Software that is listed there is for Crystal Report 7 and i use CR11. I cannot find that registry key no where.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Pete,
Ok i followed the instructions. The only thing that does not explain well in these instructions is in Step #5
5. Add the correct join syntax for your database. Refer to the required information from step 1.
Example:
OJSyntax
In their example below that, where it completed the final txt file, no where in those lines have OJSyntax stated there.
Example of the TXT file for the registry key update:
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Softwar e\Crystal Decisions\10.0\Crystal Reports\Database\QueryBuil der\JoinBu ilder]
“SQLServerJoinBuilder”=”sq lsrv32”
Where would i put my StarEqual? Or do i have to? I tried just doing it the way the example did it without putting the StarEqual and it still did not work.
thanks!!
Ok i followed the instructions. The only thing that does not explain well in these instructions is in Step #5
5. Add the correct join syntax for your database. Refer to the required information from step 1.
Example:
OJSyntax
In their example below that, where it completed the final txt file, no where in those lines have OJSyntax stated there.
Example of the TXT file for the registry key update:
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Softwar
“SQLServerJoinBuilder”=”sq
Where would i put my StarEqual? Or do i have to? I tried just doing it the way the example did it without putting the StarEqual and it still did not work.
thanks!!
What kind of link did you use?
Can you show the SQL?
mlmcc
Can you show the SQL?
mlmcc
repco
I can see your problem with the instructions.
It is not clear whether you include the line
StarEqual
or not.
I suppose you will have to try both, but I would guess that it is the instruction which is correct and the given example which is wrong.
You will need a different key for CR11.
Based on my machine, the key appears to be:
[HKEY_CURRENT_USER\Softwar e\Business Objects\Suite 11.0\Database\QueryBuilder \JoinBuild er]
but check this on your own machine first.
Obviously you edit the registry at your risk.
Pete
I can see your problem with the instructions.
It is not clear whether you include the line
StarEqual
or not.
I suppose you will have to try both, but I would guess that it is the instruction which is correct and the given example which is wrong.
You will need a different key for CR11.
Based on my machine, the key appears to be:
[HKEY_CURRENT_USER\Softwar
but check this on your own machine first.
Obviously you edit the registry at your risk.
Pete
ASKER
I contacted softvelocity and they did not have an direct answer for me but told me to at least try these 5 entries sent by email. Out of the 5 i tried
[HKEY_CURRENT_USER\Softwar e\Business Objects\Suite 11.0\Crystal Reports\Database\QueryBuil der\JoinBu ilder]
"StarEqualJoinBuilder"="c4 otsx,c4otr x"
As you can see the Crystal Reports documentation states to use StarEqual and not StarEqualJoinBuilder. Apparently the StarEqualJoinBuilder worked!
Thanks very much for your help!!
[HKEY_CURRENT_USER\Softwar
"StarEqualJoinBuilder"="c4
As you can see the Crystal Reports documentation states to use StarEqual and not StarEqualJoinBuilder. Apparently the StarEqualJoinBuilder worked!
Thanks very much for your help!!
Well done.
Pete
Pete
http://www.softvelocity.com/faq/Database_Drivers/107-CrystalTPSODBC.htm
Pete