Pulling data from Peoplesoft 8 1

[bdjb]

Hello All,
I'm trying to pull data from Peoplesoft using Crystal 8.5, and am having quite a few problems. Does anyone know of any crystal examples or online training?

Thanks!

What happens if you get scared half to death twice?

Bob

 

[Turkbear]

Hi, What kind of problems?
What Connection type and driver are you using?


Pulling data from a database ( as long as you can connect to that database) is the same for most database systems, so a more expansive description of your errors ( and what you were doing) would be useful.

 

[bdjb]

Hi Turkbear,
I'm connecting directly to the HRMS database on Oracle, through ODBC. The problem is getting duplicate records. I've linked the EMployee table and an Org Report table using an equal join. When I put employee names on the the report, I get quite a few duplicates of each. I use a criteria of a specific manager level.

Thanks again,
Bob

What happens if you get scared half to death twice?

Bob

 

[Turkbear]

Hi,
Any join will return 1 record for each and every matching record of the right-most table in the link ( if a one to many relationship exists), so it will return the same name for each matching record in Org
( assuming a EmployeeTable -> OrgTable link)

Try grouping on the employee name...

 

[bdjb]

Hi Turkbear,
Thanks for the help, grouping on employee name fixed the issue. Sometime the answer is just too obvious to see!.

Thanks again!

What happens if you get scared half to death twice?

Bob