Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Multiple values in field for Report RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    If you are using fetchxml query you can use conditional operator 'like'
    Tuesday, February 17, 2015 6:33 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I am using the built in report builder in crm:

    Wednesday, February 18, 2015 9:07 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks Saad
    Wednesday, February 18, 2015 9:57 AM