Enter data from new line in SSRS and Formula in D365fo

 =Format(Fields!QuotationDate.Value, "MMM-dd yyyy") & Microsoft.VisualBasic.Constants.vbcrlf & Microsoft.VisualBasic.Constants.vbcrlf & Fields!CustomerName.Value & Microsoft.VisualBasic.Constants.vbcrlf & Fields!CustomerAddress.Value

 =Format(Fields!QuotationDate.Value, "MMM-dd yyyy") & vbcrlf & vbcrlf & Fields!CustomerName.Value & vbcrlf & Fields!CustomerAddress.Value

=Fields!PurchOrderDocNum.Value & vbcrlf & Format(Now(),"dd/MM/yyyy")

=IIF(Fields!CompLabelPrice.Value = "0.00",Nothing, Format(Fields!CompLabelPrice.Value, "#,0.00;(#,0.00)")) & " /-"

--------------------------------------------------------------------------------------------------------

To Get user specific date time on report

-

=Microsoft.Dynamics.Framework.Reports.DataMethodUtility.ConvertUtcToAxUserTimeZoneForUser(Parameters!AX_CompanyName.Value, Parameters!AX_UserContext.Value, System.DateTime.UtcNow, "d", Parameters!AX_RenderingCulture.Value) & vbCrLf & Microsoft.Dynamics.Framework.Reports.DataMethodUtility.ConvertUtcToAxUserTimeZoneForUser(Parameters!AX_CompanyName.Value, Parameters!AX_UserContext.Value, System.DateTime.UtcNow, "t", Parameters!AX_RenderingCulture.Value)

--------------------------------------------------------------------------------------------------------

Print every word with new line

=Replace(Fields!Text2.Value," ", System.Environment.NewLine)

--------------------------------------------------------------------------------------------------------

Print Page number on SSRS in D365 FO

Visual studio expression to print page number on every pages of report

 ="Page "&Globals!PageNumber &" of "&Globals!TotalPages

Insert User ID in All user group in D365fo

 Assign user id in All user group in D365 FO

insert into USERGROUPLIST ( USERID, GROUPID)

select 'anant.dubey', GROUPID from USERGROUPLIST where GROUPID not in (select GROUPID from USERGROUPLIST where USERID = 'anant.dubey') group by GROUPID