topic Re: PBI Report Server doesn't render correct font for groups that toggle hidden fields in Report Server

PBI Report Server doesn't render correct font for groups that toggle hidden fields

Carli — Thu, 10 Aug 2017 14:24:07 GMT

In paginated reports where I added groups that can be used to toggle hidden fields, the font and fontcolor of those groups is not displayed correctly.
I use a XML dataset which holds the fonts and colors I want to use in my reports. When I preview the report in Visual Studio, Report Builder or SharePoint everything looks fine, but when I deploy it to SSRS PowerBI I see a font that looks like Times New Roman instead of Segoe UI that it's supposed to show. The fontcolor is black, while it should be red. It does show the correct backgroundcolor.
When I do not use the dataset to render the font and just add Segoe UI in the textbox properties everything works fine.

Example

Is this a bug or am I missing something?

Re: PBI Report Server doesn't render correct font for groups that toggle hidden fields

Jon-Heide — Thu, 10 Aug 2017 22:30:15 GMT

Hi Carli - are you using HTML styling from the database? Or are you parsing an XML file from the DB and setting those as expression based styles?

Note that RB and and VS in preview render through GDI and the server through HTML in the browser. In some cases the fonts avaialble can be different (ensure the appropriate fonts are installed on the server and clients). Also attaching the RDL can be helpful to diagnose.

Re: PBI Report Server doesn't render correct font for groups that toggle hidden fields

Carli — Fri, 11 Aug 2017 10:26:50 GMT

Thanks for your reply Jon-Heide.

I am using expression based styles from an XML file.

If the font wasn't installed wouldn't I have problems with all textboxes in which the font is used? I only have problems with the toggle-textboxes.

I will try to attach the RDL-file. I'm new here so I have to find out how to do that. Or do you want me to post the code here?

Re: PBI Report Server doesn't render correct font for groups that toggle hidden fields

dianaschnuth — Tue, 10 Jul 2018 15:26:03 GMT

I'm having the same issue, except I'm pulling the FontFamily value from a relational database and setting it in the cell as an expression. I did find that hardcoding the font family resolved the issue, but this is not an ideal long-term solution. Is there a fix in the works for this?

Re: PBI Report Server doesn't render correct font for groups that toggle hidden fields

dianaschnuth — Tue, 20 Nov 2018 21:06:54 GMT

I forgot that I'd already had this problem, and found my own reply when searching online for a solution. 🙂

Anyone else experience this? Any solutions?

Re: PBI Report Server doesn't render correct font for groups that toggle hidden fields

ruzickaf — Tue, 19 Feb 2019 10:17:49 GMT

Although this message is quite old, I'm also still facing the same problem. However, I haven't found any solution across entire internet. If I design a paginated report using Visual Studio 2012 then the rendered result will look correct. On the other hand, if I deploy the same report (RDL file) into the Power BI Report Server (ver. 1.4.6969.7395 January 2019), every textbox in the role of group header - toggle item (expand/collapse provided by sign +/-) is rendered incorrect in browser IE 11. I've already read here about different rendering engines (GDI in VS vs. browser) but I really would like to know how to figure out this problem.

Any ideas are highly appreciated!

Incorrect group rendering in the PBIRSCorrect group rendering in the VS2012

Re: PBI Report Server doesn't render correct font for groups that toggle hidden fields

ishazel — Tue, 12 Mar 2024 00:04:34 GMT

This is still happening. In 2024.

Re: PBI Report Server doesn't render correct font for groups that toggle hidden fields

shineme1981 — Fri, 14 Mar 2025 13:46:23 GMT

This is still happening in 2025.

Re: PBI Report Server doesn't render correct font for groups that toggle hidden fields

ishazel — Fri, 14 Mar 2025 15:14:35 GMT

Microsoft is just a small little startup, sometimes it takes a decade to fix an issue, that's just how it is with small companies ya know 🙄