We finally solved our problem (see details below). In our case the error occurred only a multi-processor report server and only when there were multiple concurrent calls to the Report...

I tried it, and it worked. Nicely done! Thanks so much.

If my tables were likely to have more than 100 or so rows, then I would be more concerned about...

Perhaps you should convert d.recordid from VARCHAR(50) to INT before comparing it to c.recordid.

Is the promotion column in c or d? I think you should prefix promotion with the table in the WHERE clause (like WHERE c.promotion = ). I'm not sure if...

Create a new report that contains all of the other reports as subreports. Then create a subscription to deliver that new report (or a link to it) daily.

1. Set the PageSize (Width = 11in, Height = 8.5 in) and Margins properties of the Report object.

2. Set the Size property of the Body object to fit within the margins...

I bet a nickel that the upper limit is 32,767 tables (maximum value of an Integer data type).

Well, if you are rendering in HTML format, you could try including a cascading style sheet in the output. The CSS must include styles like those shown below:

A:link { 

 text-decoration: none;

 color: #3333cc;

 } 

A:visited { 

 text-decoration: none;

 color: #333399;

 } 

A:active { 

 text-decoration: none;

 color: #333399;

 } 

A:hover { 

 text-decoration: underline;

 color: #3333cc;

 }

I would start by deploying the sample reports that install with Reporting Services. Try to run them at http://servername/Reports. If they run, then you know the problem is specific...

Where I come from, a "business analyst" or "systems analyst" develops requirements (functional and/or system/technical) and/or design documents. They might also be involved in developing and executing test documents, especially...

I can report that there are at least some user groups that are still thriving. The Los Angeles SQL Server Professionals Group (http://www.sql.la) has been meeting monthly since Sep 2003...

Well, we don't have SQL Server 2005 installed. So that may or may not have anything to do with it. But I would suggest that you test Reporting Services on a...

The articles states "Generally, developers don't like writing a ton of extra code to add this auditing into their stored procedures and it falls to the DBAs to ensure the...

We have been getting those kind of errors, not in Reports Manager, but when calling the ReportServer web service programatically. In my experience, the problem occurs frequently whenever there are multiple...

As the question is written, the answer is incorrect because it is certainly possible (and usually easy) to create a fifth report containing the other four reports as subreports and attach...