My first question would be why the temp tables are not being dropped when the connection is closed?  The statement you list will work with the following changes:

if exists (select...

Could you post your select statement?  I use linked servers using ODBC to an AS400 and have not seen this particular issue.

Does the first dataset create a table in SQL or a table in the report?  If it creates a table in the report I don't think there is a way...

We had this problem just logging into one of SQL Servers using NT Authentication.  I believe we had to reboot the SQL Server in order to use NT Authentication.  It was...

I probably should have included the if exists in my sample.  I would replace the COunt(*) code and the if @type = 'Update' to this:

If Exists(Select * from deleted) --updated...

Using Distinc and then doing concatenation is definitely going to slow down the query.  Distinct can cause a table scan.  You would be better off to use a group by...

I always favor stored procedures for data access.  Even if I were using views I would not write select statements in the front end against the view, I would write...

First off, looking at your code, you have an insert update trigger so if it fires there will ALWAYS be data in the inserted table, so getting a row count...

This is in addition to my last post.  I participated in a Web seminar on RS by SQL Server Magazine last week and they demonstarted creating a standard report template...

Rayven,  are you going through any kind of Proxy server that may be caching the PDF?

I had the other problem with blank pages sort of.  I had 3 subreports on a report, ...

Try this, it's not all that much differnet from what you already have:

Create FUNCTION

dbo.udf_GetEMpsBYManager

(

@empid

char(6)

)

RETURNS

@table_variable TABLE

Much simpler to begin your sp with Set Transaction Isolation Level Read Uncommitted.  This means that any selects in the batch/sp will allow dirty reads, but will not hold locks,...

I'd go with A as well.  I'm guessing you could very cheaply add Hard disk space to A if you find the need.  You also want the development server ot...

I don't think Citrix will grab 100mb per connection, of course this will vary based on your app requirements.  I would say that you need to make it clear that...

Never Tried it, but I would guess that you could use expressions to do your calculations.  An expression Like:

matrix1!txtSales.Value - matrix2!txtReturns.Value

I would ptobably do what Kathi suggested but I'd...