Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

This document provide details as if you would like to search base on filtered records criteria from Data Source. Initially you have to create two parameters. First 'filter' parameter for criteria and second 'searchInput' parameter for searching in receptive criteria.

filter - String (Multiple Values)

searchInput - String


Select desire criteria in which you would like to search

Go to Report > Select Expert > Record > Formula Editor > Paste Formula


if {?filter} = 'SO' AND HASVALUE({?searchInput}) then

    replace({Command.Sales Order#}, ' ', '') like '*' + totext({?searchInput}) + '*'

else if {?filter} = 'DO' AND HASVALUE({?searchInput}) then

    replace({Command.Doc No}, ' ', '') like '*' + totext({?searchInput}) + '*'

else if {?filter} = 'PO' AND HASVALUE({?searchInput}) then

    replace({Command.Customer PO#}, ' ', '') like '*' + totext({?searchInput}) + '*'

else if {?filter} = 'Item Code' AND HASVALUE({?searchInput}) then

    replace({Command.Item Code}, ' ', '') like '*' + totext({?searchInput}) + '*'

else if {?filter} = 'Item Description' AND HASVALUE({?searchInput}) then

    replace({Command.Item Description}, ' ', '') like '*' + totext({?searchInput}) + '*'

else if {?filter} = 'Customer Name' AND HASVALUE({?searchInput}) then

    replace({Command.Customer Name}, ' ', '') like '*' + totext({?searchInput}) + '*'

else if {?filter} = 'Invoice No' AND HASVALUE({?searchInput}) then

    replace({Command.Invoice No}, ' ', '') like '*' + totext({?searchInput}) + '*'

else

true


Save and close Formula Editor

Click on View in the menu bar select Preview

Labels in this area