Please see attached image. I'm having trouble setting second level grouping across multiple fields/columns.
I'm successfully grouping on the facility. However, I need to group (not repeat) the highlighted values.
I'm able to do this be controlling the data to passed in to the report, but the result is just empty cells, so it looks like data is missing.
I need to achieve this through the report designer so the grid cell lines are not repeated for the second level grouping (like it does for the facility)?
How do I achieve this through the designer? Step instructions please?
I'm successfully grouping on the facility. However, I need to group (not repeat) the highlighted values.
I'm able to do this be controlling the data to passed in to the report, but the result is just empty cells, so it looks like data is missing.
I need to achieve this through the report designer so the grid cell lines are not repeated for the second level grouping (like it does for the facility)?
How do I achieve this through the designer? Step instructions please?