So, if I remove about 2/3 of the columns in the report, it will render. This report was first deployed about 6 months ago, and was working fine. ...

mikeg 31960 (4/13/2012)

---

Your thoughtful reply, the windows event entry "cannot connect to the ReportServer database", the fact that it works on your Dev Report Server but not on QA/Prod...

mikeg 31960 (4/13/2012)

---

That's a good log!

I have weird problems rendering but only when using those new fancy Dundas-esque controls. Is the failing report using any of those new fancy 2008...

Does this help any? The first error says error may be due to connection failure, timeout, or low disk condition. There are only 10 or so user connections...

Deleting the report and data source didn't help.

That (the error log) is where I got the exception information from. It wasn't very informative. And any thoughts on why only the 1 report would cause problems?

J Livingston SQL (10/10/2011)

---

Tom..what code have you got so far...can you post please...maybe it will...

jared-709193 (10/10/2011)

---

J Livingston SQL (10/10/2011)

---

Tom Bakerman (10/10/2011)

---

BUT, one clarification, and this is where I seem to get stuck:

The result for the current month is MTD (GETDATE()). The count for...

Thanks everybody for the responses. J Livingston SQL's looks the most promising. I'm guessing that I would do that, and then UNPIVOT the resulting row into multiple rows...

I'm dense...

Thanks Jared. Looks promising. But:

Is the only way to get what I want to do something like:

SELECT Count(*), Year, Month

from ...

group by year, month

where year and...

I'm guessing I need...

Lynn,

That's why I was hoping this might be doable in the AdventureWorks database, but here's something:

declare @Invoices table (

InvoiceNumber int IDENTITY(1,1) NOT NULL,

InvoiceDate date NOT NULL,

PaidDate date NULL,

IsPaid bit NOT...

2008 R2

Over the weekend had an inspiration (after digging out a piece of granite the size of a basketball from a hole 2 feet deep). I use custom code to...

Old post, I know, but I'm having difficulty implementing this solution. It works fine for the first few pages of the report, but then the color banding starts going...