Hello,
I am testing the Reporting Studio 8.4.2, creating reports and integrate them into Webtop homepages. More-less I am able to do what I need. But just now I have come to the point I need to put some text (from table tttxt010) into my report. So I have created join table (e.g. via fields tcibd001.txta -> tttxt010.ctxt). The report is printed but the text is displayed in HEX mode(HEX value of ASCII code of the characters). Instead of text I see only numbers.

Text in Infor ERP LN: "Text of item"
Text displayed in BIRT: "4657874206F66206974656D2020202020202020202..."
where 2020... are HEX value of spacespaces

Does anybody come to any solution to this problem? Thanks for any help.

Birt support some 4GL functions:
text_content(tcibd001.txta) = retrieve the text content of the table
Other functions could be used, you have just to try what you need.
Enjoy.

Good morning tomas1,

Can you tell me what are the steps you made in order to get Reporting Studio 8.4.2 work ?

What have you downloaded ?
Did you brought any licence for this ?
If you have already customised some reports, was it easy to do ?

thank you.

Thaks Thomas, i knew text_content was supported, my task was to handle the formatting of the text. I mean text is written into ERP LN table field with such formatting rules, it's possible to change the text formatting acting on the text_content(table_field) into Reporting Studio? Thank you again. Bye.
Federico.

Hi

I 'm new to BIRT. I using BIRT and SQLJBDC connect to SQL get data. I can i convert the hexadecimal value to string?

Regards,
Thang