Sometimes, the dimension is too big to be selected. The filter solution is to use search prompt instead. We can use conditional block, value prompt is used for normal small dataset, while Search Prompt is used for big dataset. Both prompt can be coexist, depends on what query item business users to choose. The idea is to apply condition block for specifying filter values. This document will demonstrate the idea to use prompt token to generate filter with search prompt. Please see attached report specification for review (version 10.2 with sample Package GoSales)
When company is selected, then search prompt will be populated. This idea will be very good for performance as system don’t need to retrieve all data for company. However, simple list box is used for other selections, such as product line.
First value prompt
Second list box or search prompt
Whether it is list box or search prompt, the query is same. This filter #prompt ('pFilter1_Column','token')# makes it possible to have values depending on the selection of value prompt. Please also note that cascade source is specified for list box.
The key to make filters flexible is to apply prompt token
#Prompt('pFilter1_Column', 'token')# in (?pFilter1_Values?)
Note to make Search Prompt size changeable:HTML 1: