ReportSmith Outer Joins

[johnsond2]

I am running ReportSmith 3.10 over an ADP Payroll Oracle DB. I have two tables (PayCheck and PayDeduction) that are linked by seven common fields. Trouble is not everyone who has a Pay Check has Pay Deductions as well, so I need to do an outer join between the tables. However if I do the outer joins in the Table Links area the report grinds to a halt since there are just too many records (years of payroll data) being linked. Is there a way to do an outer join as part of a selection criteria using a SQL statement or formula? If so I can have my other selects go first and then do the outer joins last to cut down on the number of records involved. Any ideas?

Thanks!
DJ

 

[roseygirl]

You should be able to accomplish this by creating a Master/Detail report. Create your Master report first and then you insert the detail below the parent data. I don't do this often because I find it easier to do through Access, but it is supposed to make the report run faster.

 

[dlblack]

Sometimes it is helpful if you can perform a date selection on some of your other linked files this will eliminate some of the records you have to grind through.

David Black, CQA
Teepak, LLC

 

[acurasrx]

You can't do any outer join in Selection Criteria but to minimize slow process try to add a date selection on your criteria since you're accessing a payroll data. Try using all fields that are indexed. You can also use derived fields to get the data you wanted this will eliminate the use of outer joins on the table link.

Hope this helps.

Gary
ADP/Peoplesoft Developer/Administrator