Crystal XI on SQL 2008
I have a table that records customer transactions, and there are multiple transactions in the table per customer, so there could be 30 transactions listed in the table for one customer. There is a date field on each transaction (no more than one per day in the table), and...
I've written a report (XI) that selects a customer shipping address, and prints it to a shipping label (on a Dymo LabelWriter 330 Turbo). In Crystal, I select the correct printer and label size, save the report, run it, and it prints correctly. However, if I close the report then reopen it, the...
I've binged this and searched on this site, but haven't found an answer... I am trying to find out if it is possible to attach a file such as a PDF directly to a workflow item in eSynergy. It can be done in a "document", but I have some workflow items that I'd like to be able to directly attach...
I have a file that needs to be on all workstations in my Windows Server 2003 network, if it's not, an enterprise-wide program we use doesn't function properly for anyone. It's in a folder in that particular app's program file on the C drive of each workstation, placed there manually.
We use a...
While billing an order, the computer it was being done on lost power and shut down. Upon restarting, the order was successfully billed and invoiced (it has an invoice number), and shows up in the general ledger, but it remains in open order status (the row is still showing up in the oeordhdr_sql...
We're having an issue with a comment defaulting onto our production work orders.
When printing a new production work order, the comment section defaults to the same comment for each order, and I can't find where to shut it off/change it.
When we enter a new production work order, the comment is...
I have two websites, an old one and a new one, each with a unique IP. I had to switch the domain name from the old to the new, as the old one is being phased out. I'm using a subdomain of our main network domain name (e.g., store.mycompany.com as opposed to www.mycompany.com), and have pointed...
I don't use SQL much these days, so my query writing skills have deteriorated... I've googled and looked around the net but haven't found a specific answer for my issue.
I have two tables, one that holds header information for sales orders, and the other that holds line information for those...
We recently upgraded to Macola Enterprise Suite 9.5. Since the upgrade, in the Cash Flow screen, when writing a manual check, we can no longer search for the G/L account or the Project codes when allocating the check.
I was wondering if anyone else has run into this, or if there is a way to...
I set up an FTP server on an XP Pro box, with IIS 5.1. It's a box with a static IP, and I'm only going to use it within my LAN.
When I go to log into the site, either by using the IP or the computer name in the address, I can't get past the login screen... either trying to log in anonymously or...
IE 6 on an XP SP2 box:
I'm having a problem with IE 6 not refreshing websites. For example, if I visit a website early in the day, and changes are made to it (such as a news site), when I re-open the website later in the day, I get the cached site and have to manually refresh the browser to get...
Using Exchange 2003 on a Windows 2003 server.
We were using a mailbox that was a sort of "catch-all" account, and it grew too large and was obsolete anyhow, so I deleted the mailbox in System Manager, and in AD. Before I did that, I set the limits to "keep deleted mailboxes for (Days)" to 0...
I work for a small company, and we're starting to get bigger, ergo, the amount of data we're collecting is also getting bigger, so we need a more secure way of storing/retrieving/restoring it.
I've researched SAN and NAS solutions, and decided NAS was the way to go for us. I've dug through...
I am writing a report off of production order and inventory data, and I'm having trouble locating one table. In the Production Order View (POP-->View-->Production orders), search for PO by item, select a row, and there is a Last Transaction field in the PO View screen.
I've googled it and looked...
Using Excel 2007.
I have a list of 2000+ customer numbers, that I'm trying to format to include open and closing quotes and a comma after each one; '798789',
I've been highlighting the entire column, selecting Format Cells, Custom, and putting in '######', to format the column. The formatting...
I have a year or so old Dell GX620 machine that will not boot into Windows XP Pro (came installed). It gets to the logo screen and progress indicator bar, but the indicator stops 3/4ths of the way at each attempt, and the pc locks.
It always locks just as Windows starts to boot, no matter the...
I'm looking to set up a network PC out in our shop, Windows XP Pro. I'm going to create one restricted generic login that will be available for everyone to use on that particular box.
What I need to do is limit that account to only be able to use Internet Explorer, and have that only be able to...
The time on the servers and desktops connected to our network are running 7 minutes faster than "real" time. How would one go about getting them all set back to the proper time?
It's a mix of Windows 2003 and 2000 Servers (DNS, 2DNS, file servers), with all XP Professional desktops.
I'm not sure...
I'm looking to do a mass email campaign for my company (using only emails from people who have opted in to receive ads and newsletters from us, no unsolicited spam!), and I'm looking for a good bulk email program.
We had been using a hosted service for this, but we've had a few issues with them...
We have two static IP addresses that used to be assigned to 2 machines, but the machines were decomissioned and the IP's freed up for use at a later date.
The later date is here, but the IP's are showing up as in use (pinging the address shows this), and all of the machines on our network are...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.