Skip to main content
Solved

Report parameter lookup

  • September 8, 2020
  • 4 replies
  • 158 views

Blommetje
Forum|alt.badge.img+13

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? 

Thanks,

Alex

Best answer by Jasper

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

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

4 replies

Blommetje
Forum|alt.badge.img+13
  • Author
  • Partner
  • 208 replies
  • September 8, 2020

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! 

 


Jasper
Superhero
  • 678 replies
  • September 14, 2020

Hi Blommetje,

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


Blommetje
Forum|alt.badge.img+13
  • Author
  • Partner
  • 208 replies
  • September 16, 2020

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. 


Jasper
Superhero
  • 678 replies
  • Answer
  • September 18, 2020

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings