Forum Discussion

BrianDunk's avatar
BrianDunk
Qrew Cadet
16 days ago

Report to Search for text in a Text Field?

I am wondering if it is possible to create a report that asks the user for a value to be found in a multiline text field.  For instance, when I click to generate the report a field will display asking what you would like to search for.  If I entered the value "Jason", it would search all records that have the word "Jason" in a particular text field.

Is this possible?

Brian

  • np,

    You can make a report with a filter of <ask the user>.   That is one of the choices when you are building a report filter.  So typically the filter would be like

    where [PRODUCT NAME] Contains <ask the user>

    If you use a Contains search, then user does need to be perfect in their data entry.

    • BrianDunk's avatar
      BrianDunk
      Qrew Cadet

      Hi Mark,  Thanks for the reply.  That is exactly what I was looking for.  I was using the wrong report type.

      Thanks again,

      Brian