Search results for query: *

I'm almost there!! When I removed the grouping I started getting numbers. Now I just need to get an average number of days open to go with this. Virginia

I tried the below and just came up with zeros in the GF. What am I doing wrong? Virginia Group by {tasks.wo_num} Record Selector {TASKS.STATUS} <> "Completed" Date Paramater {?AgingAsOf} Formulas Aging = 0 if ({?Agingasof} - {@dtOpenDate})= 0 then 1 else 0 Aging = 1-5 if...

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...

BINGO!!! Thank You to both of you!!!

I had another formula in that location so it now reads IsNull ({tasks.COMPLETED}) or {tasks.COMPLETED} = Date (0, 0, 0)and not({tasks.wotype2} in ["Account Request","Conference"]) but the report is still showing the Account Requests and Conferences any other idea?

I'm using Crystal Reports 9/SQL with the Track-It application. The report has only the one group {tasks.wotype2} and it shows them in ascending order. I need to somehow keep the subtypes of "Account Request" and "Conference" from showing in the report at all. What are my options to make this...

That did the trick!!! *doing happy dance* Thanks alot Synaps! Walks =)

CR 9 Enterprise with SQL database I have a report that groups on the requestors name and has all the details of work by that requestor tied to a subreport. The main report is 68 pages long. I'm trying to find a way to use a wildcard so if the user doesnt remember the exact spelling of the...

Thank you very much!!! I checked the Track-It site, after reading this, and it is their issue.

We are using CR 9 Enterprise that came with our Track-It! application, run on a SQL server. I created a reported of all completed WO's by requestor and put a subreport in it. The report views and prints fine through Crystal Reports. When the report is viewed through Track-It! you can view...

Can anyone else help me with this? I need to show all calls M-F after 5pm and before 8am, and all calls on Sat and Sun. I need to factor in the utctolocal so my calls show in my local time. What about and If/Then type thing? I'm grasping at straws here. Ginny

So it's clear what my handle means it is short for Walks On Beach, as in I enjoy walks on beaches. Some have thought it meant walk son o b***h and while 2 years ago it could have that was not it's original or current meaning. I reside in San Diego, CA, USA and love to walk on the beach when I...

That didnt seem to work. The closest I have come is by grouping by month the {tasks.opendate} using (@gmt to local) in the details then filter by technicial and work order type. Using the (@gmt to local) gets me the times in local time. When I use your original suggesion I opened the...

This seemed to work wonderfully! However... I need to put in the utctolocal ({tasks.opendate}) in there somewhere, and being the newbee I am to this I just cant figure that out. Can you help there too? Ginny =)

I am using CR9 with Track-It 6.5 and I need to produce a report that shows certain call types by certain technicians for all non business hours (m-f 5pm-8am and all day sat and sun) Can anyone help? Thanks! Ginny