Alfasith AX

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

Wednesday, June 18, 2014

Expression to get the line no or Serial no in SSRS

Hi,

=RunningValue(Fields!ItemId.Value, CountDistinct, "Tablix9")
Here I used ItemId as unique and table name is Tablix9;

Regards,

Sunday, June 15, 2014

How to call job to another job in axapta using x++ code

Hi,

1. Create simple job Job2  and add it to action menu item.
2. Call Job2  in other Job1 using following code.

   Args                    args; 
    ; 
    
    args = new Args(); 
    args.name(identifierStr(Job2  )); 
    new menuFunction(menuItemActionStr(Job2 ), MenuItemType::Action).run(args);
//Here Job2 in last line is the name of the menu item and in above that is name of the job

Regards,

Get a table ID in SQL - D365

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