I need some help on a report I'm working on. I use CR9 with SQL (Track-It 7.5). As part of the reports I submit monthly I need a count of open tickets for particular ranges (0, 2-5, 6-10, 11-5, 16-20, 21+, Avg and Total). Instead of pulling this on the date I run this report is it possible to be able to have some way to query an aging report based on a particular date? This would allow me to pull the aging report as of the EOM even if I didnt pull it on that date.
The canned report from Track-It I have been trying to work with has the below.
isnull({TASKS.COMPLETED}) or trim(totext({TASKS.COMPLETED})) = ""
if (CurrentDateTime - {@dtOpenDate}) < 10 then 1 else 0
if (CurrentDateTime - {@dtOpenDate}) > 10 then 1 else 0
Any suggestions?
Virginia
The canned report from Track-It I have been trying to work with has the below.
isnull({TASKS.COMPLETED}) or trim(totext({TASKS.COMPLETED})) = ""
if (CurrentDateTime - {@dtOpenDate}) < 10 then 1 else 0
if (CurrentDateTime - {@dtOpenDate}) > 10 then 1 else 0
Any suggestions?
Virginia