Missing Initial Group Heading Records 1

[IceRuby]

Crystal version 11, ODBC to SQL 2000
I have designed a report to display only records on a monthly basis if the summed period in days is greater than or equal to 14. (The user enters report date parameters Date_From and Date_To)

REPORT DESIGN:
GH#1 – Emp_No
GH#2 – Date_From – Sectioned to Monthly
DETAILS Emp_No Date_From Date_To Period_Days
GF#2 SUM PERIOD_DAYS


SECTION EXPERT:
- Suppress Records Formula (listed against all sections (GH#1, GH#2, DETAILS & GF#2)

whileprintingrecords;
Sum ({Period_Days}, Date_From}, "monthly") < 14


ISSUE:
Report does not display first 5 Group header (Employee Number) yet does for all subsequent.

e.g
(GH#2)Jan 2006
(DETAILS) 000034 01/01/06 14/01/06 15.00
(GF#2) 15.00

(GH#2)Feb 2006
(DETAILS) 000117 01/01/06 21/01/06 22.00
(GF#2) 22.00
etc. for first five records

then

(GH#1) 001950 SMITH, NOEL
(GH#2)Feb 2006
(DETAILS) 001950 01/01/06 19/01/06 20.00
(GF#2) 20.00


REPORT SHOULD LIST ALL RECORDS LIKE:
(GH#1) 000034 DOE, JOHN
(GH#2)Jan 2006
(DETAILS) 000034 01/01/06 14/01/06 15.00
(GF#2) 15.00

(GH#1) 000117 BLOGS, DANA
(GH#2)Feb 2006
(DETAILS) 000117 01/01/06 21/01/06 22.00
(GF#2) 22.00

 

[lbass]

I think your GH#1 suppression formula only picks up the first group #2 instance, and if that happens to be less than 15 the GH#1 is suppressed. You can check this by unsuppressing the other sections.

Your samples all show only one record per GH#2 group, and if this is really the case, you could use a different formula for suppressing the GH#1 header:

maximum({Period_Days},{Emp_No}) < 15

-LB