Yes, I have this in my code snippets file. I use it often.

Glad to help.

In the parameter settings for the query, use an expression like this:

=JOIN(Paramters!ParameterName.Value,",")

slip sliding away

This is what I usually do:

'value1,value2,value3,value4'

Depending on where exactly you are running it from you may need double quotes instead of the singles I show above.

Joy Smith San (2/23/2012)

---

Experts,

This is my first report in SSRS. I have worked on dotnet development and also with crystal reports, long ago.

Hence SSRS environment looks somewhat familar to me,...

What you are talking about is cascading parameters. Generally the way I do this is to start with the dataset query that will generate the actual report data using...

You could limit the data to a maximum number of characters with something like

=LEFT(Fields!FieldName.Value,30)

This sounds like a paradox, or at least the newest pop star to hit the scene.

Vizzini

If you need all rows for some reason (you have a chart or something else that uses all rows) then a filter as Martin suggests is probably the way to...

See if this helps:

REPLACE(REPLACE(REPLACE(LTRIM(RTRIM(CAST([Col2] AS nvarchar(2000)))),' ',' '+CHAR(7)),CHAR(7)+' ',''),CHAR(7),'') "Title"

First this trims all leading and trailing spaces, and then replaces all instances of more than one contiguous space...

Deja vu all over again.

Rat pack

Try something like this:

Max(Fields.Month.Value,"Dataset1")

You can scope values in an expression to the dataset. For example, using your names above you can do something like this: (Fields!TotalSales.Value,"Dataset1") to indicate that you want the...