|Get Multi-Language Description
select cxitm006.itcd.e
from cxitm006
where cxitm006._index2 = {:tdsls401.item}
and cxitm006.clan.e = "es"
selectdo
endselect

I tried language$ and it is an error. Is there special function that determines the language of the report or user anything that I can use pass in my SQL statement that dynamically capture a language that report is printed instead of hardcoding it?

Dont pass language$ directly ,assign it to a variable and then map it. It is just a single character only...

Session ttaad1510m000 has details of 1 character values of language.
Please refer to it.
You should be feeding clan.e with those 1 character values and then you can achieve your requirement.

Why are you creating custom tables for multi language descriptions? LN (in Unicode mode) has standard support for multi language application data fields. The Enterprise Server Administration Guide has a chapter "Multilanguage Application Data".

But what I like to acheive is the report's language not the user's language. I was expecting 5 = Spanish and it was showing 1 = English instead. And I am trying to execute this inside the Sales Order Acknowledgement report script. Any more other special keyword to retrieve report language and in the XML of the SSRS report for language it is passing 5 I would just need to get that value before it gets written to the SSRS language. I don't have development source code for LN.

I am trying to determine the language a Report script

c.lang = language$
|ed.s #001
select cxitm006.itcd.e
from cxitm006
where cxitm006._index2={:tdsls401.item}
and cxitm006.clan.e = :c.lang
selectdo
endselect

but it is returning 1 which is the user_Data language, not the report language as shown in my attachment. How do I extract the report language instead of uesr language.

The architecture of "Infor Enterprise Server Plug-in for Microsoft SQL Server Reporting Services" is such that; all the data that is to be printed is first processed at LN level and a xml file is given as datasource to SSRS.

The name of this file could be-
${BSE_TMP}\ier_[your name]_[report name].xml

Thus your report script is also executed before the control is transferred to SSRS. Which means your Report Language at SSRS level has no significance at the LN report script level.

I understand that your user's language is English and he wants to print only this particular report in Spanish. This can be achieved by adding a single character input field on the LN session. Where before running the report; user will enter 5. And in the program you must use this field instead of language$

language$ is the user language. lattr.language$ is the report language.

Hey Jaap!! Thanx a lot... I wasn't knowing that lattr.language$ can be different than language$. Can you also please share the parameter where the report language can be set for LN report.

Sorry if this is an immature doubt :)

This is set in the print session by opening the report in that specific language, with function brp.open.language(). This is done in print sessions that print documents for e.g. business partners. The language is then determined based on the language of the business partner. Relations between BP languages and system languages are stored in tcmcs0146m000.
Moreover, you can overrule the language in the Select Device dialog: Select Language...

Thank you!! :)