Dynamics Community Forum Thread Details

LedgerTransListAccount SSRS Report – TransDate format conversion to Arabic Hijri Format

We are customizing the LedgerTransListAccount SSRS report in D365FO. The issue we face is with the TransDate field:

When the user preference (SysUserSetup) is set to Arabic (ar), most labels and text in the report correctly display in Arabic.
However, the TransDate field continues to render in English digits (e.g., 18/09/2025) instead of Arabic-Indic digits (e.g., ١٨/٠٩/٢٠٢٥

What we tried:

Using expressions like =IIF(Left(User!Language,2)="ar", …) with manual replacements of digits → works partially but feels like a workaround

Changing the report Language property on the textbox of TransDate as "ar"
Direct formatting with Format(Fields!TransDate.Value,"dd/MM/yyyy") → forces English digi

What we want:

The TransDate field should automatically respect the report rendering culture (e.g., Arabic users see Arabic digits without manual replacements)

Has anyone successfully configured date fields in SSRS reports (specifically in D365FO LedgerTransListAccount) to render Arabic digits automatically when the user’s language is ar?

Do we need to change the report or textbox Language property differently?
Or is there another way to make SSRS use ar-SA culture for date formatting, without hardcoding replacements.