Duplicate resources in crystal report

[rkrishna]

Hi all,

We have MSP 2003 with all the SPs installed. We are quering the
backend SQL db and create reports using Crystal Reports.

The enterprise resource pool as seen in the MSP client and the PWA is
looking fine however when we query the SQL db we are seeing duplicates
for some of the resources (not all). Can someone help?

Thanks

 

[rkrishna]

Hi all,

We have MSP 2003 with all the SPs installed. We are quering the
backend SQL db and create reports using Crystal Reports.

The enterprise resource pool as seen in the MSP client and the PWA is
looking fine however when we query the SQL db we are seeing duplicates
for some of the resources (not all). Can someone help?

Thanks

I should add that we are two people sitting in two different location
using the same admin username. Could this be a problem? Thanks.

 

[James Fraser]

I should add that we are two people sitting in two different location
using the same admin username. Could this be a problem? Thanks.

The problem is probably in your query: if you do a select straight
from the resource table where Proj_ID = 1 (no joins), do you see the
duplicates?


James Fraser