Allow entering a query that returns multiple columns as input for a Search Field. For example, for a Quick Report dealing with vendors, the SQL could be
SELECT DISTINCT Vendor_ID, Vendor_Name FROM spvVendor ORDER BY Vendor_ID
The Vendor_ID field would be the one passed to the Quick Report SQL query to search/narrow results. However, the search field dropdown would show both the Vendor ID and the Vendor Name.