Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Unable to View the SSRS Reports in Visual studio

Posted on by 995

Hello all,

I am unable to preview SSRS Reports from Reports project when viewed on VS 2010.

I am currently with VS 2010 with Dynamics AX 2012 R3 and with SQL Server 2014 on Back-end. I get following error:

"Unable to preview the report, install the Business Intelligence Development Studio feature of Microsoft SQL Server. For more information, see http://go.microsoft.com/fwlink/?LinkId=212331.

Has anybody else faced this problem specifically on Dynamics AX 2012 R3 with SQL Server 2014 as Database??

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unable to View the SSRS Reports in Visual studio

    The requirement for VS2013 in AX2012 R3 R3 CU8 can be seen in the Technet article

    https://blogs.msdn.microsoft.com/axsupport/2014/11/24/visual-studio-tools-for-microsoft-dynamics-ax-2012-r3-cu8-now-requires-microsoft-visual-studio-2013/

    I added some more details on this here.

    Robert T.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unable to View the SSRS Reports in Visual studio

    With AX 2012 R3 CU8 you must be use Visual Studio 2013 or later.

  • sohaibcheema Profile Picture
    sohaibcheema 46,592 User Group Leader on at
    RE: Unable to View the SSRS Reports in Visual studio

    You may mark the thread as completed.

  • Suggested answer
    Raghavendar Profile Picture
    Raghavendar 995 on at
    RE: Unable to View the SSRS Reports in Visual studio

    Thank you Mr.sohaib

    I have installed SQL server 2008 R2 Business intelligence Dev Tools.

    Now I am able to Edit the Reports.

  • Raghavendar Profile Picture
    Raghavendar 995 on at
    RE: Unable to View the SSRS Reports in Visual studio

    Thanks for Response sohaib

    I have found another SQLserver2014 CTP2.It has BIDS Components.Can i use that.

    will it support VS 2010.

    Please suggest me

    Thanks

    Raghavendar

  • Douglas Noel Profile Picture
    Douglas Noel 3,905 on at
    RE: Unable to View the SSRS Reports in Visual studio

    Hi all,

    one more info, you can (able+allowed) use the SQLServer2008 Express version (with Advanced Services) for setup BIDS.

    regards

    Douglas

  • Suggested answer
    sohaibcheema Profile Picture
    sohaibcheema 46,592 User Group Leader on at
    RE: Unable to View the SSRS Reports in Visual studio

    Remember you don't have to install SQL 2008R2 full.

    you have to only install BIDS components from setup.

  • Verified answer
    sohaibcheema Profile Picture
    sohaibcheema 46,592 User Group Leader on at
    RE: Unable to View the SSRS Reports in Visual studio

    No

    Visual studio will be 2010.

    For AX201-R3 following is needed, to modify reports

    Visual studio 2010 with VS 2010 SP1 and BIDS of SQL 2008R2 and third VS tools (by AX Setup)

  • Raghavendar Profile Picture
    Raghavendar 995 on at
    RE: Unable to View the SSRS Reports in Visual studio

    Hi sohaib

    Thanks For your response

    Inorder to Install the SQL server 2008 R2 i need have VS2008 as per below link

    msdn.microsoft.com/.../ms173767(v=sql.105).aspx

    Or else can i use VS2012 Directly

    So can you please suggest me

  • Verified answer
    sohaibcheema Profile Picture
    sohaibcheema 46,592 User Group Leader on at
    RE: Unable to View the SSRS Reports in Visual studio

    if you are using AX 20120-R3, and on other hand you are using SQL 2014, you have to install BIDS components from SQL 2008R2.

    kindly run setup of SQL 2008R2 and install BIDS. This is strange to install BIDS of a lower version (SQL2008R2), while you  are using SQL2014, But you  have to do it, if you want to customize reports

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans