I have come up with a solution/workaround. Put all the tables into a List object. Then take the large text column out of the table and place it in the...

Here's an example. To illustrate, I'm just pulling back the Article Title and the Article Details. I made the table background dark just so to distinguish it from the rest...

Nope, SP2 didn't fix it. But I realized this is a year old too. Anyone have this problem in SSRS 2005?

Richard.

It seems that no-one has run into this problem before.

Anyway, hopefully SP2 will solve it.

http://www.microsoft.com/downloads/details.aspx?FamilyId=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en

You would do something like this in an Expression.

=ReportItems!Textbox1.Value

HTH

Richard.

I would start by running your query through the Execution Plan in Query Analyzer and see where your bottlenecks are. Then, I would definitely rewrite your query.

I haven't found RS to be that slow. I have to different installations on different setups and some users are accessing these reports from the UK and the US.  Have...

No, this is the for the url. It basically tells the report to not used the cached version and to always get a fresh copy from the database. Are you...

I believe what you're looking for is :

&rs:ClearSession=true

HTH.

-- create table variable

declare @resequence table( keyid      integer identity(1,1),

                           stulink    integer,

                           coursedate datetime)

declare @rowct      integer

declare @numrows    integer

declare @coursedate datetime

declare @sequenceno integer

declare @curstulink integer

declare @prestulink integer

January 24, 2006 at 6:59 am