Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Wednesday, June 26, 2019

Getting current user languague in SSRS in AX 2012

Hi,

=iif(Parameters!AX_RenderingCulture.Value = "ar",FALSE,TRUE)

Note:  No needs to validate using controller class or passing the values in DP class for this.

In my case, I needs to change the order ofcolumn of the table in SSRS without reference to arabic from right to left and rest left to right.

So I added visibity based on expression on both the lines as Arabic and rest

Monday, June 17, 2019

Get the current user worker Information

Hi,

this.ChangedBy = HcmWorker::find(DirPersonuser::findUserWorkerReference(curUserId())).RecId;

Regards,

Get a table ID in SQL - D365

Hi select ID from SysTableIdView where  SysTableIdView .Name = 'CustTable' Regards,