Microsoft Dynamics AX (Archived)

The SSRS report ******* cannot be found in the AOT.

(1) Share

Report

Posted on by Community Member

Hi All

Today I tried to learn and make a simple report in Ax 2012

So I have search on the internet for any information about developing reports

I have follow this

https://technet.microsoft.com/en-us/library/cc636713.aspx

every thing is fine till the deploying
when I try to deploy it I get error as below

The SSRS report ******* cannot be found in the AOT.

Did I miss something ?

I think the problem is when save the report on other location or not incloud the new report to SQL maybe ? if yes how can I do it ?

I'm using VS 2013

Ax 2012 R3

regards

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Hi,

Again deploy from visual studio, and add your report to AOT.

You can find add to AOT on report model, so the report will be added to AOT.

Thanks

Suresh

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

Like (0)

Report

if this is a customized newly developed report, make sure that your VS is pointing to correct server. it will deploy report to the server towards which it is pointing to.

Was this reply helpful? Yes No
Suggested answer

Faisal Fareed 10,796 User Group Leader on at

Like (0)

Report

Hi AbdalRahman,

There might be a possibility that your visual studio is not pointing to correct AX 2012 AOS server and your report is deploying to wrong AOS. You can check this by deploying report in visual studio and in build result window in visual studio it will show you the report server where report got deployed. Check that report server address and check this one in AX | System Administration module | Setup | report server it should be same.

If you want to configure Visual Studio with correct AX AOS this link may help you daxture.blogspot.com.au/.../configure-visual-studio-to-connectopen.html

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

Let's breakdown this into 3 as high level, (This is the summary)

1. Create the query in AOT

2. Develop the report in VS

3. Create the UI

1. Create the Query in AOT

1.1, Add the table to query. AOT>Queries>Data Source

1.2, Add the fields to Data Source. AOT>Queries>Data Source>Fields

1.2.1, Define the relationships if you have more than one Data Source.

2. Develop the report in Visual Studio ( 4 Steps = Report/Build/Add/Deploy)

2.1, Create a new project in the VS. File>New>Project>DAX>Report Model

2.2, Create the report with Solution Explorer SE>Add>Report

2.3, Define the Properties & AX Data Set; Data Source Type=Query| Name="Name of your Query"

2.4, Create the report design and Add a Table (Drag & Drop the Data Set from the Report)

2.5, Build the report from the Solution Explorer

2.6, Add the report to AOT

2.7, Deploy the report to AX

3. Create the UI in AX

3.1, Create the Menu Output item in the AX

3.2, Apply the appropriate Menu Output Properties

Object Type = SSRS Report

Object = "Name of your report"

3.3, Select the dataset and run the report.

This is a brief summary. If you follow these steps you should be able to see your report in the AOT. You will find,

Your Query under the Query node

Your Report under the SSRS Reports node

and your UI under the Menu Output.

Was this reply helpful? Yes No