Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Unable to View the SSR...
Microsoft Dynamics AX (Archived)

Unable to View the SSRS Reports in Visual studio

(1) ShareShare
ReportReport
Posted on by Raghavendar 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??

*This post is locked for comments

  • 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.

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 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
    Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 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
    Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 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
    Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans