Add new fields to existing service table

when adding a new field for exiting service, we need to perform following steps to make the new field available in Visual Studio
1. Update service

- in dev window, go to Tools, AIF, update Document service
- give the service name and put the service operation as required
- select Regenerate data object and AxBC classes

2. Register service check

- Right click service, go to Addins,Register service
- select service, click on service operation button,
- in service operation window click parameter schema
- in parameter schema window, click view schema and check if your new field is mentioned or not

3. Inbound port deactivate/activate

- go to system administration, setup, Services and Application Integration Framework, Inbound/Outbound port
- select the port name and click on deactivate button
- click on service operation button on the right
- check your service is listed or not
- activate the port

4.Refresh service reference in Visual studios

- go to solution explorer
- right click on service reference and select Update service reference
- Build the project

how to handle visibility of controls in SSRS report

Sometimes we wish to hide the control(in order to reduce space) if the control field value is null or empty. Use the below steps:

1. Open the report project in Visual Studios
2. Go to report design
3. Right click on the control and go to properties

4. select visibility tab and add the condition

=iif(Fields!fieldName.Value = "",True,False)

5. Save, rebuild and deploy report.

One or more conflicting model elements already exists in an installed model

If you get this error while importing AX model file, there is a simple work around for this to use  /conflict:Push

 

this will allow the model files to be imported.

axUtil import /file:"D:\DataMigrationFrameWork.axmodel" /conflict:Push

X++ LIKE operator

We can use like operator in x++ as below:

static void LikeTest()
{ 
    str str;
    ;
    str="expiry";

    if(str like "exp*")
       info('"like work ");
}

 

Microsoft Dynamics AX 2012 Build numbers

Dynamics AX iPhone app

Microsoft has released a new Dynamics AX iPhone app for use with Microsoft Dynamics AX 2012 R2.

 

https://itunes.apple.com/us/app/dynamics-ax/id663448683?mt=8&ign-mpt=uo%3D4

Performance tip: Caching display method

One significant side-effect of using display methods can be the impact on performance. Particularly when complex methods are used to calculate values being shown on grids, a visible slow-down in form performance can be experienced. This is largely due to the fact that the methods are often run repeatedly even when no reason is apparent and the values are unchanged.

To alleviate this, display methods on tables can be cached by using the cacheAddMethod method of the datasource object. To enable caching of a display method, call cacheAddMethod() from the init method of the datasource. This ensures that the display will only be calculated when necessary and can result in a significant performance improvement.

 

public void init()

{

    super();

 

    // Enable caching of the document handling display fields

    dirPartyTable_ds.cacheAddMethod(tablemethodstr(DirPartyTable, primaryPhone));

}

how to set temporary table data based on the table type of the temporary table

§  For InMemory tables, by using either the setTmpData() method or by directly assigning the buffers to each other.

§  For TempDB tables, the linkPhysicalTableInstance() method replaces the setTmpData() call.

 

how to delete a parameter from SSRS report

Follow below steps if you wish to delete a parameter from the SSRS reports

1. delete parm method from the Contract class
2. delete from the parameter node in the VS project
3. refresh the dataset
4. rebuild, deploy and add to AOT
5. restart SSRS services
6. Delete cache

Cannot debug SSRS reports in AX 2012

Sometimes we need to debug SSRS reports, in my case I had added a new param method in contract class to display a new test box in report dialog window, which I needed to debug as  the data was not getting displayed in report.

I changed the class I was extending my report from SRSReportDataProviderBase to SrsReportDataProviderPreProcess, and changed back to the original class when the debug was complete.

This is not a clean way to do debugging, however it helped me with many of my SSRS reports in AX 2012.