=Microsoft.Dynamics.Framework.Reports.DataMethodUtility.
GetFullCompanyNameForUser(
Parameters!AX_CompanyName.Value,Parameters!AX_UserContext.Value)
GetFullCompanyNameForUser(
Parameters!AX_CompanyName.Value,Parameters!AX_UserContext.Value)
Monday, March 13, 2017
Saturday, March 11, 2017
Serial Number in SSRS ( Normal and with Group)
we can get the sequence number directly in SSRS report directly by below code in text box expression. it's basically depends on row number so you can get it from expression - Common Function -Miscellaneous - row Number.
=RowNumber(Nothing)
The challange to use this expression is when we will use grouping in same table. Sequesnce of the number can be disturb by grouping. We can handle it by below code.
=Runningvalue(Fields!Name.value,countdistinct,"Dataset1")
** Here field name is the actual field which we are using in grouping with database name.
=RowNumber(Nothing)
The challange to use this expression is when we will use grouping in same table. Sequesnce of the number can be disturb by grouping. We can handle it by below code.
=Runningvalue(Fields!Name.value,countdistinct,"Dataset1")
** Here field name is the actual field which we are using in grouping with database name.
Wednesday, March 1, 2017
Address in one line in AX or SSRS
=Replace(First(Fields!VendAddress.Value, "PurchPurchaseOrderDS"),Chr(10),", ")
Subscribe to:
Posts (Atom)
Conversion of Disposition code, code was not specified - Error in D365 F&O for inter company purchase order return
We crated the return order for inter company purchase order and created a Item Arrival Journal through Arrival Overview in corresponding c...
