Hi
If you want to setup a different Format Date on a SSRS report, you can follow the below options:
1- Modify date format for all date textbox present in the SSRS Report using the Format function, like =Format(Fields!TransDate.Value, "dd/MM/yyyy")
2- If you want follow the User Timezone, for all date textbox you can use ConvertUtcToAxUserTimeZoneForUser method, like =Microsoft.Dynamics.Framework.Reports.DataMethodUtility.ConvertUtcToAxUserTimeZoneForUser(Parameters!AX_CompanyName.Value, Parameters!AX_UserContext.Value, =Fields!TransDate.Value, "d", Parameters!AX_RenderingCulture.Value)
Or
=Microsoft.Dynamics.Framework.Reports.BuiltInMethods.ToDisplayStringDate(Parameters!AX_RenderingCulture.Value, Date Field value, "d")
More details at https://technet.microsoft.com/en-us/library/dn275971.aspx?f=255&MSPPError=-2147217396
Enjoy!
If you want to setup a different Format Date on a SSRS report, you can follow the below options:
1- Modify date format for all date textbox present in the SSRS Report using the Format function, like =Format(Fields!TransDate.Value, "dd/MM/yyyy")
2- If you want follow the User Timezone, for all date textbox you can use ConvertUtcToAxUserTimeZoneForUser method, like =Microsoft.Dynamics.Framework.Reports.DataMethodUtility.ConvertUtcToAxUserTimeZoneForUser(Parameters!AX_CompanyName.Value, Parameters!AX_UserContext.Value, =Fields!TransDate.Value, "d", Parameters!AX_RenderingCulture.Value)
Or
=Microsoft.Dynamics.Framework.Reports.BuiltInMethods.ToDisplayStringDate(Parameters!AX_RenderingCulture.Value, Date Field value, "d")
More details at https://technet.microsoft.com/en-us/library/dn275971.aspx?f=255&MSPPError=-2147217396
Enjoy!
4 comments:
Thank you very much, been searching for this solution for a while. Many many thanks
Thank you! Exactly what I was looking for.
Too Good article ,Thank You For Sharing.
Keep Updating...
Microsoft BI Training Online
nice information ............!
msbi course training
Post a Comment