I have a recordset displaying the following that i am using in crystal:
ID Week Wins Difference name
1 1 1 2 jason
1 1 1 5 john
1 1 0 24 jay
I am grouping on the id and then the week. The report looks perfect for what i want to do, except that i only want to show the winner (in this case it is jason).
How can i do this?
Sometimes their may be a tie.
ID Week Wins Difference name
1 1 1 2 jason
1 1 1 2 john
and i need to show the two who tied.
is this possible?
cr 8.5
sql server 2000
ID Week Wins Difference name
1 1 1 2 jason
1 1 1 5 john
1 1 0 24 jay
I am grouping on the id and then the week. The report looks perfect for what i want to do, except that i only want to show the winner (in this case it is jason).
How can i do this?
Sometimes their may be a tie.
ID Week Wins Difference name
1 1 1 2 jason
1 1 1 2 john
and i need to show the two who tied.
is this possible?
cr 8.5
sql server 2000