Search results for query: *

First, thank you in advance for your assistance. Here's what I'm trying to do: I have two sheets in a workbook which I need to combine. I would normally just use vLookup to pull the columns. However, in this case, Sheet2 has multiple rows that correspond to one row in Sheet1. e.g: Sheet 1...

I tried to search for this, because I'm sure it's been answered, but the google search didn't produce anything useful. Any help would be appreciated. I have a report with the following: Group 1: {year} Group 2: {Client Name} Group 3: {Product}, {Distinct Count, Sale ID} Detail (suppressed)...

Working in CR9 ... I have a report with three groups: Group 1: Date (by Year) Group 2: Job Type Group 3: Job What I want to do is put a summary of the totals for the year, listed by job type, in the GF1. So the footer would look like this: GF3: suppressed GF2: suppressed GF1: Job Type #1...

Okay ... here's my problem. I have a user (okay, myself) using an ODBC connection to access the MySQL databases through Crystal Reports 9. (Windows XP SP2, all updates) When I try to do this, I get the following error message: Logon failed. Details: 28000:[Microsoft][ODBC SQL Server...

I have a CSV, which I open in Excel 2007, containing a list of events, with their start times and end times. However, the start time and end times are in Eastern Time and I'm Central time. Before I can upload this list into Outlook, I need to change all these times to be minus 1 hour. An...

Hi! As sole IT person for a small business, I have primary responsibility for the well-being of computers. Besides my primary desk, I have a separate area for computer storage and repair - which is overflowing at the moment because of a office consolidation. However, its organized (my way)...

Hi! I have an interesting problem - hopefully someone can offer a solution. We are running EX03, fully patched. We recently had a bit of turnover in the company, so I have been asked to allow the covering employees access to the email of the folks who have left. Until today, this had gone...

I have a remote user who is having difficulty with Outlook Express 6.0. When he sends email, he gets the following error message: The message could not be sent because one of the recipients was rejected by the server. The rejected e-mail address was 'xxxxx@xxxx.com'. Subject 'test', Account...

Hi, I'm using CR9 with ODBC connection to MS SQL (2003, I think). Here's my problem: I have a report with three subreports - all with the same linking criterion. Last week, for reasons unknown to me, this report started failing without any particular reason. The subreports are linked via the...

Hi, all! I have an interesting problem that has me stumped. Perhaps someone here has the answer? All of our users run Office 2003. One user in particular just got a new CPU (her old one died and I swapped it out while I work on it). On her old unit, everything was kosher. However, the new...

Quick question ... Does anyone know where to set the default "Save As" location for Microsoft Office Document Imaging? I have a user whose files are automatically going into her temp folder and I need to reset to the correct location. I have tried using the Print Driver - MODI Writer - to set...

Okay, this may seem like a silly question to ask, but under what conditions would the conditional formatting box for the font color disappear? I have a number of fields in my (CR9) report that I need to change color conditionally. I'm fairly sure that there is supposed to be a X2 button next...

Okay guys, I have an "interesting" problem for you ... we are using Norstar M7324s. Yesterday, one of them (okay, MINE) decided that the switchhook would no longer be a functional piece of equipment on the telephone. I thought at first that it was something in the telephone itself, so I...

Hi, I have a problem similar to one that's already been referenced in this forum (thread68-969465) - but unfortunately, its only similar. I have a user who cannot open Word docs with Outlook. If she receives a .doc file as an attachment, outlook tries to open it as a .bmp file, using Paint -...

Hi, all ... I have a simple question - or at least, it should be. We just upgraded to Office 2003 (from 2000) and my users are complaining about the "Cancel Request" dialog box that pops up while Outlook is waiting on the server. I just want to turn it off, but the regedit listed in the...

Hello, all - I am relatively new to the whole "GPO" thing, and so I need some help with what (I think) is pretty easy, but I just don't know how to do it. I am distributing Office 2003 to our computers via a GPO - basically moving computers into the container for distribution, and then moving...

Okay, I have given up ... I need some help, here. I'm using CR 9, and trying to create a report that will show the difference between 1st half 2006 and 1st half 2005. All the information is stored in a SQL database. I've probably gone about it all wrong, but I've tried about 50 different...

Okay, here's my problem. We're beta-testing the new Office 2007 (and yes, I do realize this may be a bug, but I thought I'd ask anyhow). In Outlook, when you right-click a calendar, it offers the option to "Publish to Internet". I always choose the "custom server" option, as we want to...

Hi - our company is considering adding clusters for our SQL server (2003). I was wondering if I could get some input on pros and cons from those who've had it implemented for a while. If you could share any problems you've had with the implementation (and/or current problems), as well as...

I need some help. I have a user attempting to use our company's portable "InFocus" projector with a Win98 laptop. As per instructed, I turn on the projector, and then the computer. The projector senses the computer's signal and displays. However, when I get to the initial login screen, I...