Attaching Dependents to Multiple Benefit Plans

[rougex]

Hi all
I am using Reportsmith 3.1 SQL based to extract from ADP Enterprise version 3F

I am attemtping to attach active dependents to individual Benefit Plans (multiple in one report) but having difficulty due to multple outer joins. Has anyone cracked this case, and if so would I be able to see your template or get some advice?

Thank you!

 

[christimess]

Have you tried to add the table multiple times, one for the individual and once for the dependents? Or rather than doing a complex outter join, create what you need in a derived field? I haven't done this for Benefit Plans, but had to do it for other tables and it works pretty well.

 

[ArtieArt]

I know this is from april but if your still having problems, I would do it as a Master Detail where you can conbind multiple reports within one.
Call me if this is still a problem.
678-772-3058. Be glad to help out...

Artie Dunnings
ADTECH Consulting Inc
HRIS Functional & Technical Trainer
Alpharetta, GA