Hello all.
I'm not sure how to word the subject in a way that makes sense, so I apologize if it's confusing.
I have a report that contains a string field that lists anywhere from zero to 25 or more items of information. These items are separated by a comma.
What I need is a way to make a new row in my report for each item that is listed.
Here is an example of the data and how it is today:
And here is how I'd like it to appear:
I'm using CR 2008.
Thanks in advance for the assistance!
I'm not sure how to word the subject in a way that makes sense, so I apologize if it's confusing.
I have a report that contains a string field that lists anywhere from zero to 25 or more items of information. These items are separated by a comma.
What I need is a way to make a new row in my report for each item that is listed.
Here is an example of the data and how it is today:
Code:
Ticket Location Item
123 New York A1, B2, C3
234 Chicago A2
345 Atlanta B3, C4, D5, E6
And here is how I'd like it to appear:
Code:
Ticket Location Item
123 New York A1
123 New York B2
123 New York C3
234 Chicago A2
345 Atlanta B3
345 Atlanta C4
345 Atlanta D5
345 Atlanta E6
I'm using CR 2008.
Thanks in advance for the assistance!