I
I''ve a feeling I''m not in Unix Anymore
My report groups on 3 fields: name, procedure, date. These fields are all in
the page header followed by a detail section containing various additional
data associated with the header field combination. I have all 3 header
fields set to "keep together: whole group." Most of the time, a new page
starts after the last detail record that is associated with its corresponding
header. (I don't have any manual page breaks in the report.) Sometimes I
have a name, procedure and date in the database where all of the detail
fields are empty. In this case, I want to print a separate page showing this
header information. I don't care whether a blank detail record is printed or
not. Right now, if there is no associated detail, the date field and a blank
detail line print in the detail section under the previous
Name-Procedure-Date header. If I have 2 records in a row with empty details,
the date fields and blank details for both print under the detail section for
the last record that did have data. Can anyone help? TIA.
Example -- assuming there are no detail records for the second set of header
fields:
What I want:
Name1
Procedure1
Date1
Detail1
[New Page]
Name2
Procedure2
Date 2
[New Page]
Name3
Procedure3
Date3
Detail3
What I'm getting now:
Name1
Procedure1
Date1
Detail1
Date2
Detail2 (blank line)
[New Page]
Name3
Procedure3
Date3
Detail3
the page header followed by a detail section containing various additional
data associated with the header field combination. I have all 3 header
fields set to "keep together: whole group." Most of the time, a new page
starts after the last detail record that is associated with its corresponding
header. (I don't have any manual page breaks in the report.) Sometimes I
have a name, procedure and date in the database where all of the detail
fields are empty. In this case, I want to print a separate page showing this
header information. I don't care whether a blank detail record is printed or
not. Right now, if there is no associated detail, the date field and a blank
detail line print in the detail section under the previous
Name-Procedure-Date header. If I have 2 records in a row with empty details,
the date fields and blank details for both print under the detail section for
the last record that did have data. Can anyone help? TIA.
Example -- assuming there are no detail records for the second set of header
fields:
What I want:
Name1
Procedure1
Date1
Detail1
[New Page]
Name2
Procedure2
Date 2
[New Page]
Name3
Procedure3
Date3
Detail3
What I'm getting now:
Name1
Procedure1
Date1
Detail1
Date2
Detail2 (blank line)
[New Page]
Name3
Procedure3
Date3
Detail3