Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Joy1
  • Content: Threads
  • Order by date
  1. Joy1

    Duration field to reflect as HH:MM:SS

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

    Parameter not displaying all values

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

    Spliting a report field into an array

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

    Citrix 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...
  5. Joy1

    Scheduling reports on Crystal Enterprise

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

    Scheduling reports on Crystal Enterprise

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

    Sum of a formula field

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

    Formula based on day value

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

    Formula based on the last record within a group

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

    TopN Grouping

    I'm using CR9 and have created a report based on the services.I did a topN grouping based on my top 5 services and grouped the rest as Other. I then created a cross-tab per group as well as a graph based on the cross-tab.The top 5 services show accordingly with their graphs but Other does not...

Part and Inventory Search

Back
Top