通过

CRM 4.0 report rendering issue under SQL 2008 R2

  • 项目

Summary
If you run CRM 4.0 in combination with SQL SRS 2008 R2 you might face the following issue. When you change the font size of a standard (or custom) report (e.g. from Tahoma size 8 to Arial size 15), the changes will not be reflected. The report will be rendered without changes (fallback to Tahoma size 8).

This problem occurs in standard and custom reports, but only for hyperlink fields. Normal text fields will be rendered correctly.

The rendering issue occurs independent from the way a report will be modified. This could be done e.g. via Report Builder, via Visual Studio or via direct modification of the RDL file.
 

Workaround
Per our research we could narrow down the issue to the following point. It seems that the problem happens due the fact that the line spacing is set to an incorrect value (e.g. 1), which will then result in a fallback. To avoid this problem you can change the line spacing from “use font size” to “custom”. To do this via Report Builder mark the element you want to change and double click or choose “Properties” and then “Font”. Choose a value that is the same or higher than the font size value. Best results are displayed when you choose the custom line size 2pts higher than the font size (e.g. set Arial with font size 16 and line spacing of 18 pts).

image

 

How to repro
1. Install Windows Server 2008 and SQL 2008 R2 on one machine (same behavior in split environment).
2. Install all available important updates on Microsoft Update
3. Install CRM 4.0 and latest Update Rollup
4. Install Microsoft SQL Server 2008 R2 Report Builder 3.0
   https://www.microsoft.com/downloads/en/details.aspx?FamilyID=d3173a87-7c0d-40cc-a408-3d1a43ae4e33&displaylang=en
5. Open any standard report in Report Builder (e.g. user summary report with GUID {9bbb38ec-9c9d-df11-8330-00155debbb0e}) and change the font size for e.g. the fields “e-mail” and “user”. Once done save the changes.
6. Launch CRM 4.0 and run the modified report. In our sample we modified the user summary report.

Result
The user field will be rendered using the correct font, but the e-mail field will still be rendered using the old font (fallback to default).

 

Greetings from the CRM team