knowing how other things have gone from time to time, one might think the Thread would get that coveted post number. But yeah I'd take the field in a...

tsmith-960032 (9/21/2010)

---

Ok,

ColumnA is a shipping number.

Each shipping number...

Why doesn't it matter which in records 1-2? If it doesn't matter why return that column at all?

-Luke.

so the sample data and expected output?

If you're doing everything at rendering just pull everything, then group by columnA, add your calculations on columns b,c or whatnot. It's about...

Some sample data and required output would be very valuable here. See the first link in my signature for more info.

You need to figure out if you'll do the...

I'd suggest you check out the RS Scripter available here. One of the options of this tool is to download the reports from your live server to a solution...

I'd be happy to help, but I don't understand the Crystal syntax. Any chance you can just post some sample data and expected results?

It looks like you were just...

What is the problem you are having? Can you describe it a bit better or provide error messages? The max number of rows in Excel 2007 is 1...

Jeff Moden (9/20/2010)

---

I don't like the short version at all because it "lies". If you expand the code it actually executes against variables, you find a big surprise. ...

It's really a personal preference as AFAIK there's no performance difference, hence the "I prefer to avoid the short version". The longer (searched, or boolean depending on the...

Looks like Lutz beat me to it with a bit better sample code... Not something I would have thought to use a CTE for but it would definitely help with...

Couple of things here... It would be helpful if you posted some sample data and expected results as per the first link in my signature. Secondly, It looks like...

GilaMonster (9/20/2010)

---

*drum roll*

*trumpet crescendo*

... and I think I'll leave things here for a little while.

Edit: And as soon as i decide not to post for a few hours, there's a...

Jack Corbett (9/16/2010)

---

The only suggestion I'd make is to re-up the comics and make them viewable without joining SSC. I forwarded one to my boss once, not a DBA,...

CirquedeSQLeil (9/16/2010)

---

Luke L (9/16/2010)

---

Good Humor?...