Mike Moxcey 1999 next

Report Logic

if ($call_type eq "closed") {
$get_call="where close_date is not null";
$prn_type="Closed Calls";
}elsif ($call_type eq "date_rng") {
$get_call="where open_date between
to_date('$beg_date','DD-MON-YYYY')
and to_date('$end_date','DD-MON-YYYY') ";
$prn_type="Calls Opened between
dates $beg_date and $end_date";
} else {
$get_call="where close_date is null";
$prn_type="Open Calls";
}


home next