Print Page | Close Window

Crystal Reports hide certain groups

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9297
Printed Date: 02 May 2024 at 1:48pm


Topic: Crystal Reports hide certain groups
Posted By: bikuta
Subject: Crystal Reports hide certain groups
Date Posted: 04 Mar 2010 at 4:13pm

Hi there,

I'm trying to build a Crystal Report and this is what it looks like (for one of the groups):

GH1
  – Customer
GH2
  – today
  Details
   – record 1
   – record 2
GF2
GH2
  – yesterday
  Details
   – record 3
   – record 4
GF2
GF1

As you can see this group have two subgroups under it.
What I'm trying to do is, to suppress the Customer group if it does not have 2 subgroups, i.e., it would only records either in the today subgroup or the yesterday subgroup, but not both.

Any ideas how I can do this in Crystal?
I'm using Crystal 10.


Replies:
Posted By: DBlank
Date Posted: 05 Mar 2010 at 7:29am

I assume you are filtering so only pull records for the last 2 days. I also assume your G2 is on a date field set for 'daily'.

Do a dinstinctcount on the datefield used for G2 changing at G1.
YOu can now conditioanlly suppress your sections when that SUmmary is <>2


Print Page | Close Window