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 biv343 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: Hoppkins
  • Content: Threads
  • Order by date
  1. Hoppkins

    Importing DMP file to Oracle9i

    Hi, I have a dmp file to import into Oracle 9i. I have created the tablespace and user and assigned all needed privilages. However i'm coming a bit unstuck at the import utility. I've used the Oracle8i imp utility from a batch file before but this same process does not seem to work. This is...
  2. Hoppkins

    Formula with 4 fields sorrow

    I have a formula where it will have 4 fields and depending on which fields have data it will print semi colons between them. E.g. Field 1 ; Field 2 ; Field 3 ; Field 4 But if field 4 was blank it would appear as Field 1 ; Field 2 ; Field 3 And if field 2 were blank: Field 1 ; Field 3 ...
  3. Hoppkins

    Date comparison formula

    I have to create a formula to compare 2 dates. The fields are date/time created and date/time completed. I need to count how many things were completed more than 5 days after they were created. Without involving the time part how could this be done? FOr previous functions on this report ive...
  4. Hoppkins

    Formula to print one of 3 fields

    I have 3 fields called "Author", "Corp Author" and "Conference". I'm trying to make a formula where if Author is populated it will print that. If it's not it will check Corp Author and if thats populated print that, if thats blank then print conference. I'm using the formula from a working...
  5. Hoppkins

    Sorting on a column in a cross tab

    I have a field in a cross tab which is the summary total of another field, i want to sort on this field but cannot see how. Basically the field just outputs a word and the summary counts how many occurances of the word there are and presents it as a number. See pic below to see how it appears...
  6. Hoppkins

    Converting date/time to date in Crystal 8.5

    Hi. I have 2 fields i want to perform a comparison on. The fields are date/time created and date completed. I want the report to suppress any values where: date/time created = date completed. The problem is they will never equal as one field is in the format: 01/01/2000 13:27:02 and the...
  7. Hoppkins

    Oracle 8i and Windows 2003 compatibility?

    Hi, I've been looking for a report or document that will indicate if Oracle 8i is compatible with Windows 2003 Server. So far all I have found are whitesheets and documents on Oracle 9i. Can anyone shed any light or point me toward a document please? Many thanks

Part and Inventory Search

Back
Top