-

To get a serial Number in a Table while Grouping in SSRS Report  - D365

write this expression in the Text Box


=RunningValue(CountDistinct("Tablix3"),Count,"Tablix3")

Comments

Post a Comment

Popular posts from this blog

How to Calculate Planned Purchase Order

-
How to Calculate Planned Purchase Order class SMCPlannedPOCalc {            /// <summary>     /// Runs the class with the specified arguments.     /// </summary>     /// <param name = "_args">The specified arguments.</param>     public static void main(Args _args)     {         ReqTrans reqTrans;//reftype,refdate,itemid         ItemId   _itemId = "Test-SMK1010";         TransDate _date = str2Date("10/1/2019",213);         real qty;         select sum(qty),count(RecId) from reqTrans             where reqTrans.ItemId == _itemId             && reqTrans.RefType == ReqRefType::ItemPlannedOrder             && reqTrans.ReqDate == _date;       ...
Read more

Running the SSRS Report and Saving in Local drive using X++ Code with renaming the same report next Occurrence in AX 2012

-
Running the SSRS Report and Saving in Local drive using X++ Code with renaming the same report next Occurrence in AX 2012 Write the below code in Controller Class  of the Report public static void main(Args _args) {     //KKSalesPackingSlipController controller = new KKSalesPackingSlipController();     //controller.parmReportName(ssrsReportStr(KKSalesPackingSlipReport, PrecisionDesign2));     ////controller.parmReportName(ssrsReportStr(KK_CustInvReport, Report));     //controller.parmArgs(_args);     //controller.startOperation();     LogisticsAddressCountryRegionId     logisticsAddressCountryRegionId;     SrsReportRunController              controller = new SrsReportRunController();     SRSPrintDestinationSettings         printSettings;     KKSalesPackingSlipContract          c...
Read more

How to calculate On Hand Inventory Per Day

-
How to calculate On Hand Inventory Per Day class KK_OnHandPerDay {            /// <summary>     /// Runs the class with the specified arguments.     /// </summary>     /// <param name = "_args">The specified arguments.</param>     public static void main(Args _args)     {                ItemId itemId;         InventTrans inventTrans;         InventDim inventDimCriteria, inventDimLoc;         InventDimParm inventDimParm;         InventSumDateDim inventSumDateDim;         TransDate start, finish;         int c;         int onHandTotal;         InventLocationId inventLocationIdLoc;         start = str2date("6/24/2019", 213);//3/12/2019    ...
Read more