Recent content by Joy1

Good day Please assist. I'm using crystal reports 2008 and connecting to an oracle database. I'm trying to calculate a duration between 2 dates (date on which call was logged and date on which call was resolved). I need the duration to exclude non- working (04:01 PM - 06:59 AM) hours and...

Hi guys I'm using CR-2008. I've created a report with 2 parameters. One static parameter to display a date range, and a dynamic parameter to display a list of services. The dynamic parameter is not displaying all the values, it only displays one, which is the first on the list. Please help...

Hi I'm using CR-2008. I've created 2 parameters within my report, one static parameter to display a date range and a dynamic parameter to display a list of services offered. My dynamic parameter is not displaying all values - it only returns one which is first on the list. Could i be doing...

Thanks LB for your input. Tried the conditional formulas as adviced - works like a charm - THANK YOU. Joy :-)

Hi guys I'm working on CR9 and connecting to Oracle via ODBC. I've created a report to show an asset list for a specific group. Report fields: DeviceName, DeviceType, SoftwareType & Software. The SoftwareType field contain 3 classifying values (namely: Operating System, Database...

Hi guys PLEASE ASSIST. I'm working on CR9 and connecting to Oracle via ODBC. I've never worked on Citrix before and would like to find out more info on the following: What kind of database does citrix use? Can crystal connect to that database? If so, how? Are there any crystal report...

Thanks guys - much appreciated. Joy :-)

Hi guys I'm working on CR9 and connecting to Oracle via ODBC. Does anyone know if there is a way to get notifications (from Crystal Enterprise) if and when scheduled reports on Crystal Enterprise fail to run. I just want to find out if there is an easier way of doing it rather than manually...

Thanks Madawc Joy :-)

Hi guys I'm working on CR9 and connecting to Oracle via ODBC. Does anyone know if there is a way to get notifications (from Crystal Enterprise) if and when scheduled reports on Crystal Enterprise fail to run. I just want to find out if there is an easier way of doing it rather than manually...

Oh sorry my mistake - the formula actually reads out like this: If {table.To} like "NOC*" and {table.ref} = next ({table.ref}) then DateDiff ("n", {table.xfer_date}, next({table.xfer_date})) Else If {@Xfer To} like "NOC*" and {table.ref} <> next ({table.ref}) then DateDiff ("n"...

Thanks guys buck149: i did try that b4 posting this thread & it didn't work - but thanks for trying. lbass: your formulas work like a charm - thankx a mill. PS: yes the formula has an if statement b4 the calculation. 4 reference here's the actual formula: If {table.To} like "NOC*" and...

Please assist CR9 connecting to Oracle DB via ODBC SAPLE DATA: Ref Open Xfer Close From To Time@NOC I801 I801 02Aug 01Sep 18Oct INLAND NOC1 452 I801 02Aug 05Sep 18Oct NOC1 UNIX 0 I801 02Aug 18Sep 18Oct UNIX NOC2 673 I801 02Aug...

Thanks guys I tried this of Friday and waited to test it on Monday (today) and it sure does work. I changed my DayOfWeek to be based on CurrentDate (instead of log_date) as Brian suggest and then applied the selection criteria as K suggested - works wonders. I even changed my system date to...

K Do u think you can help me figure this one out: The report works just fine until I come to the select expert. Currently the report is based on all records but now I want to filter only those to which the formula applied (i.e. the like "NOC*" groups only). I figured I would use this in my...