can't open Visual Studio 2005 Reports in VS 2005
I am trying to open some reports that were created in VS 2005 to make modifications to them. After making the changes, I have to reload them on a number of machines, some that have SQL Server 2005, and others that are SQL Server 2008. I originally planned on installing SQL Server 2005 but the new machine which is Windows7 doesn't allow me to install Reporting Services, so I installed SQL Server 2008 instead. Now when I open the report application in Visual Studio 2005, I am getting an error saying to make sure the project type .rptproj is installed. Is there a way to get around this problem? If I install Visual Studio 2008, can I publish the reports, so SQL Server 2005 can read them? Thanks for your assistance
Bob Learned
Can you tell me what you mean by "Windows 7 doesn't allow me to install Reporting Services"?
ASKER
When I tried installing SQL Server 2005 on this Windows 7 machine, Reporting Services was grayed out, meaning it was not going to install it.
Do you have 32-bit or 64-bit Windows 7?
ASKER
I have a 64 bit machine
ASKER
The more important question is if I convert the reports to use Visual Studio 2008, can I upload the changed reports to a SQL Server 2005 machine and will they be able to view them?
If so, I will just uninstall Visual Studio 2005 and install Visual Studio 2008.
If so, I will just uninstall Visual Studio 2005 and install Visual Studio 2008.
I skipped over 2008, and went right to 2010, so I can't comment. You should be able to run a small test to test that theory, though.
ASKER
Thanks I was planning on trying that later today.
Sorry I couldn't be of more help. My assumption is that you can use either SQL Server 2005 or 2008 to store report files from either version. I just can't test that assumption.
ASKER
I just sent a 2008 version of one of our reports to a 2005 machine. I get the following error:
The report definition has an invalid target namespace http://semas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition which cannot be upgraded.
If I install SQL Server 2005 on this new machine and not worry about Reporting Services, will the report open properly in Visual Studio 2005 so that I can make changes?
The report definition has an invalid target namespace http://semas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition which cannot be upgraded.
If I install SQL Server 2005 on this new machine and not worry about Reporting Services, will the report open properly in Visual Studio 2005 so that I can make changes?
The .rptproj file should be associated with an application that is installed with the Reporting Services, so I would say that you would need to install Reporting Services on that machine. Do you have IIS installed on that machine?
ASKER
I knew that I needed to upgrade to Windows 7 Professional since I had Windows 7 Home Premium. I just finished that. Then I set the following Windows features: IIS 6 WNI Compatibility, IIS Metabase and IIS 6 Configuration compatibility, In application development Features I set .Net Extensibility, ASP.Net, ISAPI Extension, ISAPI Filters, All items in Common HTTP Features, and in Security Request Filtering, and Windows Authenication.
Then I tried to install SQL Server 2005 again. The first time I attempted to install it, I stopped when I could not check the installation of Reporting Services. I then installed SQL Server 2008. When I went thru the installation of SQL Server 2005 I got to the very end, and I got a message stating that Microsoft SQL Server Native Client cannot be found. It needed sqlncli.msi. I went to microsoft and downloaded the x64 version and during the installation of this, it got "A network error occurred while attemping to read from the file
C:\users\...Microsoft\Wind
I deleted the file and downloaded it again. This time I chose Modify - Allow users to change the way features are installed and got the same error. I then tried Repair - Repair installation error in the progam. This option fixes missing or corrupt files, shortcuts and registry entries.
and got the same error.
Question - Do you think I need to uninstall SQL Server 2008 and first install SQL Server 2005 ?
Then I tried to install SQL Server 2005 again. The first time I attempted to install it, I stopped when I could not check the installation of Reporting Services. I then installed SQL Server 2008. When I went thru the installation of SQL Server 2005 I got to the very end, and I got a message stating that Microsoft SQL Server Native Client cannot be found. It needed sqlncli.msi. I went to microsoft and downloaded the x64 version and during the installation of this, it got "A network error occurred while attemping to read from the file
C:\users\...Microsoft\Wind
I deleted the file and downloaded it again. This time I chose Modify - Allow users to change the way features are installed and got the same error. I then tried Repair - Repair installation error in the progam. This option fixes missing or corrupt files, shortcuts and registry entries.
and got the same error.
Question - Do you think I need to uninstall SQL Server 2008 and first install SQL Server 2005 ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I never solved the problem, because I did an inplace update.