GROUP HEADER FORMULA

[Megs628]

Hi - Crystal Reports 2011 - ODBC connection to Pervasive DB

I've written a production report to list all arrivals and all departure for a specific production date.

The user selects the nominated Production Date and then runs the report.
e.g. Record selector formula

{QUOTE.ARRIVAL_DATE} = {?Production date}
OR
{QUOTE.DEPARTURE_DATE} = {?Production date}


Both the "ARRIVALS" and "DEPARTURES" are grouped via the following formula:-

IF {QUOTE.ARRIVAL_DATE} = {?Production date} THEN "ARRIVALS"
ELSE
IF {QUOTE.DEPARTURE_DATE} = {?Production date} THEN "DEPARTURES"

This works fine with the exception when arrival and departure dates are the same date. i.e. the vehicle is arriving and leaving on the same day

How can I force Crystal to review records and reflect the record in both the arrival and departures grouping?

 

[Charliy]

a record can only be part of one group.
You could do a SQL Command with a Union to create the proper records, or have the main report do Arrivals and s subreport do the Departures.