Skip to main content
T
tuhler
February 6, 2024
Solved

Availability to add a custom font to PDF export

  • February 6, 2024
  • 2 replies
  • 0 views

We have a client with a custom font that they would like to apply to reports that are exported to PDF. Has anyone come across this as an option?

Thank you

Best answer by JackLacava

Easier than you might expect:

  1. install the font in Windows on OneStream servers (app and web)
  2. specify it in your format properties: FontFamily = [My Custom Font]
  3. ...
  4. Profit!

The only drawback is that you cannot differentiate between Data Explorer and PDF reports, the same font will be used for both. You can change size and color only.

As proof, I attach a screenshot of the classy Bauhaus 93 font in action, so called because nobody ever used it after 1993. The particularly hideous "Coral" color was chosen to further stress the idea that the product will express no judgement on one's terrible taste.

JackLacava_0-1707307252354.png

EDIT 2024-04-11: It turns out that there are a few caveats.

  • Any font has to be installed on the CLIENT machine.
  • If using a nonstandard font, PDF reports might not be able to use it in v8+ (unclear why, for now). As a workaround, we can use a Cube View Extender that will set the font dynamically - in which case, the font will be picked up and displayed in the report. Example: 
    ' in CV Extender "_TestFont"
[...]
Case Is = CVExtenderFunctionType.FormatReportUIItem

	Dim uiItem As CVExtenderReportUIItem = args.Report.CurrentUIItem
	If uiItem.UIItemType = XFReportUIItemType.RowHeaderLabel Then
		uiItem.FontFamily = "Bauhaus 93"
	End If
    JackLacava_0-1712851376991.png

     

2 replies

C
CarlosAlvear
February 6, 2024

Hi,

Try check in a CV

For general settings: CV/Advanced/CubeViewProperties/ Report: Here you can set the settings for the PDF output

For columns or rows: CV/Advanced/Columns or Rows/Formatting/ headerFormat or cellFormat or cellType/(3 dots)/ Format/ Reporting segment: There you can setup the items you selected before.

Regards

J
JackLacavaAnswer
February 7, 2024

Easier than you might expect:

  1. install the font in Windows on OneStream servers (app and web)
  2. specify it in your format properties: FontFamily = [My Custom Font]
  3. ...
  4. Profit!

The only drawback is that you cannot differentiate between Data Explorer and PDF reports, the same font will be used for both. You can change size and color only.

As proof, I attach a screenshot of the classy Bauhaus 93 font in action, so called because nobody ever used it after 1993. The particularly hideous "Coral" color was chosen to further stress the idea that the product will express no judgement on one's terrible taste.

JackLacava_0-1707307252354.png

EDIT 2024-04-11: It turns out that there are a few caveats.

  • Any font has to be installed on the CLIENT machine.
  • If using a nonstandard font, PDF reports might not be able to use it in v8+ (unclear why, for now). As a workaround, we can use a Cube View Extender that will set the font dynamically - in which case, the font will be picked up and displayed in the report. Example: 
    ' in CV Extender "_TestFont"
[...]
Case Is = CVExtenderFunctionType.FormatReportUIItem

	Dim uiItem As CVExtenderReportUIItem = args.Report.CurrentUIItem
	If uiItem.UIItemType = XFReportUIItemType.RowHeaderLabel Then
		uiItem.FontFamily = "Bauhaus 93"
	End If
    JackLacava_0-1712851376991.png

     

T
tuhlerAuthor
February 7, 2024

Very cool! Thank you

Terms & ConditionsAccessibility statement