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";

}