RSS

SSRS Report in R3 – VS 2012 vs. VS 2010

19 Aug

Problem:
In R3 environment, when I tried to to edit a report,  i received the following message
“Unable to preview the report, install the Business Intelligence Development Studio feature of Microsoft SQL Server For more information”

image

AOT > Visual Studio Projects > Select a project > Right Click > Edit

image

Notice that VS 2010 is still being used as a default one.

image

Solution:
AX R3 still needs to integrate with Visual Studio 2010 and therefore you have to have BIDS (Business Intelligence Development Studio). You can use a SQL Server 2008 R2 installation image to install it (it’s one of the components you can select during installation of “A new standalone server or additional components” on the client machine.

SQL Server 2008 R2 Setup Feature Selection

How to installing(adding) features (SSRS) to an existing SQL installation. Please follow this link:
http://mssqltrek.com/2012/02/10/installingadding-featuressrs-to-an-existing-sql-installation/

Advertisements
 

Tags: , , , , , ,

6 responses to “SSRS Report in R3 – VS 2012 vs. VS 2010

  1. techguns.wordpress.com

    December 8, 2014 at 9:51 am

    Thanks Man,

    My issue got resolved after following your resolution.

     
  2. Umesh Pandit

    February 23, 2015 at 1:16 pm

     
    • Hai Nguyen

      April 24, 2015 at 3:06 am

      I’m glad my blog can help

       
  3. Michael Costello

    April 23, 2015 at 2:26 am

    Hai – you do not need VS 2010 if you have AX 2012 R3 CU8. We use SQL 2014, VS 2013, and the new SQL Server Data Tools for VS which is the replacement for BIDS.

    Keep up the good posts.

     
    • Hai Nguyen

      April 24, 2015 at 3:06 am

      Good point. Thanks for the tip.

       
  4. Deepak Kalra

    December 3, 2015 at 10:54 am

    Reblogged this on AX Technical World.

     

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

 
%d bloggers like this: