Recent content by lkerr

Thanks, Skip. Call me an idiot (I'm still learning Office 2007 vs 2003), but I can't find the "Add Tables" Window. Where should I be looking?

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...

lbass - That's exactly what I ended up doing. He originally wanted it sorted by only a certain product, which was driving me batty. :) But, since he wanted it sorted by ALL products, he made my life ever so much easier.

Never mind ... the user changed his needs/wants and made it much easier for me. Thanks anyhow. :)

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)...

Well, you've done it again! Thanks so much for your help! I can only stand in awe of your knowledge (and ability/willingness to use it to help others.)

Soryy, yep, in the crosstab. The user who has requested the report also wants to see the profit shown as a percentage - so in the regular report, it would be this formula: ((gross - net) / gross) * 100 But I don't have a clue how to represent the ((sumgross - sumnet) / sumgross) * 100 in...

Gah ... one more question. I need to sum up a percentage ... how do I get that to show up accurately?

Thanks ... I knew it was something simple that I was missing. :)

I don't think I expressed myself clearly. Sorry. What I want is to display a summary of all job types for each year .. so the above columns (which are net, gross, and profit) would display a sum. So the whole report would look like this: GH1: 2007 ({JobDate} - sorted and grouped by year)...

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...

FYI, I did end up using =d2-(1/24) ... kinda a combo of the original help-posts to end up with the third. :)

Thanks! This was just a "duh" moment for me, I think. Occasionally I need hit upside the head with the obvious. :) (Why is the hard stuff so much easier? I can write vlookups for hours without problems. Heh.)

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...