Hide all group level detail except top group

[debbiepy]

I have a report grouped by Quarter then Division. I only want to see the division group for the most recent quarter but I want to see the quarter group for all quarters.

QTR 3 200,000 GH1
MSD 80,000 GH2
BSD 20,000 GH2
ISD 100,000 GH2
QTR 2 300,000 GH1
QTR 1 150,000 GH1

How do I conditionally hide a group level.

Crystal Reports XI

 

[IdoMillet]

Add a suppress expression to GH2:

RecordNumber > 1

- Ido


view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[debbiepy]

Awesome, it worked. Now, can you explain to me why it worked. I hate doing something and not knowing why. I really don't understand this one and was expecting that it would not work.

 

[debbiepy]

Actually it did not work it is only showing the top group of the division:

QTR 3
MSD
QTR 2
QTR 1

It is not showing ISD, BSD, etc.. for QTR 3

I want it to look like this:

QTR 3
MSD
BSD
ISD
QTR 2
QTR 1

 

[IdoMillet]

If the most recent quarter is the current quarter, set the suppress expression of GH2 to:

DatePart('q', CurrentDate) <> {your_data_quarter}

- Ido



view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[debbiepy]

I figured it out. Our FY starts on 2/1/2007 not 1/1 so I added a parameter field to ask for the current quarter begin and put in suppression for division group section:

Reportdate < CurrentQTRBeginDate

and for my monthly selection I added

month(Reportdate) <> month(today) - 3

The minus 3 gives me 3 days to run previous months report so I do not have to add another parameter field

This worked fine but could not have done it without you. If i have to