Thanks for the information my friend....the truth is, we are still waiting for the acquisition of a Crystal Report Environment for such reports, but in the meantime we wanted to allow for some level of monitoring via the SD Client.
Alternatively, I can always do a mass export of SCs and use a spreadsheet to filter out what I need but didn't want the extra hassle.
If find it hard to imagine why HP would allow Actual Duration as a filter and not Open Duration...but anyway...
Just out of Curiosity, do you know of any FREE Reporting Software that can be used with Service Desk?
The reason that open duration is not available as a filter is that it is a derived value. It does not exist in the database. Open duration is a database attribute. Open duration is calculated as the record is displayed (now - Open time). (that is why it is hard to add it as a data value - when is this dtermined - last time the rcord was saved - that may have been 2 days ago!) One thing you can do is highlight on Open duration. Note to do this the open duration field must be a "column" on the table view.
Alternatively you could filter where registraion:created is greater than 1 day ago. Of course this will not take into account service time.