Left Outer Joins - Crystal 10

[PauloMongo]

I have created a report in 8.5 and upgraded this to a version 10 report. I have tables that are joined by a left outer join. These reports worked previously after applying a SQL92 patch that I was sent from crystal for V8.5. After upgrading the report I am getting the following error message.

Failed to open Rowset - Details 42000[Datadirect - Technologies][ODBC PROGRESS driver][PROGRESS]Syntax Error(7587).

looked on the web and it mentions messing with the registry, has anybody any other suggestions?

Thanks

 

[crogers111]

I am having the same issue and am still searching for a solution. I updated a CR 8.5 report to CR 10. The report has LOJs, a few subreports and prompts for a parameter (user id) I am using OLE DB connection..SQL SErver 2000. After adding any new table and attempting to run the report: 'Failed to return Rowset error'

followed by: 'Query Engine Error: If tables are already linked then join type cannot change'

I found the cr9_left_outer_join.pdf and am guessing this is the problem but it does not show the registry path for cr10 and I don't want to 'guess' with the registry.

anybody resolve this ?

 

[PauloMongo]

I finally got my problem resolved for connection to a progress database. Follow the Left Outer Join paper from Seagate, find the correct join method and dll name that you are using.

copy the below into a text file.

---------------------------------------------------------

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Crystal Decisions\10.0\Crystal Reports\Database\QueryBuilder\JoinBuilder]


"DB2JoinBuilder"="PGPRO918"
"OracleJoinBuilder"="PGPRO918"

---------------------------------------------------------

Change the join type to your Sequal settings and save file out as .reg file. run the file and it will create the necessary entries in the registry for you.


Thanks,


Paul

 

[thomasc72]

how did you find out what to use for the join method?
ie "pgpr0918"...where did you get that?

 

[PauloMongo]

I used the following white paper that details the join types. The same is used for CR10.

Hope this helps.

http://support.businessobjects.com/communityCS/TechnicalPapers/cr9_left_outer_join.pdf