Hi everyone,
I'm working with SSRS reports connected to Dynamics 365 / Business Central, and I'm facing an issue with rendering Unicode symbols in the report output.
I have a field called Unit_Of_Measure_Code that contains special unit symbols, such as:
-
℃ (degree Celsius – Unicode 8451)
-
μg (microgram – Unicode 181 or 956)
-
Ω (ohm – Unicode 937 or 8486)
These symbols are correctly stored in the Dynamics database and render perfectly in SQL or debugging expressions.
🔍 What I’ve Verified:
-
Field Expression Used: =IIf(IsNumeric(Fields!Results.Value), Fields!Unit_Of_Measure_Code.Value, ""
-
Font Settings: All fonts used in the report are set to Arial, which is Unicode-compatible.
-
Database Encoding: The data is stored correctly — verified using this expression: =Join(Array.ConvertAll(Split(Fields!Unit_Of_Measure_Code.Value, ""), Function(c) AscW(c).ToString()), ", ")
For example, ℃ returns Unicode 8451.
❗ Problem:
-
In Report Viewer and exported PDFs, the symbols: Either show up as empty boxes (□) Or are not rendered at all
-
Example: If the value is "168.5 ℃", only "168.5" is displayed — the degree symbol is missing or replaced with a box.
If anyone has faced similar issues or has found a workaround to force Unicode symbols like ℃, μg, or Ω to render correctly in SSRS (especially when exporting to PDF), I’d really appreciate your insights.
Thanks in advance!
