Search Bar in Tabular Form
The search button in tabular form is helpful to identify the exact data in the tabular form, that will act like a filter in interactive report shows the particular values what we enter in that search field.
Steps To Follow:
Step 1: Create Text Field in the Label of Search with Search Button on above Tabular Form.
Step 2: Create a Tabular Form where we need to search record.
Step 3: Add the following query in region source of the Tabular Form based on the columns need to search
WHERE upper(Column1) = upper(:PXX_SEARCH)
or upper(Column2) = upper(:PXX_SEARCH)
or upper(Column3) = upper(:PXX_SEARCH)
upper(Column4) = upper(:PXX_SEARCH)
or :PXX_SEARCH is null
Step 4: In that search field item modify ‘Submit when enter pressed ==> YES’ for quick access of values in tabular form.