-

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

[AX2012] Get Email for Customer / Vendor (with specific roles)

-
Get Email for Customer / Vendor (with specific roles) static void KK_Email (Args _args) {     DirPartyLocation dirPartyLocation;     LogisticsElectronicAddress elecAddress;     LogisticsElectronicAddressRole elecAddressRole;     LogisticsLocationRole locRole;     Email   email;               while select dirPartyLocation         where dirPartyLocation.Party == 22565427693     {         while select elecAddress             where elecAddress.Location == dirPartyLocation.Location             && elecAddress.Type == LogisticsElectronicAddressMethodType::Email         {             while select elecAddressRole                 where elecAddressRole.ElectronicAddress ...
Read more

How to run Our Design in SalesPackingSlip Standard SSRS report?

-
How to run  Our Design in SalesPackingSlip Standard SSRS report? To run our Design in a standard SSRS Report(SalesPackingSlip), do this in the controller class. //Class Declaration Part in the controller class     MenuItemName                    reportChina;     #define.chineseReport('SalesPackingSlipOriginal')     #define.reportDesign('SalesPackingSlip.ReportNew') //outputReport Method in controller To run the report protected void outputReport() {     if (this.parmReportChina() == #chineseReport)     {         this.parmReportName(#reportDesign);         this.parmReportContract().parmReportName(#reportDesign);         formLetterReport.parmReportRun().settingDetail().parmReportFormatName(#reportDesign);     }     super(); } //parmReportChina Method in controller To set a...
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