Thanks for the question. I've never given much thought to the topic, so it's been good to dig around and learn something new. Thanks to everyone who added to the...

+1...

Thanks for the great question. :satisfied:

Thanks for the question. I learned something today.

Thanks for the question. Good one to end the week on.

:hehe: Thanks for the question. I had to use this method not too long ago, so it was still fresh on my mind.

You can pick and choose columns from it. From here you can see the Report name as well as the job name so you can tie the two back together....

Thanks for the question.

Ed Wagner (6/25/2014)

---

Okay, that was one of the cooler questions I've seen. I've never used ESCAPE before and I've never even thought of putting search patterns into a table....

Thanks for the question Steve, I learned something today.

Here's a couple of ways to try assuming that you're filling your list from a query.

="Gross Total For : " & iif(Parameters!TeamName.Count = count(Fields!TeamName.Value,"DataSetName"),"All", Join(Parameters!TeamName.Value, ","))

="Gross Total For : "...

Please review the "World Limitations" section http://msdn.microsoft.com/en-us/library/dd283105%28v=SQL.105%29.aspx

There is a workaround that you could try here

Here are a couple of links that might get you started.

StackOverflow

SQLServerCentral

+1

Ed Wagner (6/5/2014)

---

It's nice to have a simple question every once in a while. Thanks.

This is the type of question that makes me REALLY think about the data type...