Search results for query: *

Ok, I have a report that needs to pull the terminated employees for the last week from the SQL database. I can pull ALL the terminated employees, but I only need it to show from todays date and the previous 7 days (this report is scheduled to run every Fri) data. Without using parameters, how...

I performed a restore from a full backup and now the database says it's loading and it greyed out instead of yellow (SQL 2000). It's been 3 hrs now, how long will a 950mb database take to fully load?

I searched on this, but couldn't find anything. Can I take a formula and make it a parameter in CR 8.5? Basically what has happened is, I have an Access database with dates in it, Crystal thinks it's a string, so I wrote a formula to make it a date. But in the report I need the user to select a...

I have a database that has audited the .EXEs on all the machines in the company. Within the database some machines have multiple occurences of the same .exe, but I only want to count that as 1 for that machine. I have the report where it will print out only 1 occurence, but it is still...

My question is: Can you take a field or a total from a cross tab and use it in a normal formula?

I am working on a report that lists all invoices for my company, which in itself is easy. The problem comes when an invoice that hasn't showed up on the financial side is missing. I want to list the ones that didn't show up besides going through the pages and pages of numbers looking to see...

Ok...here's a weird one, that I haven't been able to figure out. The report is a Representative x Customer x Order report and looks like this: Rep Name Company Name1 Order #1 Amount A Order #2 Amount B ----------------------- Company Total TotalA Company...

This may be a bad question, and if it is, just shoot me. I'm running out of space on the backup server due to the catalog directory of veritas being over a gig in size. Each catalog file is about 20 something mb. Is there anything wrong with deleting the ones from a couple months ago (we...

I need a top of the line video card with at least 2 ports so that I can drive two monitors at the same time. What would you recommend? Brand/Model/etc?

Ok...here is the problem...I have a report that gives the invoice amount by multiplying the qty_shipped by unit_price. This is done for each customer order, and what I would like to do is total all the invoice amounts for a customer. This seemed easy enough, but when I add a subtotal using the...

I have a problem...I had a machine crash and the only way to back up the files was to use a network boot disk and copy the files using DOS to the server. When I got the machine reloaded and copied the files back I noticed that all the files with long filenames are truncated because of DOS...

I am trying to do a select statement and I am using the following format: select * from database where something = '1998' However, the problem is the word select turns blue like it should, but the words from and where do not and the statement does not work. However, if I go to the SQL server...

I have a distribution list in my contacts that I want to send an individual email out with so that each person's name is in the TO: area. I figure doing this with Visual Basic is the easiest route to go, but I need some help getting started. I'm not really a programmer and this has me...