I have data structured like: Tree 1 Tree 4 Tree 3 Grass 1 Grass 1 Tree 1 Tree 5 where there are 2 columns. I'd like to group these in a table that expands and collapses by the first column, but have the sorting stay. So, I want it to group like this: Tree 1, 4, 3 Grass 1, 1 Tree 1, 5 I can think of two ways this could be done. Either create another column that differentiates the two groups of Tree rows and group by that column making it not visible (been unable to get this to work) or Have a group value for the group, but have a different display value. I haven't seen anyway to do this with values from query. With a parameter you can have a Value and a Display Value, but I haven't found a way to do the same with groupings (group by one column, but display the value of a different column) Are either of these solutions possible or is there a better way to do this?

I have made a little progress with this. Even with an expand/collapse grouping, you can use an expression that will display a field from the grouping. The trick seems to be to first sort the items in the grouping as you would want them and then using the expression: =First(Fields!FieldName.Value, "GroupName") The grouping will still group off of the field you set the grouping to, but will display a different value. I thought I'd post this since others might have a similar issue.