Recent content by cathey04

That's what I thought - any ideas?

This is the formula for the NCR Priority (there are duplicates). The vendor must resolve 90% of the calls in 10 hours and 100% of the calls in 24 hours for severity one calls. And for severity 2 you can see the time. Maybe a rewrite of both formulas but I am not sure where to start. If...

I tried that but I get an error looking for a then after the <= 6.00) even though the next parameter is then

Try setting up a new ODBC Data Soure Connection and use the CR Oracle ODBC Driver 4.10 instead of the Oracle Driver. If you have the CR Oracle ODBC Driver 4.20 don't use this just use the 4.10.

I am using CR 10, HP Service Desk, Oracle 9, HPUX. We have several priorities and each priority has a time to be resolved in SLA. There are two priorites that have two different SLA's, severity 1 & 2. The trouble I am having is that the second SLA for each severity 1 & 2 doesn't work, so I...

This is from thread 767-1408240 and it was resolved by adding a summary for each Time/Date field using maximum to get the oldest entry. My question now is how do I get minimum for the first Time/Date entry? Thanks **************************** I am using CR10 and Oracle 9, HPUX os. The database...

I replaced all the formula "like" for "in" and it cut the time down by two hours. Thank you so much!

I will try subsituting "in" for "like" and give it a shot. Thanks for your help!

Here is a sample from the History Table from one Service Call - my formula is trying to determine if the call was routed to Tier 3 AppSupport (there are over 150 workgroups starting with Tier 3 AppSupport)after being sent to other groups by mistake. I don't have the code tables, although my DBA...

Thanks LBass, I don't understand what you mean in the last line. Is this in the formulas or selection criteria? Also in the formulas I used an asterick in some, but I am not sure if I used it correctly or if there are other wildcards available. Any help would be appreciate big time!

I will give this a try, and I can't believe I didn't try this before - I will let you know if it helps, Thanks

I am using CR10, HPUX, OpenView Service Desk on Oracle 9. I have written a CR tracking Service Calls and Incidents handled by our contractor for Support Serices using Views and Tables/Fields. The History table below has gobs and gobs of data in each record. I have written three formulas to...

It worked like a charm! Thank you so much!!!

I had some help earlier this month on this particular report and thought the export was fixed but it isn't. After many trial and error formulas, ODBC drivers, and different exports in Crystal, and wasting tons of time, I am hoping someone can help me out. I am using CR 10, Oracle DB, HPUX...

You two are my new heros, thank you so much for your help! Both suggestions worked beautifully!!!!