Print Page | Close Window

Combine groups

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22531
Printed Date: 13 Aug 2020 at 3:41pm


Topic: Combine groups
Posted By: doctork11
Subject: Combine groups
Date Posted: 28 Jan 2018 at 2:11pm
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
   



Replies:
Posted By: doctork11
Date Posted: 28 Jan 2018 at 2:34pm
Never mind. I just needed to eat dinner and it all made sense. It was a simple if command = X then true else false ... or then false else true in the suppress formula in Selection Export. This was added to all groupings.



Print Page | Close Window