How to use session variables to customize a report output

User_4H93V

Content

Hi,

I was wondering if someone has already use session variable to customize the output of a report.

I'm currently creating a data model and I would have wanted the translatable field to be automatiocally set in the language of the user that is running the report.

I found the sesion variable :xdo_user_ui_oracle_lang (User interface language from the user's account preferences. For example: US) but I have not been able to use it in a report.

thanks for your help,

Benjamin

Kumaran Raviprakash-4425

So are you using this variable in your data model and getting the value in the data xml, then based on the same you should be able to base your report output on the xml value.

User_4H93V

Hi Kumaran,

 

That's what I'm trying to do. I tried to wrote query that returns this value but nothing works so far ... any ideas ?

 

regards,

Benjamin

AshishERPCloud

Hi,

Did you tried creating a seperate data set and use some query like Select :<xdo_var> as lang_session from dual ;

 

I tried for username and it works perfectly fine.

Gael Chevallier-4294

Hi Benjamin,

If the translation you need is linked to stored data, did you try to use the language table(table name_TL) instead of the base table in your DM ?

Gael.