User login
Sponsored links
Recent blog posts
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
- How can we call Dynamic Calling section in Peoplesoft Application Engine program?
- How can we write multiple SQL Commands/Statements under one Action by using one function?
- Peoplesoft BU VS Record Groups VS Record Group Controls VS Control Table VS Table set Sharing VS Table SETID?
- Difference between Custom and Customised objects in Peoplesoft?
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.
How to use Multinational Language code in SQR?
Fri, 05/02/2008 - 2:42am
Hi Everybody,
How to use multinational language code in SQR? for example India is sending an invoice to France, German, swiss etc., so my invoice report should to be based on that countries language, for example France invoice report should to contain a France language, German invoice report should to contain a German language and so on... so anyone can help on this..... if possible anyone can send a sample code on this...
Thanks a ton in advance for all your help.
Bookmark/Search this post with
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| MD5 - SHA checksum of a file. | PeopleSoft Technical | 02/07/2012 - 5:29am |
| nVision Tabular Report through PIA with prompts | PeopleSoft Technical | 02/02/2012 - 10:07pm |
| Can we create an AE to mass update Position - Jobcode data? | PeopleSoft Technical | 01/18/2012 - 3:11am |
| Pay Components on job data can be defaulted and setup based on the rules? | PeopleSoft Functional | 01/05/2012 - 4:58am |
I have never had to do this, but there is a book called Manning SQR in PeopleSoft and Other Applications that touches a little bit on this in chapter 21. It talks about how to alter the $sqr-locale variable "Alter-Locale Locale = 'French' to switch between languages to help with date, and currency printing. Do you have the book available in your organization some where?
Have you looked at sqrtrans.sqc? This SQC file contains the procedures that will allow SQR reports to be generated for different languages! There are quite a few delivered PeopleSoft SQRs that uses that sqc for translation purposes (BEN045.SQR for example). The programs calls procedure Init_Report_Translation($ReportID, $Language_Cd) in the sqc.
Sorry don't have a sample code but hope this puts you in a good position to start with.
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
Post new comment