Hello, I have a report that needs to "combine" groupings into 1 when a parameter is set to a specific value.

Example:
Level 1 Grouping
   Level 2 Grouping
      Level 3 Grouping
        Details

It may look like:
Store
   Shelf 1
      Bin A
        X Y Z
      Bin B
        X Y Z
   Shelf 2
      Bin A
        X Y Z
      Bin B
        X Y Z

If param1 = STORE then what I want is:

Store
   Bin A
      X Y Z
      X Y Z
   Bin B
      X Y Z
      X Y Z

I want to hide the Shelf - easy, but I also want to COMBINE the bins. See how the param1 = store, shelf is missing, and BIN from Shelf A and B are combined.

When I do this now in my report, I get the shelf hidden, but the BIN's are repeated where the shelf would have been. It looks like: (and I dont want that)

Store
   (space is still here - bad)
      Bin A
        X Y Z
      Bin B
        X Y Z
   (space is still here - bad)
      Bin A
        X Y Z
      Bin B
        X Y Z
   

Edited by doctork11 - 28 Jan 2018 at 2:12pm