Can anyone tell me how to parse out a comma-delimited text string field for reporting purposes?
Example:
ID STRING
12345 1,2,3
67891 2,4
Becomes
12345 1
12345 2
12345 3
67891 2
67891 4
Thanks for any help!!
You should be handling this in the Dataset not in SSRS.
If you need help with SQL statements to to do this I'm sure posting to the Transact-SQL forum will provide a response on how to get a dataset to come back with the relevant rows. You may have to use functions, sp's, or temporary tables to get the data back in that format.
Craig
No comments:
Post a Comment