Microsoft Dynamics AX (Archived)

Unable to View the SSRS Reports in Visual studio

(1) Share

Report

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

All responses (10)

Answers (2)

Community Member on at

Like (0)

Report

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 on at

Like (0)

Report

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 46,614 User Group Leader on at

Like (0)

Report

RE: Unable to View the SSRS Reports in Visual studio

You may mark the thread as completed.
Suggested answer

Raghavendar 995 on at

Like (0)

Report

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 995 on at

Like (0)

Report

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 3,905 on at

Like (0)

Report

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 46,614 User Group Leader on at

Like (0)

Report

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 46,614 User Group Leader on at

Like (0)

Report

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 995 on at

Like (0)

Report

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 46,614 User Group Leader on at

Like (0)

Report

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