Mostly we're on SQL 2008 R2 with a couple of SQL 2005 and only one remaining legacy server at SQL 2000. But our main issue is having databases that are...

Thanks for the great article!

I just want to make one small comment. I ran the code below:

[font="Courier New"]SELECT OrderAmt,

IIF(OrderAmt > 200,

'High $ Order',

'Low $...

Wow, I didn't know that.

Thanks for the question.

webrunner

Ha ha ha. Nice.

I was scared for a moment that this was a real script, until I checked the comments.

Thanks,

webrunner

Just want to say, your tag line is truly inspirational:

Simple but really, truer words were never spoken....

I think the advice about using queries makes the most sense.

But look at this to synchronize reports if needed.

http://basitaalishan.com/2013/04/02/sql-server-reporiting-services-migrating-ssrs-reports-data-sources-and-subscriptions-from-one-server-to-another/

Good luck.

- webrunner

Thanks, everyone, for your replies!!

Lowell, I didn't know about sp_refreshview - that sounds like a huge help.

Thanks again,

webrunner

Great question even with the caveats posted in the comments. Thanks!

- webrunner

GilaMonster (3/21/2014)

---

This is the problematic query taken to basics:

SELECT col1, col1 FROM SomeTable ORDER BY col1

It's the order by, it doesn't know which col1 to sort by. Wasn't caught by...

patrickmcginnis59 10839 (3/21/2014)

---

Double check that the 2000 server (edit: database) doesn't has a case sensitive collation and the same named columns aren't just different casewise (and thus actually unique).

Also, you...

Thanks, but it is the same exact...

Sorry, I did see one other difference, but this was in the html source of the reports.

In the working report I see this bit of code:

</div><div id="ctl31_ctl09_ReportArea">

<div NewContentType="Microsoft.Reporting.WebFormsClient.ReportAreaContent.None" ForNonReportContentArea="false" id="ctl31_ctl09_VisibilityState"...

MyDoggieJessie (3/17/2014)

---

Open the working report up in SSRS, go to properties and click the "Edit" button, this will allow you to download the RDL file.

Go to the same report that's...

MyDoggieJessie (3/17/2014)

---

Do other reports work/render properly?

Are you 100% certain the data sources are set correctly? It's typical when deploying SSRS reports from BIDS to turn off the "overwrite data...

Thanks!

Is...