Recent content by Parkypark

Thanks I will give that a try and let you know

ok here goes we use crystal 9.2.3.970 and connect to remedy via the AR System odbc driver. the hipath connection is via the INFORMIX 3.32 32bit driver we also have another machine wih the sam problem that is running crystal 9.2.0.448 I have an old laptop which runs both connections with no...

Guys, Have managed to connect and run some of my own reports, Woo Hoo, but now having trouble running hipath and remedy reports on the same machine. It used to work, but i think i broke it when i ran a crystal patch. anyone have any ideas. as I now have a machine for each type of reports...

I am trying to connect CR9 to an AR5.5 datasource I get an error when trying to connect it is as follows Logon failed Details: S00:Driver]Cannot open catalog;Message number =9010 please help cheers Richard

is this correct then to add five seconds to the mix if {vect_ansprfle.queuetime} < 5 then 5 else if {vect_ansprfle.queuetime} > 5 and {vect_ansprfle.queuetime} < 10 then 10 else if {vect_ansprfle.queuetime} > 10 and {vect_ansprfle.queuetime} < 20 then 20 else if...

That is amazing my thanks to MColeman You are a star worked first time my own testing was close to that initially but the counts are a dream come true Is there a way to combine 3 different clients onto this report cheers Richard

By the way I could do this in Excel, but thats not the point. cheers and thanks in advance for any help

I am having a bit of a block here I need to write an if then formula (Which is easy, and I can do) but my problem is that there are multiple if thens within 1 perameter eg if {vect_ansprfle.calltypename}='MRC'and {vect_ansprfle.queuetime}> 10 then 0 else 1 this works a treat and i can tell if a...

Help Please We are trying to write a report in CR9 against our remedy database ARS 5. We need to find out the 1st time a call was responded to, and pull this data out and measure it against our sla's The problem is the most obvious field to use is over written when a certain change is made to...

Thanks for the info. I have run stinger on the machine, and found the blaster virus. now removed. I guess i need to run the patch also. I will do. Cheers Richard

I get an error when trying to connect to the internet via dial up then the machine reboots. the error is The remote procedure call RPC services terminated unexpectedly. can anyone shed any light I have been told to reinstal, but I want to see if there is a less drastic way to do it first. Ta.

If you have a value produced by this formula, you should be able to sort lowest to highest you will need to highlight the filed in design view and select the GROUP SORT EXPERT you can then select the grouping to decending or assending hope this is what you need Rich

I am also having trouble with this Trying to connect crystal v 9 pro to an informix database used by our siemens hipath system

Is it possible to get crystal to run a selected report at a given time each day I would like to create a schedule if possible

On a w2k machice the errors can be found in C:\Documents and Settings\All Users\Documents\DrWatson\drwtsn32.log You will need to find the last occuance of the line Application exception occurred: the pid value should then match aruser in the list found further down the log file. hope that...