Hi,
I would like to do the simplified example report below and can't quite get the grouping right to do what I want.
My table looks like:
Employee X .5 January Employee X .6 February Employee X .7 March Employee Y .5 January Employee Y 1.0 March
I want my report to display:
January February March Employee X .5 .6 .7 Employee Y .5 1.0
My current report is grouped in the Detail section, and uses iif to display:
January February March Employee X .5 Employee X .6 Employee X .7 Employee Y .5 Employee Y 1.0
Or I tried to group on employee name but it will only show one of the records, i.e.:
January February March Employee X .5 Employee Y .5
So my question is how do I using the grouping to only list each employee once, while also displaying the multiple records?
Thanks!