Further to solutions (How to design Cognos interactive reports 03, 04), you want to have filters to filter data based on operator. The idea is to make filter statement be flexible with prompt token. This document will demonstrate the idea to use prompt token to generate filter with operator. Please see attached report specification for review (version 10.2 with sample Package GoSales)
All three pieces of filter are dynamic. Based on the choices from all three prompt, a very flexible filter can be specified by business users.
First value prompt
Second value prompt
Third List box
The key to make filters flexible is to apply prompt token
#Prompt('pFilter1_Column', 'token')# #Prompt('pOperator', 'token')# ?pFilter1_Values?
Checking generated SQL statement as below
where coguda00.SALES_REGION_EN > 'Central Europe'