Hi all
We are in the process of upgrading from WebFOCUS 7.1.7 to 7.7.02.
One of the issues that we are facing is related to the display of Copyright symbol on the reports. We had used the following code to display © (the Copyright symbol) on version 7.1.7:

TABLE FILE CAR
PRINT
COMPUTE
FOOT1/A20 = CTRAN(1,' ',32,184,FOOT1);
BY CAR
END

However, when the same code is used on ver. 7.7.02, it returns the Question Mark (?) symbol instead of the expected copyright symbol.
Please let me know if anyone has encountered this issue before and/or if I am missing anything here.

Thanks for your help in advance…

This message has been edited. Last edited by: Kerry,

Are your NLS settings the same?

The NLS settings seem to be the same. I checked in one of our 7.1.7 environments and the Language and Currency settings tie back, unless there is anything else that you want me to verify...

Thanks

This was resolved by using &|copy; instead of CTRAN function. Pointer - Tony's Post

TABLE FILE CAR
PRINT
COMPUTE
FOOT1/A20 = '&|copy;';
BY CAR
ON TABLE SUBFOOT
""
"END

quote:

Originally posted by Syed:
This was resolved by using &|copy; instead of CTRAN function. Pointer - Tony's Post

TABLE FILE CAR
PRINT
COMPUTE
FOOT1/A20 = '&|copy;';
BY CAR
ON TABLE SUBFOOT
""
"END

Syed,

Try using 169 instead of 184 for the Copyright symbol. That should work. Atleast it did for me.

Dave.

I think this is probably a code page issue.

The NLS code page settings are set 3 places:
1. Reporting Server on Configuration ->Miscellaneous - > NLS
2. WebFocus Client (Administration) Console: Configuration -> NLS Settings
3. Report Caster Configuration: General Tab -> DServer Codepage

You want to use the same code page (ie 137 or whatever you use) in each place.

You can test from Reporting Server Console to see if you get the character back correctly there, if so you have the right codepage in 1.

To see it in the browser, Excel and PDF etc, you need it additionally set right in 2.

To see it in Report Caster you need it additionally set correctly in 3.

All right.. I have been struggling to log in to Focal Point after I changed my email address preferences.. as it turned out to be, the confirmation email was being sent to my 'SPAM' folder

Anyway, N. Selph, I did give your points a try - #1 works from Server Console. So I went on to #2 and made the NLS settings on Client console the same as the one in Reporting Server Console (#1). That still did not resolve the issue... I am getting '?' instead of the Copyright symbol when I run it from Dev Studio.

@dburton - 169 gives the same result.. no good

For now, we have communicated to our business that we will be using '(c)' instead of the Copyright symbol on the reports. I may open a case with IBI to get it fixed, but for now I will have to focus on upgrade activities in the project

All - thanks for your inputs !

This is a change in behavior in 7702 and I have already opened a case. Are you using code page 437 or 137 ?

I am using 137.

Thanks

Syed, even though Pat has opened a case, you should open one anyway, as it will be RDUPed, and will give weight to the case.