Skip to main content
Solved

Add Unicode String in Report Designer

  • September 28, 2022
  • 3 replies
  • 669 views

Forum|alt.badge.img+7
  • Sidekick (Partner)
  • 45 replies

Hello Community,

I was trying to add a  symbol in the report designer. For this I inserted the character like this in a column in RDF file -

Xml_Record_Writer_SYS.Add_Element(xml$_, 'CHECKMARK', 'RK ' || TO_CHAR(UNISTR('\2713')));

I also tried simply with UNISTR(‘\2713’) , TO_CHAR(UNISTR(‘\2713’) but none worked.

When I printed the report, the character wasn’t showing. When I tried concatenating ‘RK ‘ string before it, only the first string printed -

No Checkmark Symbol

Is it limitation of report designer not able to print unicode characters? Or is there another way to print such characters? (without using images)

 

Thanks in advance.

Rohit.

Best answer by ChanakaAmarasekara

Hi,

I tried this and it works. I think the font you are using to show the data doesn’t support Unicode glyphs.

Here are the tests I followed.

  1. As you wrote, added the Unicode checkmark in to the xml data through the RDF (Code.jpg)

     

  2. Then previewed the report and I got a square where the checkmark should be (NoMap.jpg)

     

  3. Then I replaced the font which showed the checkmark to a font that support Unicode font characters (Unicode glyphs). Here I’m using the font substitution feature in reporting to map the font used in the layout to another font that support Unicode glyphs. Here I mapped  the Garamond font to Arial Unicode font. (FontMap.jpg).

     

  4. Then I previewed again and now I can see the checkmark without any issue, (Map.jpg)

     

IFS ships a Unicode font in the UCFONT component. I think you will have to purchase it separately. 

I tried this through the IFS EE client but it should be the same if you preview through the IFS Report Designer tool.

 

Try the above and see if it works for you.

 

Regards,

View original
Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img+7
  • Author
  • Sidekick (Partner)
  • 45 replies
  • September 28, 2022

“UPDATE”

I just checked the XML Data of the generated report, and it shows the character -

 


ChanakaAmarasekara
Hero (Employee)
Forum|alt.badge.img+15

Hi,

I tried this and it works. I think the font you are using to show the data doesn’t support Unicode glyphs.

Here are the tests I followed.

  1. As you wrote, added the Unicode checkmark in to the xml data through the RDF (Code.jpg)

     

  2. Then previewed the report and I got a square where the checkmark should be (NoMap.jpg)

     

  3. Then I replaced the font which showed the checkmark to a font that support Unicode font characters (Unicode glyphs). Here I’m using the font substitution feature in reporting to map the font used in the layout to another font that support Unicode glyphs. Here I mapped  the Garamond font to Arial Unicode font. (FontMap.jpg).

     

  4. Then I previewed again and now I can see the checkmark without any issue, (Map.jpg)

     

IFS ships a Unicode font in the UCFONT component. I think you will have to purchase it separately. 

I tried this through the IFS EE client but it should be the same if you preview through the IFS Report Designer tool.

 

Try the above and see if it works for you.

 

Regards,


Forum|alt.badge.img+7
  • Author
  • Sidekick (Partner)
  • 45 replies
  • September 29, 2022

@ChanakaAmarasekara Thanks, it worked for me too.

Selecting the Arial Unicode MS font renders the checkmark symbol. I tried with other fonts like Segoe UI Symbol, Wingdings, etc. but none other font renders the symbol.

It was problem of the font that I was using. It was not able to display that checkmark symbol.
 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings