If you’ve migrated from FRx to Management Reporter, you may have noticed there may be some fonts that are not available on the system.
The migration report may show that all fonts migrated successfully but when you open a Row Definition or Column Definition you may receive an error that the font cannot be found.
This will then crash Report Designer with the following error:
To resolve this error:
Open SQL Server Management Studio and connect to the ManagementReporter database.
Run the following script: (replacing ‘FONTNAME’ with the font name in the error message) to see how many objects are using the font in the error message.
Select * from ControlFontStyle where FontName = ‘FONTNAME’
Now run the following script to update all the instances of the font causing an error with a common font, for example Arial. (Replacing ‘OLDFONT’ with the font name from the error message and ‘NEWFONT’ with ‘Arial’ (or another common font))
UPDATE ControlFontStyle SET FontName = ‘OLDFONT’ WHERE FontName = ‘NEWFONT’
This next step is key, I have seen other posts just stop here but when opening the Row Definition or Column Definition that had the ‘bad’ font the error still occurs.
Open Management Reporter Configuration Console and restart the Management Reporter 2012 Application Service.
The font error should be resolved now.
As a side note, you will have to check in the item that had the error. If you still have issues or questions, feel free to contact us at Boyer & Associates. Or if you feel you’d like additional training on Management Reporter, be sure to check out our 2-day MR session we are holding on Dec. 18 and 19 at our headquarters.