Skip to main content
Solved

For some columns LOV dialog is not showing in Quick Reports

  • December 6, 2021
  • 4 replies
  • 462 views

tharindukshan
Sidekick (Employee)
Forum|alt.badge.img+7

Hi,

I have the below parameter in my quick report

AND  t.tax_code = NVL('&[MC--L]STATUTORY_FEE.FEE_CODE', '%')

But it is not showing the relevant LOV dialog for the above parameter 

 


For some fields it’s working fine
Did I miss something here ? 🤔

Best answer by Jonas Feigl

@tharindukshan The quick report shows the LOV for the Entity that the column references. STATUTORY_FEE.FEE_CODE doesn't reference anything else as it is the basic data table itself. If you use e.g. INVOICE_ITEM.VAT_CODE as your Quick Report parameter (which references the desired STATUTORY_FEE.FEE_CODE) it should work!

 

PS: Having an NVL around the parameter kind of  contradicts defining the parameter as mandatory ([MC--L])!

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

4 replies

Jonas Feigl
Superhero (Employee)
Forum|alt.badge.img+20
  • Superhero (Employee)
  • 262 replies
  • Answer
  • December 8, 2021

@tharindukshan The quick report shows the LOV for the Entity that the column references. STATUTORY_FEE.FEE_CODE doesn't reference anything else as it is the basic data table itself. If you use e.g. INVOICE_ITEM.VAT_CODE as your Quick Report parameter (which references the desired STATUTORY_FEE.FEE_CODE) it should work!

 

PS: Having an NVL around the parameter kind of  contradicts defining the parameter as mandatory ([MC--L])!


tharindukshan
Sidekick (Employee)
Forum|alt.badge.img+7
  • Author
  • Sidekick (Employee)
  • 20 replies
  • December 8, 2021

Hi @Jonas Feigl 
Thank you so much. Yeah it works 😀

Would it be possible to put a filter to that view? Like filtering from the Company
Without the filter INVOICE_ITEM.VAT_CODE shows all the VAT codes for all the companies.


Jonas Feigl
Superhero (Employee)
Forum|alt.badge.img+20
  • Superhero (Employee)
  • 262 replies
  • December 8, 2021

@tharin

I don’t think this is possible, sorry!


tharindukshan
Sidekick (Employee)
Forum|alt.badge.img+7
  • Author
  • Sidekick (Employee)
  • 20 replies
  • December 8, 2021

Thank you @Jonas Feigl  for the support ☺️


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