Diffrent Type of Joins and Linked Type in AX 2009

Car Table

CarId	ModelYear	CarBrand	Model	Mileage	ModelYear	CarId
CA101	2008	Mahindra	Scorpio	15	2008	CA101
CA102	2009	Suzuki	800	12	2009	CA102
CA103	2007	Hundai	i20	5	2007	CA103
CA104	2007	Toyato	Inova	3	2007	CA104
CA105	2009	BMW		5	2009	CA105
CA106	2010	Benz	AZ12	10	2010	CA106

Rental Table

RentalId	CustAccount	CarId	FromDate	ToDate	ToDate	FromDate
RE101	1104	CA101	10/12/2010	10/29/2010	10/29/2010	10/12/2010
RE102	1102	CA102	11/17/2010	12/14/2010	12/14/2010	11/17/2010
RE103	1203	CA103	11/24/2010	12/15/2010	12/15/2010	11/24/2010
RE104	1301	CA104	12/10/2010	1/5/2011	1/5/2011	12/10/2010
RE105	1304	CA101	1/3/2011	1/18/2011	1/18/2011	1/3/2011
RE108	1303
RE107	1202
RE106	2024	CA103	1/10/2011	1/29/2011	1/29/2011	1/10/2011

Inner Join

Select records from main table that have matching record form join table.

Main table record and join table records are joined together  and show as single record.

Code                                                                                                              

static void JoinExamples(Args _args)                                                                        

{                                                                                  

    CarTable carTable;                                                                        

    RentalTable rentalTable;                                                                           

    ;                                                                              

    while select carTable join rentalTable                                                                              

        order by carTable.CarId                                                                        

        where carTable.CarId == rentalTable.CarId                                                                             

                                                                                   

        {                                                                          

            info(strfmt("Car id is %1 renatla id is %2",carTable.CarId, rentalTable.RentalId));                                                                         

        }                                                                          

}

           

Output                                                                       

SSRS report in 2009 Ax Precision Design

open the auto design and right click on the Auto design and convert to precision design
there we can find out the all code .
based on our requirement we can  do all the changes and deploy the design .
open the solution explore and right click and save to AOD.

After adding the changes open the AOT and open the particular report in the SSRS reports and deploy it .

open the menu item in the properties object name is (reportname.precisiondesign1).
and run the report we can get our expected result .


Thanks..

Dynamics Axapta 2012 License information and configuration video

Hi by clicking below  link it will open youtube and can view the AX 2012 Licence information and configuration.

https://www.youtube.com/watch?v=AVKzNsfqdWc

What is Layers in Axapta 2012 and Why layer concept in ax

Layers in Axapta

It holds all elements that are displayed in the AOT

Total 8 application layers are available, all layers are a hierarchy of levels in the application, 

and application modification and deletion are not interfering in the next lower level

Current level application modification are overshadow to the element on a lower level

Only top level version of an application element used when application is compiled

Below layers available to Customer and Partners

Usp    User layer for specific functionality and customization                         

Usr  

                                 

Cup                       

Cus Customer Layer    

 

Below layers available to partners and independent software vendor (ISV)

Vap  value added reseller layer – customized solution, developed by VAR’s

Var                        

Isp  independent software vendor layer

Isv

Slp  Solution layer, Microsoft endorsed industry solution

Sln

Below layers available from Microsoft to deliver base application

Fpp  Feature pack layer, control by Microsoft

Fpk

Glp  Globalization layer, developed for some countries

Gls

Syp  System layer, lowest layer where STD application developed, includes core application

Sys

Layers are benefits in terms of

Protection of source code

It keeps separate from modification

On Sys, GLS and FPK layers only Microsoft dynamics ax development team can work

Converting amount into word formate in ax 2012

Converting amount into word formate in ax 2012:
 tmpStr = numeralsToTxt(5500));
At first declare a global string variable in the report and asign value in this variable like the following....

tmpStr = numeralsToTxt(5500));

 Here 5500 is a argument I passed for better understanding, here you will pass the amount variable and then "tmpStr" returns through a Display method.

How to stop dragging table in visual studio Design or SSRS report ?

I finally figured this out. A rectangle works as a container for data regions.
 If I place the table into a rectangle, it will only grow within the boundaries of the rectangle,
without pushing other report items around. In order for this to work, though,
 the table must be a child control of the rectangle.
 This is achieved by dropping a new table into an existing text box,
or by dropping an existing table some place outside of the rectangle,
then moving it back inside. If you just draw a rectangle around the table,
 it will not become a child. This can be verified by right-clicking on the table.
If it only says "select body" and not "select rectanglex" as well, it is not a child of the rectangle. Alternatively, it is possible to place other items (text boxes, etc into a rectangle that is on one side of a table. The top edge of the rectangle must be above the bottom edge of the table. Then any controls in the rectangle will be unaffected by the growth of the table, but other items below the table will.

Thank You..

Cannot execute a data definition language command on (). The SQL database has issued an error in ax 2012

Step 1 – Synchronize the SQL database

1. Navigate to Administration module -> Periodic -> 'SQL Administration'
2. Select the table and click table actions check/synchronise
   1. Sometimes you will not be able to determine which tables are causing the error so just do this for all
3. Click 'Start' with the default options.
    

Step 2 – Step 1 with 'Remove unknown indexes' in the check/synchronise step

1. Follow steps 1 and 2 from step 1

Step 3 – Check the Event Viewer (SQL and AOS box)

1. This should give you a good indication on where to go for the issue going forward as there could be index violations.