Search results for query: *

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

That worked great! Thanks. Now my issue is when I export to an Excel (data only) file, when I bring it up into Excel all of the blank fields default to 01/01/01, how do I suppress this so the field is blank (it doesn't show up like this on the preview screen)?

Thanks dgillz - the columns didn't line up very well, the software field is the close code name. I am not sure what you mean about inserting a summary for the various dates, could you give me an example?

I am using CR10 and Oracle 9, HPUX os. The database is HP OpenView Service Desk, and I am pulling data from the service call and service call history fields view, and in the history view, each record has every single entry in the history. What is happening is when the data is returned there...

Thanks you so much, it worked like a champ :)

I am using Crystal 10, HP Service Desk running on Oracle. I have a need where I only want to show specified groups in a report and not others, how would I exclude them? I have tried just using the Selection option {V_SERVICECALL.ASSWORKGROUP_NAME} startswith ["Access Request", "Tier 3 Ops...