I am creating a report using lotus notes 6.5 with crystal reports 10. When I link two views using inner join the report works fine but when I link using left outer join I get error message as “Failed to Open Rowset”.
I have posted this error in the crystal reports discussion forum and based on their reply, updated the registry key to add the join syntax of domino database.
The join syntax for domino that we registered is nsql32. But still the same error is returned.
I have pasted the registry file here for yoru reference.
Please advice us on how to solve this issue.
Windows Registry Editor Version 5.00
[HKEY_USERS\S-1-5-21-2025429265-1757981266-725345543-500\Software\Crystal Decisions\10.0\Crystal Reports\Database\QueryBuilder]
[HKEY_USERS\S-1-5-21-2025429265-1757981266-725345543-500\Software\Crystal Decisions\10.0\Crystal Reports\Database\QueryBuilder\JoinBuilder]
@=“nsql32”
“Sql2outerJoin”=“nsql32”