Build SSRS 2008 R2 and SSRS 2012 reports using Visual Studio 2012

The Microsoft SQL Server product team finally released the long awaited SQL Server Data tools – BI templates for Visual Studio 2012. This release installs the SQL Server Business Intelligence projects for Analysis Services, Integration Services, and Reporting Services. Among other things, the release also enables you to create and edit SQL Server 2008 R2 or SQL Server 2012 SSRS reports. You can download and install the tools from here: http://www.microsoft.com/en-us/download/details.aspx?id=36843

Installing the tools however had the adverse effect of causing the data projects in our Visual Studio solutions to fail from working. Here’s what you will need to do to resolve the issue if your database projects are failing to load as well:

  1. Download and install the SSDT December 2012 Update from here: http://go.microsoft.com/fwlink/?LinkID=274984
  2. Download and install the Data-Tier Application framework from here: http://www.microsoft.com/en-us/download/details.aspx?id=36842.
    If you are on an x64 machine, make sure you install the x86 updates (first) as
    well the x64 updates listed in this URL.

Your database projects should work fine after installing the above updates. One last thing worth mentioning is that I currently am on Visual Studio 2012 Update 1 and also that the December 2012 update is the latest one available at this time.

About these ads
This entry was posted in SQL Server, Visual Studio 2012 and tagged , , , . Bookmark the permalink.

2 Responses to Build SSRS 2008 R2 and SSRS 2012 reports using Visual Studio 2012

  1. PSB says:

    Hi I need to convert my report from SSRS 2008 to SSRS 2012.

    The abc database is still on a SQL 2008 server. When I run the SERVERPROPERTY in SSMS , I get the following result :

    productversion productlevel edition
    10.0.4000.0 SP2 Standard Edition (64-bit)

    I opened and saved a 2008 rdl file in SSDT . However The XML still shows the report as 2008 report and not a 2012 report as shown below.

    Do we need to upgrade the server that holds ABC database to sql 2012 or even when the above XML shows sqlserver/reporting/2008/01/reportdefinition , it is still converted into sql 2012 report.

    I tested a sample report from another server using SSDT where the database has compatibility level of 110. But still the XML shows the same .

    Confused . Please help .

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s