found an older post with the answer.... Re: Fitlering a text field if it contains a specific word[ New ] Options 06-10-2014 02:23 PM Hi Alex, As you said, an on-report keyword search filter would require a filter expression created in the designer, and the keyword couldn't be modified by report consumers in the current and previous releases of Visual Analytics. However, in the upcoming 7.1 release, targeted for this fall, you will have a new parameterization capability that will enable you to create a filter control that uses additional operators, such as contains, startswith, endswith, etc. Essentially, you'll be able to create numeric and character parameters and use them in both filter and calculation expressions, among other things, and associate a parameter with input controls that you place on the report for viewers to change. To meet your text search filter requirement for report consumers in 7.1, you first create a parameter in the designer, and then a filter expression that references this parameter. Then, you associate that parameter with an input control, like the text input control. Not only does this allow you to use operators other than equality for report consumer filter selections, a parameterized filter expression allows you to have multiple filter controls that are ORed. As you likely know, multiple on-report filter controls in the viewer are implicitly ANDed in 6.4 and prior releases. Alex, I hope this helps. Rick Styll
... View more
