What package? This is an SSRS report. It works fine on the server. It's when I open it on my PC to edit the report and use the Preview function...

I am an administrator on my machine. I do not run BIDS as administrator, but I just tried it and it doesn't help (but it was a good idea to...

Nice Job!

This is one reason that I have developers install the SQL Server "Standard" edition from MSDN rather than the "Developer" edition.

The Developer edition has all features enabled, including the Enterprise...

I guess that's the problem - yes, it would...

It all depends on your business needs, which is *why* Report Manager as a basis will never be more than an example or demo or proof of concept -- no...

You've written your own report robot -- which is exactly what I suggested -- and you can, and in many cases should, replace *all* of what Report Manager does with...

I also can't believe that there is no ability to move columns in a tablix (i.e. drag and drop).

I agree with two others already posted:

- Dynamically name reports

The other poster wanted to do it for scheduled reports, but we have a different problem.

A user wants to use Excel...

No - that's what we really would...

I use it when...

I just do this:

ALTER DATABASE dbname

SET SINGLE_USER WITH ROLLBACK IMMEDIATE

GO

ALTER DATABASE dbname

SET MULTI_USER

GO

Any advantage or disadvantage over the script?

Steve Jones - SSC Editor (10/8/2010)

---

Please don't post questions about SQL Server 2008 R2 in this thread. That is a separate product and has completely separate patches.

There is a...

I found a solution to this. The reason it was happening was that when I installed SQL 2008 R2, I also installed Cumulative Update 2.

There apparently is a version...

Atif,

That doesn't exactly give what I need because there is no relationship between DataValueA and DataValueB.

The only relationship between the two tables is RowID.

When I run your query, I get:

A_RowID...