Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: Combine groups Post Reply Post New Topic
Author Message
doctork11
Newbie
Newbie
Avatar

Joined: 29 Jul 2013
Location: United States
Online Status: Offline
Posts: 5
Quote doctork11 Replybullet Topic: Combine groups
    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
   

Edited by doctork11 - 28 Jan 2018 at 2:12pm
IP IP Logged
doctork11
Newbie
Newbie
Avatar

Joined: 29 Jul 2013
Location: United States
Online Status: Offline
Posts: 5
Quote doctork11 Replybullet 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.

Edited by doctork11 - 28 Jan 2018 at 2:35pm
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.