Quick report

I’m guessing you are already aware of how to code the report so that it allows the user to enter a  parameter via textbox? 

Hi ​@Ozge ,

 Yes, it is possible. You need to define vendor_no as a parameter in the Quick Report and attach a List of Values (LOV) to it. This can be done either by using a predefined LOV or by creating a custom query (e.g., selecting vendor_no from supplier_info). When running the report, users will then be able to pick the vendor from a list instead of entering it manually.

Hi ​@Lingesan08,

First of all, thank you for your response.

Could you share an example SQL code that I can integrate into the relevant quick report, allowing the user to select vendor_no from a list of values?

Thanks

Ozge

Hi ​@Ozge ,

 You can use :vendor_no as a parameter in your Quick Report SQL. Then configure the parameter to use a List of Values (LOV), either by linking a standard supplier LOV or by using a custom query like SELECT vendor_no, name FROM supplier_info. This allows users to select the vendor instead of entering it manually.