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

I have the same question (0)

All responses (10)

Answers (2)

Verified answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

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

Was this reply helpful? Yes No
Raghavendar 995 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

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)

Was this reply helpful? Yes No
Suggested answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

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

you have to only install BIDS components from setup.

Was this reply helpful? Yes No
Douglas Noel 3,905 on at

Like (0)

Report

Hi all,

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

regards

Douglas

Was this reply helpful? Yes No
Raghavendar 995 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Raghavendar 995 on at

Like (0)

Report

Thank you Mr.sohaib

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

Now I am able to Edit the Reports.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

You may mark the thread as completed.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No