Hi,
I have a report in which i am simply printing the values in xls format.

 
TABLE FILE FI_SS_GOVEX_CTRY_RSK_WT
"Government Details"
PRINT
FUND_NAME AS 'Fund Name'
EFF_DT AS 'Effective Date'
REGION AS 'Region'
FUND_RSK_PCT AS 'Fund Risk %'
IDX_RSK_PCT  AS 'Index Risk %'
REL_RSK_PCT AS 'Relative Risk %'

ON TABLE PCHOLD FORMAT EXL2K
 

There is a value in database for column Region as 'Côte DIvoire'. The problem is that this value is getting printed in the report as 'Côte DIvoire'.
Can anyone suggest me the possible reason for this and how it can be handled?

Thanks in advance.

Try to do a Define Field For that Column, like

HLNUM/A13V = EDIT(HP_DESK_NO,'9999999999999');

Put your Lengths as needed. This once resolved |||r kind of issue to me.

Try out some Regional setting configurations or Language(Unicode) settings on the server level. Please discuss with your Admins as well.

This may fix your problem,

TYPE=REPORT, FONT='Arial Unicode MS',$

Hi Hari,

But what IF, the requirement needs another Font in Report ?

To paraphrase the great Yogi Berra "This is deja vu all over again" .....

meaning ?

Meaning we had the exact same discussion about how to handle 'Cote D'Ivoire' just a few months ago. In other words we have been on this subject before.

However if you are asking about the famous quotation it gets more interesting. Yogi Berra was a baseball team manager who was famous for mangling well-worn phrases and this was one of his best.

Now, most people nowadays don't understand what 'I had a sense of deja vu' actually means. 'Deja vu' is a feeling that you have been somewhere, or seen something, that you actually could NEVER have seen, such as arriving in a new country with the gut feeling that you have been there before and everything seems at first familiar. It's a mental trick the mind sometimes plays.

Most people (including Yogi Berra) cheapen and misuse 'deja vu' to mean that they are seeing something they HAVE seen before. But Yogi took it a step further by saying in effect: 'This is the same thing I saw before all over again'. That just sounds odd and repetitious
like 'It always snows on February 1 at the beginning of the month' until you understand that 'deja vu' actually means you know on an intellectual level you have NOT seen something before, still but have that gut feeling ...

Does this help? Or are you more confused than ever? LOL

Another Berra-ism: 'It ain't over till it's over.'


Check out: http://www.brainyquote.com/quo...rs/y/yogi_berra.html

This message has been edited. Last edited by: George Patton,

quote:

Originally posted by Shankar:

There is a value in database for column Region as 'Côte DIvoire'. The problem is that this value is getting printed in the report as 'Côte DIvoire'.
Can anyone suggest me the possible reason for this and how it can be handled?

Thanks in advance.

Try using the CTRAN function. I have pasted some code below that I have used and works for me. Although, my output is a little different then yours where my display is 'C"te Divoire' but the concept is the same.

 
DEFINE FILE CAR 
VAR/A20='Côte Divoire';
END
TABLE FILE CAR
PRINT 
     'CAR.COMP.CAR'
     'CAR.CARREC.MODEL'
	 'VAR'
     COMPUTE NEWVAR/A20 = CTRAN(20, VAR, 147, 244, NEWVAR);
BY 'CAR.ORIGIN.COUNTRY'
ON TABLE PCHOLD FORMAT EXL2K
END

In the CTRAN function, 147 is the ASCII value for ". Because you get the à character you should change 147 to 195 and try that. An example below.

 
COMPUTE NEWVAR/A20 = CTRAN(20, VAR, 195, 244, NEWVAR);

Hope this helps.

Dave

quote:

George Patton

That was a nice story, at right point...