Hello Everybody,
I am stuck with a porblem on one my reports. The report has two Data Providers, which have the following objects: DP1:
1)TEAM
2)PLAYER
3)1999 SALARY
DP2:
1)PLAYER
2)1998 SALARY
The two Data Providers are linked on Player and there is a Break on Team. When I sum the Salaries for all players in each team, the 1999 Salary sums are correct but the 1998 salary is a total figure of all the salaries of all players in all teams. So the sum of 1998 salary is one same figure for each teams.
However if I add “Team” onto the second Data Provider (DP2), the results are fine but some of the players get eliminated. Logically the two DPs should not be linked on Team, as a Player under one team in 1998 might not be in the same team in 1999.
Any expert help will be highly appreciated. Thank you
Vivek
______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
Listserv Archives (BOB member since 2002-06-25)