Thanks for the prompt and accurate response. Much appreciated.

I will check that out Drew; thanks for taking the trouble to reply.

Thanks for the suggestion.

Jeff Moden (8/16/2016)

---

faulknerwilliam2 (8/16/2016)

---

Dear Jeff

A thousand thanks for your help and your taking the time and trouble to help with my query. Your solution has worked perfectly. I love the...

cad.delworth (8/18/2016)

---

Sorry Jeff, No I don't have the spare time at work that you seem to have. What I posted was intended to show anyone with a basic knowledge...

Jeff Moden (8/18/2016)

---

@faulknerwilliam2,

I know you must be busy but any feedback on the questions below?

Jeff Moden (8/16/2016)

---

If you don't mind and if you have the time, I'd like to ask...

Dear Jeff

A thousand thanks for your help and your taking the time and trouble to help with my query. Your solution has worked perfectly. I love the ranking element.

I really...

Jeff Moden (8/11/2016)

---

faulknerwilliam2 (8/11/2016)

---

I am currently using SSRS 2008R2. This is the script I am using:

SELECT

a.name,

DATENAME(M, a.Date) as Month,

DATENAME(YEAR,a.Date) as Year,

DATEPART(YYYY,...

Dear Jeff - thanks for getting back

Code should be a.status = 'live';

a.name is indeed the name of the product.

Thanks.

Dear Jeff - thanks for getting back

Code should be a.status = 'live';

a.name is indeed the name of the product.

Thanks.

And that is what I did:

="Top 10 contact reasons:" + " " + join(Parameters!Contact.Value,",")