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: 20 Apr 2024 at 2:10am 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