locked
Multiple values in field for Report RRS feed

  • Question

  • I am creating a report which takes a the value of a text field that has multipple values stored in it.

    My field field1 has red;green;blue;white;

    I want to create a report that has in the query when field1 = red or green

    Does anyone know how this should be wrote in the query in report builder?


    • Edited by JMcCon Tuesday, February 17, 2015 4:21 PM
    Tuesday, February 17, 2015 4:21 PM

Answers

  • You can do it like this.

    


    Regards, Saad

    • Marked as answer by JMcCon Wednesday, February 18, 2015 9:57 AM
    Wednesday, February 18, 2015 9:28 AM

All replies

  • As you're using Report Builder, I'm assuming you'll need this in SQL format. Something along the lines of the following should do what you want.

    SELECT * FROM table WHERE (field1 LIKE '%Red%' OR field1 LIKE '%green%')

    • Proposed as answer by Jon_Evans Tuesday, February 17, 2015 5:23 PM
    Tuesday, February 17, 2015 5:18 PM
  • If you are using fetchxml query you can use conditional operator 'like'
    Tuesday, February 17, 2015 6:33 PM
  • I am using the built in report builder in crm:

    Wednesday, February 18, 2015 9:07 AM
  • You can do it like this.

    


    Regards, Saad

    • Marked as answer by JMcCon Wednesday, February 18, 2015 9:57 AM
    Wednesday, February 18, 2015 9:28 AM
  • Thanks Saad
    Wednesday, February 18, 2015 9:57 AM