Skip to Content
avatar image
Former Member

How to create a free text entry Input Control to use to filter results

I have previously been able to create a free text entry Input control that links to multiple variables and a page filter, that will filter your displayed results (similar to the way you can click a check-box input control. But I can remember all of the steps needed.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 23, 2017 at 12:40 PM

    Hi John,

    Try the below steps:

    1. Create a Dimension variable v_Search Text =""
    2. Create an Input Control on that variable v_Search Text, should be of type Simple Selection with input as Entry Field, leave the other properties as default and click OK.
    3. If you want to filter all columns depending on the search text entered, it'll be a little lengthy formula, if you just want to see rows where a Dept Name has the characters from the search text, then create the filter as
    v_Filter for Searched Text =If(Pos(Upper([Dept Name]);Upper([v_Search Text])) > 0) Then 1 Else 0
    4. Create a filter on the report/tab as v_Filter for Searched Text = 1 and click OK.
    5. Voila!! Let us know if that helps.
    Note: If you want this Search Text to be able to filter more columns, just add the conditions for different Dimensions in the If(), and use an OR between those multiple conditions. E.g. =If(... OR ... OR ... OR ...) > 1 Then 1 Else 0

    Thanks,
    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded