• Skip to main content
  • Skip to primary sidebar
  • Skip to secondary sidebar
  • Skip to footer
  • Home
  • About
    • linkedin
    • twitter
  • Archive
  • Technical youtube Channel
  • Recommended Readings
  • Free Courses
    • Fixed Asset management Course
    • Financial Modules

Ali Raza Zaidi

Musing's of ERP Consultant

Dynamics Ax 2012: Very simple report in dynamics ax 2012

January 29, 2013 by alirazazaidi

There two common and mostly used ways to develop reports in dynamics Ax 2012

  1. Query
  2. Report data Provider.

 

Here we have to create a very simple report using AOT query. For this purpose I have create a custom table Student with 4 fields as

  1. Rollnumber
  2. First Name
  3. Last Name
  4. Address

The sample data in custom table is as follow.

SampleData

 

 

Now we create a new Query in AOT which will be used in our Report to get data from AX to display on report.

In Query node of AoT create a new query Named it StudentsQuery.

Right click and on data source click on add new data source and on property window select or right Student table as follow.

StudentQueryDataSource

 

Click on Fields and from property window dynamics to yes.  Like as

Dynamic Fields

 

 

Now open a new  Project In Visual studio 2010. Select form Install templates  select Dynamics and then Report Model

Report Model

 

Now next step to add a new report in newly created Report Model project

I named it simple student report.

Now right click on Dataset and add a new dataset in report and Name it StudentDs and from property of data set you have set following property

DataSetProperty

 

 

Click on Query and form dialog box you have to search and select Query selected Query form Dynamics Ax. In this report we created the query with StuentsQuery. On selecting and press next a new dialog open you from here you can select fields required for report in this report we are just use 4 fields

DsStudent

 

 

 

After selecting field now create a new precision design.  Add new table and drop the field on column of table as follow. Press on review pane you find result like as

Report Result

 

 

 

Related

Filed Under: Dynamics AX 2012, Dynamics Ax 2012 Reporting SSRS Reports., X++ Tagged With: Dynamics Ax 2012, Dynamics Ax 2012 Reporting SSRS Reports.

Primary Sidebar

Categories

  • .net framework 2 (24)
  • Accounts Payable (2)
  • AIF Services (6)
  • Ajax (2)
  • asp.net 1.1 (17)
  • asp.net 2 (42)
  • BAM (2)
  • BizTalk (24)
  • Biztalk 2010 (51)
  • BizTalk Errors (10)
  • Biztalk Tools (6)
  • Biztalk White Paper (2)
  • Books (6)
  • Business Intelligence (4)
  • c# (28)
  • Certification Guide (3)
  • Channel 9 Video (2)
  • Customization Tips for D365 for Finance and Operations (54)
  • D365OF (50)
  • Data warehouse Concepts (3)
  • Database Concepts (3)
  • Deployment Errors (5)
  • Dynamics 365 (49)
  • Dynamics 365 for finance and operations (116)
  • Dynamics 365 for Operations (131)
  • Dynamics AX (AX 7) (133)
  • Dynamics AX 2012 (274)
  • Dynamics Ax 2012 Forms (13)
  • Dynamics Ax 2012 functional side (15)
  • Dynamics Ax 2012 Reporting SSRS Reports. (30)
  • Dynamics Ax 2012 Technical Side (50)
  • Dynamics Ax 7 (64)
  • ESB toolkit (4)
  • Exam MB-330: Microsoft Dynamics 365 Supply Chain Management (6)
  • Favorites (12)
  • Financial Modules (6)
  • Functional (6)
  • Lifecycle Services (1)
  • Management Reporter (1)
  • Microsoft Flow (3)
  • MS Dynamics Ax 7 (63)
  • MVP summit (1)
  • MVP summit 2016 (1)
  • New Dynamics Ax (19)
  • Non Defined (9)
  • Power Apps (3)
  • Power BI (12)
  • Power BI Desktop (8)
  • Power Platform (6)
  • Procurement (3)
  • procurement and sourcing (3)
  • Product Information Management (1)
  • Product Management (1)
  • Production Control D365 for Finance and Operations (8)
  • regular expression (3)
  • Sale Order Process (8)
  • Sale Order Processing (8)
  • Sales and Distribution (5)
  • Snagit 2021 (1)
  • Software developer (1)
  • SQL Server 2008 (18)
  • SQL Server 2012 (3)
  • SQL Server 2019 (5)
  • SQL Server and TSQL (5)
  • Sql server reporting services (7)
  • SSIS (13)
  • Tips and tricks (275)
  • TSQL (17)
  • Uncategorized (38)
  • Upgrade (1)
  • VB.net (2)
  • Web Cast (7)
  • White papers (4)
  • Windows form (3)
  • X++ (142)

Secondary Sidebar

Footer

Tags

AIF Aif Services Apps for Dynamics 365 for Operations asp.net AX 7 BizTalk 2010 Biztalk 2010 tips and tricks BizTalk Errors Biztalk Tools c# Customization in Dynamics 365 d d365 for finance and operations D365 for Operations Dynamic AX 2012 Dynamics 365 for finance and operations Dynamics 365 for Operations Dynamics Ax Dynamics Ax 7 Dynamics Ax 2012 Dynamics Ax 2012 development 2 Dynamics Ax 2012 functional side Dynamics Ax 2012 R3 Dynamics Ax 2012 Reporting SSRS Reports. Dynamics Ax 2102 Dynamics Ax tips and tricks Exam MB-330: Microsoft Dynamics 365 Supply Chain Management Excel Add ins financial Dimension Microsoft Dynamics 365 for Operations MSDYN365FO New Dynamics Ax Power BI Power BI tutorial procurement in dynamics ax 2012 Product Management Sales and distribution SQL Server 2008 SSRS Tips and tricks TSQL url regular expression WorkFlow in AX X++ X++ tips

Copyright © 2022 · Magazine Pro On Genesis Framework · WordPress · Log in