Report parameter lookup

  • 8 September 2020
  • 4 replies

Userlevel 2
Badge +3

Hi All, 

I print a report, and that is all ok. However, I want to print a report with some language settings. So, I want my report to do the following: 

  1. I give the parameter account_id to the Report
  2. Based on account_id I want SF to check in a table Account for the Language_id 
  3. Set this language_id in the Field 'Language’ in the print prompt. 

I've been trying for quite while, but somehow.. the lookup fails. 

Is there someone out there to shine some light in this dark world? 



4 replies

Userlevel 2
Badge +3

Oh, i got this far. 

it does find the Language_id - and based on the ID the Code. BUT it does NOT as default in the field. I still need to select it. 

Driving me nuts! 


Userlevel 6
Badge +8

Hi Blommetje,

Are you using default logic to retrieve the language ID? If so, can you share the SQL code?

Userlevel 2
Badge +3

eh no? I do this: 
Procecces → Reports → Report Lookups. 

Add with the big black + on the left. Enter both var (account_id and language_id) 
This way it does show the users language_id, but not as 'default’. I still not to use the dropdown to select it. 

However, my co-worker told me something about default logic. I'll look into it. 

Userlevel 6
Badge +8

You can find more info on default logic in the Thinkwise Software Factory Essentials e-learing here.