Grabbing RDL from Server to Edit

I had a report that was working on on server but not inside my studio environment.  I had changed it too much.  I wanted to go back and start with the report that worked.  This is what I did:

In Report Manager, I clicked Edit in the Properties>General tab for the
given report.  You should get a File Download window; select Save and
put the rdl in the folder where you want it.  I over wrote the file I was working on.  You should probably close Visual Studio before you do this so there are no issues.  Another way to have done it is to save the RDL file someplace else and then  import it by right clicking on Reports then select Add>Add new item then pick your RDL.  You should then be able to open it in Designer.

Hope this helped someone. Have fun coding and as always, if there are any questions or suggestions, they are always welcome. Thank you.

VS 2005 Premier Partner Edition

    First off let me explain what Premier Partner Edition is. It is the studio environment that is installed when you install SQL Server 2005 or greater.  It is used to create Analysis Service Projects, Integration Service Projects, Report Model Projects, etc.  Beyond that it doesn’t much else. The issue we were having at work was that at one point it worked (for over a year) and then one day it just stopped working for some reason.  Not sure why. We tried a bunch of stuff without success. Our setup is Windows XP SP3 with SQL Server 2005 SP4.  I tried to install different SP for XP and along with different combinations of the SP for SQL Serve 2005. No luck at all. What it turned out to be was one setting. Isn’t that always the case. The setting in this instance had to do with the connection managers. There is an attribute that needed changed from false to true. It is the “ReatinSameConnection” setting.  Once that was changed; no more issues. It took months to figure that out. Literally months. Rebuilds, reconfigures, changing, etc. to no avail. Hope this helped someone.

    Have fun coding and as always, if there are any questions or suggestions, they are always welcome. Thank you.