Search results for query: *

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

Good day Please assist: CR9 and oracle database I've created a report (based on calls logged) and want to run it daily (Mon to Friday only) for the previous day's data. I've used this formula to determine day of week: DayOfWeek ({tablename.log_date}) and this formula (@Logged) to try and...

Thanks K u r a * It works - I only had to remove "next" in the last line of the formula coz in this case NOC will be the last record in the line of each respective group, thus there's no next close date for that particular group. If {table.xferto} like "NOC*" and...

In addition to the formula that you suggested, i want to still see values for if NOC was the last group to which the call was transfered. In such a case, i want to see the datediff between the transfer date and the close date. I hope this makes sense.

Thanks K Apologies for being vague in trying to explain myself. Let me try again: Im working on CR9 and connecting to the Oracle database. Requirement: to calculate how much time did the call spend within the NOC groups. Yes [b]I103 and [b]I104 are my group values and yes I meant to...

Hi Please assist if you can. Below is the sample data of the report I'm working on: RefNum Logged XferDate Closed XferFrom XferTo @NOC [b]I103 I103 05/09/06 05/09/06 22/12/06 FBS GX SAP I103 05/09/06 05/09/06 22/12/06 GX SAP Connect I103 05/09/06 08/09/06...