Search results for query: *

Does anyone know how to convert a date TO a week number in excel? Thanks

Hi, I have an excel document - I would like to present the info in the form of graphs - the data is in sheet 1 and I would like the graphs to be in sheet 2 - how do I do this?? Thanks

I hope this is the right forum! Im using Oracle Discoverer (ver 9) and have 2 date fields im trying to subtract from weach other to give the time difference. Does anybofy have any idea on how to do this?? Thanks

Hi, I wonder if anyone can help? I have a HP UPS (r300 xr) and 3 servers (hp Prolient DL380s). I am trying to configure them, in a rack, on a power fail they shut down and restart when the power is restored. The first bit works i.e the servers gracefully shut down. But the two remote agents...

Hi, Im desperatly try to buy a legal copy of visual Basic 6 but can't seem to find it anywhere. Any ideas on places this can still be bought. Thanks P.S I live in England!

Hi, A quick question I cant seem to find the answer to on the web. I have a very small office network - 4 PCs (Well Laptops) and a Network printer. The network printer is not displaying as a device on the network. I gather from reading, this is because its name is not stored against its IP...

Hi, just a very quick one. Ive set up a Xerox Phaser 6100 on a small network - which all works! The only problem I have is naming the printer. At the moment the printer name is \\http://111.111.111.111\Unknown. Can anyone give me a quick overview of where to change this to something...

Hi, I have a large CSV file im trying to open in Excel - to run a few changes on. Basically its a phonebook, all names and numbers are seperated by commas. Some numbers have a '0' prefix, some have a '+' prefix. When this file is opened in Excel the columns are right but the column with the...

I've a strange problem. When opening a document (written on a different PC) Word appears to hang for about 30 seconds then comes back with an error message that reads 'the printer has not yet responded, but the microsoft office program may be able to proceed without printer information. Do you...

Hi, I have 2 sets of data (take from the same original file) that I would like to pair up and compare. The format of the 2 datasets are 1 identifier number and a details field. Every line has an identifier, unique for each dataset i.e. won't appear again in the dataset but may appear in the...

I have weird problem in that when I export my report to Excel the last 3 columns of the report get moved to be the first 3. Has anyone seen this before? My report does have 19 columns, using CR 8.5 and Excel 2000. Thanks.

Has anyone successfully installed Oracle 7 server onto a windows 2000 server box? Thanks.

I have the following code in one of my formula fields StringVar KeyValue ; StringVar FirstChar ; StringVar SecChar ; StringVar ThirdChar; StringVar FourthChar ; If {Product.Itemkey} <> [354,190,532,430] then KeyValue := {@KeyValue}; The idea of this code is to generate a code...

Just seen crystal reports v9 for the first time today, only for a matter of minutes unfortunately. I was somewhat concerned with my inability to connect to an Oracle database?! I've noticed there appears to be no way of connecting to an oracle server via the 'More Data Sources', as in versions...

I have a query on ISDN bundling and NT - Is it possible? we have 2 machines (one NT4 and one 2000) the windows 2000 server bundles the ISDN lines but the NT PC does not. all settings seem to be OK. Any ideas, thanks.

Our address's are stored in the database as one field with each line of the address signified by a ¨€ (I think its the visual character for line feed in ASCI (I could also be talking rubbish but its something to-do with line feed)). Addresses are generally 4 lines. E.g. an address would look...

I have a report that works out how long a procedure took (simply by subtracting the end date from the start date. I need crystal to show me the occasions where this time was the longest the shortest and what the average time was. I've got it to display either the max or min by grouping and...

I have the following formula, that displays the category if the product does not equal one of 4 Productkeys (354,190,532,430), otherwise it generates a 4 character code by applying a set of rules to the sale, here is the formula : StringVar Korner := If {DATAPROD.REFPRODKEY} <>...

Our report needs to display all data with &quot; , to define the stop and start of a field. ie. within the database the field may be stored as 123456 but I need to have crystal display it as &quot;123456&quot;. I've tried using formula fields but not sure how to enter this, as crystal uses the...

I'm currently developing CRs using CR ver 8.5, our customer has version 9. We’re due to go live next Monday and I’ve just had this sprung on me. Are there any known issues with running reports created in CR 8.5 on CR 9? The reports are nothing special i.e. no SQL procedures, Dictionaries...