Solved

For some columns LOV dialog is not showing in Quick Reports

  • 6 December 2021
  • 4 replies
  • 348 views
tharindukshan
Rank
Userlevel 3
Badge +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 ? 🤔

icon

Best answer by Jonas Feigl 8 December 2021, 02:06

View original
//Tharindu
This topic has been closed for comments

4 replies

Jonas Feigl
Rank
Userlevel 5
Badge +17

@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
Rank
Userlevel 3
Badge +7

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.

//Tharindu
Jonas Feigl
Rank
Userlevel 5
Badge +17

@tharin

I don’t think this is possible, sorry!

tharindukshan
Rank
Userlevel 3
Badge +7

Thank you @Jonas Feigl  for the support ☺️

//Tharindu
Terms & ConditionsCookie settings