Thanx.

I added the fields onto the blank report because I needed a "free form" type of report. There are other text boxes with just plan text, kind of like labels....

Good points. You're right. I'll make the change

Thank you all for your responses.

I read Jeff's article. Way over my head. My data is relatively small so, the fnSplitString function works pretty quick.

The goal is to be able to count each string element to get a total for each.

This is some test data. Not all rows will have a delimited string value.

create table #Test

(

QuerySetID int,

QueryNumberID int,

QueryValue varchar(100)

)

insert into #Test(QuerySetID, QueryNumberID, QueryValue) values(7,15,'{Taxi Voucher}')

insert into #Test(QuerySetID, QueryNumberID, QueryValue) values(7,17,'{Counseling}')

insert...

Here's the function. I got it from your site. I think the blog author's last name is Patel.

CREATE FUNCTION [dbo].[fnSplitString]

(

@string NVARCHAR(MAX),

...

Thanx.

Wonderful. Just what I wanted.

Thanx.

...........and insert the other "set" of fields in there?

I tried that but, I have 12 columns to group on and it doesn't look good. I was thinking of a subreport but, I don't know how to get the...

Thanx. I didn't know you could pivot with SSRS but, am willing to learn.

OK. Now for some more knowledge transfer..................this stored procedure containing the dynamic sql is used for an SSRS report. The dataset isn't pulling the fields because of issues with SSRS....

Thanx.