hide header/foot when details are blank

[RCAIVANO69]

using CR 8.5

GH1 (patient_id)sorted by service date

using the following suppression to only show exams repeated within a specific interval

(
(
onfirstrecord or
{PATIENT_IDENTIFIERS.IDENTIFIER} <> previous({PATIENT_IDENTIFIERS.IDENTIFIER}) and
{PATIENT_IDENTIFIERS.IDENTIFIER} = next({PATIENT_IDENTIFIERS.IDENTIFIER})
) and
datediff("d", {EXAMS.SERVICE_DT},next({EXAMS.SERVICE_DT})) > {?Interval}
) or
(
{PATIENT_IDENTIFIERS.IDENTIFIER} = previous({PATIENT_IDENTIFIERS.IDENTIFIER}) and
{PATIENT_IDENTIFIERS.IDENTIFIER} = next({PATIENT_IDENTIFIERS.IDENTIFIER}) and
datediff("d", PREVIOUS({EXAMS.SERVICE_DT}),{EXAMS.SERVICE_DT}) > {?Interval} and
datediff("d", {EXAMS.SERVICE_DT},next({EXAMS.SERVICE_DT})) > {?Interval}
) or
(
(
onlastrecord or
{PATIENT_IDENTIFIERS.IDENTIFIER} <> next({PATIENT_IDENTIFIERS.IDENTIFIER})
) and
{PATIENT_IDENTIFIERS.IDENTIFIER} = previous({PATIENT_IDENTIFIERS.IDENTIFIER}) and
datediff("d", PREVIOUS({EXAMS.SERVICE_DT}),{EXAMS.SERVICE_DT}) > {?Interval}
)


However, there are numerous entries where the header and footer is visible but there are no detail entries

how can i hide if detail section empty

 

[IanWaterman]

The only way you can do that is to try to develop your above formula for Groups (rather than details)and then do the Reverse in Group selection.
ie Report will only show Groups that do not meet the above suppression rules.

Ian

 

[dgillz]

Why are you suppressing rather than excluding the records from the report entire with a record selection formula? If you exclude the records, the group header/footer will not be generated.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[RCAIVANO69]

I need to fetch all the records included but only want them to show if the procedures are within "x" number of days of each other