Search results for query: *

My company will reimburse class fees up to $2,000/year for any degree from an accredited school and I am looking at on-line MBA degree from Excelsior and WGU. Does anybody have any recommendations for programs where I can take up to 6 years to complete? I know that sounds really slow, but I...

This existing Crystal Report has a parameter option to run based on the time of the last modification of the order. Then all orders last modified during the previous x hours can be displayed. This worked until the modification date details were moved to a separate history table. Now, as before...

Hello, Sometimes it is incovenient to lug a monitor to a windows machine that is having trouble (and the monitor is broken). I don't want to mess with a web of cables to disconnect and reconnect a monitor when working in data centers with tight space, or a monitor may not be available. I have...

Crystal version 11 Developer OLEDB to MS SQL Server 2000 I need some assistance figuring how to complete this report. It was originally created in Excel with two sheets. One showing the rolled up group totals and a second sheet showing all the data/details for each student. I am putting...

Is there available a function to display the database name in the footer of a report? Thanks, Hallux

Hello, I have a long list like this in excel in one column: red red red white white green green white and I would like to reduce the list to red white green white and of course keep the order. Is there a group function that will handle that? Thanks Hallux

Hello, Is there any way I can force a shortcut to maintain a target instead of reverting the previous setting? Details We use an application that sets a shortcut icon on the desktop with a target path of something like "c:\myapp\myapp.exe". Well, for testing purposes, it is required to share...

Hello, Can Backup Exec be setup to back several machines to the backup server disk and then do a single job of copying that group of bkf files to a tape? I would like to end up with a single tape for all my machines that I can send off-site. I expect that capacity-wise the backups of all of...

Windows 2000 server On a single scsi disk array at 100 GB, with an existing 9 GB C: partition, I created a 40 GB G: NTFS partition. It won't properly add the drive letter, e.g. it won't show up in explorer. One thing I thought strange was that the drive letter would show up as a shared folder...

Hello, How can I tell who is logged into a win2000 server? Which management consoles should I use, also, any commands. Thanks, -Hallux

Hello, Yesterday I was asked to take a standalone laptop with 2000 professional and install an application that required a drive letter mapped, let's call it S: to a set of folders on the local c: drive, mimicking a network drive. I set it to share ok, but when I went into the map drive tool...

Hello, Some of the fields of type varchar that are supposed to only have account numbers have alpha characters in them. How do you all go about characterizing the data in a huge table? I want to know minimum/maximum values for numbers, string length, determine if leading or trailing spaces have...

Hello, What is the best method to combine a time and date into one field of type date? Let me explain. These are the two fields in the table: field, datatype, example the_time, varchar2(5),17:54 the_date, date, 01/01/2004 (note that the time portion is always set to midnight, 00:00:00) I...

If there are two rows full of data (Row 1 & 2) and I would like to move it to populate two columns (A & B), is that possible in Excel? I thought there was a feature or maybe copy/paste special, but didn't find it. Thanks, -Hallux

Hello, Looking for help structuring the subquery in a correlated update. UPDATE rainfall SET system = 'METRIC' WHERE (SELECT * FROM rainfall, location WHERE rainfall.city_id = location.city_id AND location.country = 'CANADA') -Hallux

Hello, I need to keep the date numbers and replace instances of {ts '2004-06-01 00:00:00.00'} with a string to_date('2004-06-01','YYYY-MM-DD') to use in database queries. Anybody have any cool one-liners to do the job? Just for fun, any guesses as to the source of the first date string and...

Hello, I noticed that when I insert into details a number field object that I know has a null value, it displays as 0. Shouldn't it display as a blank? Is this expected? Environment: Using Developer 8.5, ODBC driver to Oracle 9. -Hallux

Hello, Where can I find an Crystal Syntax Reference Manual to use while writing formulas. Any help is appreciate. Thanks, -Hallux

Hello, I generally use Crystal, so I'm new to Business Objects. Can somebody point out to me how to see the actual SQL code used by a BO report? In Crystal is is data, show SQL query. I'm using BO 5.1.2. Thanks alot, Hallux

Hello, From a table I have been asked to select the time from an integer field and it contains numbers like "983898064". Anybody ideas? Thanks, -Hallux