Search

SQL Server Report Project Unsupported in Visual Studio 2012 by bpatin

Active

7
0
Sign in
 to vote
Type: Bug
ID: 767209
Opened: 10/12/2012 9:33:25 AM
Access Restriction: Public
0
Workaround(s)
2
User(s) can reproduce this bug
I have installed Visual Studio Ultimate 2012 version 11.0.50727.1 on Windows 7 and Windows 8 with .NET version 4.5.50709 and SQL Server Data Tools version 11.1.20905.0 for Visual Studio 2012. I had a SQL Server Reporting Services project created in Visual Studio 2008 and converted with Visual Studio 2010. The project file has extension .rptproj. When I try to open the project in Visual Studio 2012, I get an error saying that it is unsupported.
Details (expand)

Product Language

English

Version

SQL Server 2012 - Developer Edition

Category

Developer Tools (SSDT, BIDS, etc.)

Operating System

Windows 7 Ultimate

Operating System Language

US English

Steps to Reproduce

1. Create SQL Server Report Project / Business Intelligence report in Visual Studio 2008 or 2010.
2. Install Visual Studio 2012.
3. Install SQL Server Data Tools version 11.1.20905.0 for Visual Studio 2012.
4. Try to open report project in Visual Studio 2012.

Actual Results

Error message saying that the project is unsupported, that there is no application available to open it.

Expected Results

Project opens, and reports can be edited.

Platform

X64

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Posted by bpatin on 4/16/2013 at 9:23 AM
While it seemed to be what I needed, the page you mention leads me to download "SSDTBI_VS2012_x86_ENU.exe". When I try to install it, it attempts to install SQL Server SP1 on my SQL Server instance, even though SP1 is already installed. Then it fails with an architecture mismatch. The "x86" in the file name is a clue to me that I need a different one for 64 bit architecture, since I am running 64 bit versions of Windows Server, SQL Server and Visual Studio 2012. But no other file is specified and the specs say it supports x64 anyway.

I did find a file named "SQLServerDataToolsForVS2012_SSDTSetup.exe" in a folder that I keep for saving installation downloads (I don't remember where I got it), and installed that, which it did successfully. However, Visual Studio 2012 still does not recognize project file type ".rptproj".
Posted by Microsoft on 4/9/2013 at 4:52 PM
Please install the Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012 addin from http://www.microsoft.com/en-us/download/details.aspx?id=36843 . If this does not solve your issue, please reply to this thread.

Thanks,
Matt Jones
Posted by bpatin on 4/5/2013 at 12:43 PM
For security reasons, I cannot give you a copy of a solution. However, you can check it very simply. Go to Visual Studio 2012 and try to open a project based on a project file type ".rptproj". You should find that it is not listed in the selection list for project types. If your installation of Visual Studio 2012 does have a project file type ".rptproj", then I am missing something. In that case, please give me a clue as to what i am missing and how to install it. You can also try to create a report project, but the closest that you will get is a Windows C# Reporting Application, with a file type of ".csproj", which is not the same as a Reporting Services Report Project.
Posted by Microsoft on 4/4/2013 at 2:26 PM
Thanks for finding and notifying us of this issue. We have tested and confirmed that projects created with VS 2010 and VS2012 are forward and backward compatible. If possible, please attach a zipped up solution file from VS2008 or VS2010 that is able to repro this issue.

Thanks,
Matt Jones
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement