I have created a report that uses a date range parameter I'll call it ?fromdate and ?todate. I want to create a report that will return the most recent input to a field I'll call "Status" which uses a timestamp field which I will call "Creation_Date". I would like to report on the last time this "Creation_Date" was updated within the date range request. I want the report to print only the records with a "Creation_Date" that was added more than seven days ago. I have been able to create and run a report that includes all "Creation_dates" that are not within the last seven days, but unfortunatly this also returns status that are within the requested date range and only the "creation_Dates that are not in last seven days.
{@DateRange} and
(if {?Group_ID} <> "" then
{@TSGRP} = UpperCase({?Group_ID})
else
{@TSGRP} >= UpperCase({?Group_ID})) and
(if {?Call_Status} <> "" then
{@status} = UpperCase({?Call_Status})
else
{@status} >= UpperCase({?Call_Status})) and
(if {?Operator_ID} <> "" then
{@TSOPER} = UpperCase({?Operator_ID})
else
{@TSOPER} >= UpperCase({?Operator_ID})) and
not ({@CreDate} in Last7Days)
I hope that I was able to explain this correctly, If not I sure someone will lte me know.
Thanks
Kenny
{@DateRange} and
(if {?Group_ID} <> "" then
{@TSGRP} = UpperCase({?Group_ID})
else
{@TSGRP} >= UpperCase({?Group_ID})) and
(if {?Call_Status} <> "" then
{@status} = UpperCase({?Call_Status})
else
{@status} >= UpperCase({?Call_Status})) and
(if {?Operator_ID} <> "" then
{@TSOPER} = UpperCase({?Operator_ID})
else
{@TSOPER} >= UpperCase({?Operator_ID})) and
not ({@CreDate} in Last7Days)
I hope that I was able to explain this correctly, If not I sure someone will lte me know.
Thanks
Kenny