Hello. I am using Crystal Reports Professional Edition 9.0
I am currently trying to link 3 views: An Employee view with two code description views. I want the Employees to appear on my report regardless of whether the codes on the Employee table have an entry on the respective description views. The views are linked first by Company Code, then by the respective code (ie. Employee view is linked with the Job Description view by Company Code, then Job Code and the Employee view is linked with the Hire Source Description view by Company Code and Hire Source Code). I tried using the Left Outer Joins, but I get an error message stating “Failed to open row set” then I get the message “Failed to open a rowset. Details:HY000:[MERANT][ODBC SQLBase driver][SQLBase]01410 DLU OOJ Only one outer join table allowed”
After doing some research, and getting nowhere, I decided to try using a subreport for the Job Description. I linked the Employee view with the Job Description table using the left outer join with the fields Company Code and Job Code. My report is now showing the employee I wish to see, however, I’ve taken a serious blow to speed with this method. There are only 350 employees in the Employee view but the report took 4 minutes to refresh itself to display 82 of the records (I also have selection criteria in this report). This is not a viable solutions for some of our clients with employee counts in the tens of thousands. Note: Both the primary report and subreport are sorted by Employee Name, Company Code, then Employee File#.
After spending a day at this website sifting through issues that others have posted, I’ve developed the following impressions, right or wrong:
1. Multiple left outer joins are possible sometimes depending upon the database and the drivers and the version of Crystal.
2. When multiple outer joins are not possible, subreports are developed.
3. When speed is an issue, views (newly created or modified) are preferred to the subreports.
Is this correct?
Background Information:
My company is considering using Crystal Reports in addition to SRS’s ReportSmith. I’m trying to redo the reports in Crystal that were originally written in ReportSmith. ReportSmith had a feature called “Translate”, whereby it somehow knows how to change the codes into their descriptions using a Decode function. This is actually what I was trying to get at when redoing this particular report.
I am currently trying to link 3 views: An Employee view with two code description views. I want the Employees to appear on my report regardless of whether the codes on the Employee table have an entry on the respective description views. The views are linked first by Company Code, then by the respective code (ie. Employee view is linked with the Job Description view by Company Code, then Job Code and the Employee view is linked with the Hire Source Description view by Company Code and Hire Source Code). I tried using the Left Outer Joins, but I get an error message stating “Failed to open row set” then I get the message “Failed to open a rowset. Details:HY000:[MERANT][ODBC SQLBase driver][SQLBase]01410 DLU OOJ Only one outer join table allowed”
After doing some research, and getting nowhere, I decided to try using a subreport for the Job Description. I linked the Employee view with the Job Description table using the left outer join with the fields Company Code and Job Code. My report is now showing the employee I wish to see, however, I’ve taken a serious blow to speed with this method. There are only 350 employees in the Employee view but the report took 4 minutes to refresh itself to display 82 of the records (I also have selection criteria in this report). This is not a viable solutions for some of our clients with employee counts in the tens of thousands. Note: Both the primary report and subreport are sorted by Employee Name, Company Code, then Employee File#.
After spending a day at this website sifting through issues that others have posted, I’ve developed the following impressions, right or wrong:
1. Multiple left outer joins are possible sometimes depending upon the database and the drivers and the version of Crystal.
2. When multiple outer joins are not possible, subreports are developed.
3. When speed is an issue, views (newly created or modified) are preferred to the subreports.
Is this correct?
Background Information:
My company is considering using Crystal Reports in addition to SRS’s ReportSmith. I’m trying to redo the reports in Crystal that were originally written in ReportSmith. ReportSmith had a feature called “Translate”, whereby it somehow knows how to change the codes into their descriptions using a Decode function. This is actually what I was trying to get at when redoing this particular report.