Answered by:
Multiple values in field for Report

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 SaadWednesday, February 18, 2015 9:57 AM