We rebuilt the server from scratch and it finally worked.

Have I mentioned how much I like Windows lately?

If that's not a rhetorical question, I'll take a shot.

At our company an analyst tends to be from a business background, not technical.  Their charge is to analyse business processes...

Sure.

Some years ago we developed a data warehouse incrementally, starting with a desktop as proof of concept, and growing over time. It's now very large, and wildly successful, but largely built...

That gives the correct answer, as does saving the union in a temp table first.

Argg... this is very frustrating.  It is now not consistent with yesterday.  The specific customer that I was using yesterday now gives the right answer both ways, but others are...

That's kind of like saying "from Windows"... it covers a lot of ground.

If you are using Rdb, there are ODBC connections to it which (though I have never done so)...

We opened a call with Microsoft.  They say they have heard of this a few times before, and their answer so far has been to check a bunch of items...

There's a known interaction with Visual Studio Analyzer - probably not your problem.  See KB Article 298828.

This probably is - see KB # 830767 or http://support.microsoft.com/default.aspx?scid=kb;en-us;830767&Product=sql2k

The good news is...

I haven't experimented a lot but what's wrong with PDF?

The viewer is free and ubiquitous, and at least in all cases I've tried in the past the printout is...

Thank you.  The second certainly appears on target.

Can you give me a reference, just for my network admin's reading enjoyment?

I think you can add a report PROJECT to a web project and get the RS designer interface.

And once you do that then VSS integration is automatic, at least in...

Also be aware on Windows 2003 that even with ASPX on, ASP is by default off.  That won't affect reporting services (I think), but sure was a pain to find. ...

I'm disappointed not many people here seem active with Reporting Services.  Is that a sign of just lack of use, or that it did not meet expectations?

Here is where we...

Thanks.  We are (Playing).

I think you may have hit on the key -- the report is itself a different thing deployed to a different place than the web pages that...

I'm running SQL 2000 Enterprise SP3A on a 4-way system with 32G of memory (all of which might change its optimizations I guess).  The table in question has 25,127,151 rows. ...