Cadette
March 19th, 2004, 07:54 AM
Trying to extract my "codes" from our database. We have a structure where "codes" are columns in each table and inserted as GUIDs. E.g. I have a table called Activity that contains the code ActivityTypeCODE. To get the description of the code I have to perform a JOIN to another table called CodeDescription in which one key is CodeID i.e. the GUID from ActivityTypeCODE. On some machines the desription of the code doesn`t get extracted. When comparing the query from one "working" machine to a "non-working" machine I can see that different queries are sent to the SQL server. The JOIN to the CodeDescription table is missing in the "non-working" machines SQL query. My tables contain several codes, so if I want to extract all codes I have to perform a JOIN to the CodeDescription table for each code, meaning that I end up having a lot of aliases e.g. CodeDescription_1, CodeDescription_2 etc. I am running the run-time version of Crystal Reports 9 (20/2 2004). Please advise!