Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE OPENED]Reportcaster not properly showing Spanish Characters

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CASE OPENED]Reportcaster not properly showing Spanish Characters
 Login/Join
 
Master
posted
**********************************
Edit 2/24/2017
Opened up a case with IBI for help
**********************************

Has anyone figured out how to resolve issues with ReportCaster mangling spanish characters.

I have my code page set to 1252 everywhere I can think of
-Reporting Server
-Application Server
-ReportCaster (Distribution Server Code Page and Webserver Code Page)
-Linux Server

I do not have this issue when running the report directly from the content area nor from the reporting server. This is only an issue when emailing the report from report caster (I have not tried the library but expect the issue to be the same). This is both with HTML and XLSX output types.

My redirection setting for xlsx is set to Redirect = yes , Save Report = yes

Any thoughts on where else to look to resolve this issue? Is it an encoding issue?


Thanks

This message has been edited. Last edited by: eric.woerle,


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
 
Posts: 750 | Location: Warrenville, IL | Registered: January 08, 2013Report This Post
Virtuoso
posted Hide Post
Get a trace from the email server. I had an issue a couple of years ago where the attachment was multibyte and the email server was single byte. Turns out that the attachment didn't identify the proper codepage of the attachment. You could be having the same issue in reverse. If library is fine then that could be it.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
Master
posted Hide Post
Report Library produces the same issue. I was originally thinking it could be the email server too... Doesn't seem like it.


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
 
Posts: 750 | Location: Warrenville, IL | Registered: January 08, 2013Report This Post
Virtuoso
posted Hide Post
Any chance you can show the before and after, and the hex values?


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
Master
posted Hide Post
All accented characters are being represented as � . doesn't matter if its an accented o, u, or i.

In this case: Identificación del Estudiante
became: Identificaci�n del Estudiante

And: Número Consecutivo del Cupón
became: N�mero Consecutivo del Cup�n


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
 
Posts: 750 | Location: Warrenville, IL | Registered: January 08, 2013Report This Post
Virtuoso
posted Hide Post
Interesting. It looks to me like RC is converting to a multi-byte character set, and then it is being rendered in single byte.

You might want to check if there is another RC code page setting, and open a ticket.

When I take the character (F3 in 1252), then convert to utf8 and then display as ascii, I get something close to what you are seeing. However, I cannot duplicate it.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
Master
posted Hide Post
ya, I've been thinking along the same lines as you, that its saving it as muliti-byte character and excel is reading it as a single byte character (Or vice versa). I'm just completely confused why this is only a problem with RC. I'll check with IBI to see what insight they can provide on this issue.

Thanks dhagen!


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
 
Posts: 750 | Location: Warrenville, IL | Registered: January 08, 2013Report This Post
Virtuoso
posted Hide Post
In RC, it will have to open the file to either attach it, or copy it to library. It's more than likely that read that may be causing the problem.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
Guru
posted Hide Post
Eric,

The Report Caster product manager, who checked with the NLS QA team tested out your issue. They set up similar configurations on our sandbox with code page 2152 but were unable to reproduce the issue.

They have requested that you please re-check your configuration, restart the application and distribution servers as well as the reporting server and let us know your results.

Here is the image received:


Thank you for participating in the Focal Point Forum!
Tamra Colangelo
Focal Point Moderator
Information Builders


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Report This Post
Silver Member
posted Hide Post
Depending on the default encoding of you platform you may also have to set the file encoding in the Distribution Server startup script by adding -Dfile.encoding=es_ES.iso88591 to the java command in schbrk.sh. You can do locale -a on the command line to see all encoding options.


WebFOCUS All Releases
 
Posts: 45 | Location: NYC | Registered: September 21, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE OPENED]Reportcaster not properly showing Spanish Characters

Copyright © 1996-2020 Information Builders