SSRS 2008 Need to lookup customer name with largest order
- by Chris
Hi,
I'm creating an SSRS report which contains a table of orders, grouped by day.
Now I can easily get the max order value for the day and put it in the group header by using the SSRS MAX() function.
However, I also want to get the corresponding customer name who placed this order, and place this in the group header too.
We can assume my result set simply contains date, name and order value.
Is there any way to do this in SSRS 2008?
Thanks