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…