Recent content by Hoppkins

I think i have found the problem... Seems we are using Oracle 9.0.1.... and the dmp file was created with 9.0.2. Would this be a problem? Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option JServer Release 9.0.1.1.1 - Production Export file...

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

Got it working using Turkbears method. Thanks very much for all your feedback guys, very interesting indeed :)

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

Awesome thankyou that worked a treat.

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

Thanks, ive tracked down the problem. One of the fields is behaving oddly, before i try and make the formula work i will need to debug this field. Thanks for the reply.

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

Actually you were right, i wasn't using the TOP N function right! Thanks!

When I go there it just has the first columns field as a selectable sort (Title). As so, thanks ! http://i2.photobucket.com/albums/y44/hoppkins/sort3.jpg

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

Awesome thanks that worked a treat!

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

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