You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Printing Non-English Language in SQR Report

Hi All,

Can Anyone tell me How to print Chinese Characters in SQR report. Do I need to do any settings in the pssqr.ini file. As I am able to see the chinese characters which i saved in the database displayed properly from PIA.

If Yes, then what are the settings. I tried using the variable UseUnicodeInternal=TRUE in the default Settings of the pssqr.ini file. But this doesn't seem to work. Moreover is there any functions in SQR which can take care of it.

Thanks ...... Please Help !!!

Sankhara.

Re: Printing Non-English Language in SQR Report

Posts: 302
Join date: 06/23/08
Lepa's picture

>> Do I need to do any settings in the pssqr.ini file.
Yes, make sure you have the following:

ENCODING=UTF8
ENCODING-REPORT-OUTPUT=UCS2
ENCODING-DATABASE=UTF8

What type of a report are you trying to generate? PDF, XLS, CSV?
I have also heared that creating a new run control with Chinese language and running the program from it would do the trick.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Re: Printing Non-English Language in SQR Report

Posts: 30
Join date: 06/30/08
Nitin's picture

I am not sure of settings. But What I know is that if DB is multi-lingual and English is base language, then u need to manually fetch the langauge data using get-releated-field-information function commanly used in SQR.

Regards
Nitin

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <div> <pre> <br> <code> <a> <em> <blockquote> <strong> <ul> <ol> <li> <dl> <dt> <b> <p> <h1> <h2> <u> <img>
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
  • You can enable syntax highlighting of source code with the following tags: <code>.

More information about formatting options

CAPTCHA
The question below is to prevent automated spam submissions.
2 + 3 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.