I am using SQL Server 2008 Reporting Services and in my report I need to display all of the occurrences of a field in my dataset as a comma delimited list. IE, if I have a table of colors, I want to list them in my report like: Red, Blue, White, Green
If there is a way to do this in T-SQL instead of SSRS I am open to that as well.
Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.