If the property is Hidden and not Visible, then the True/False functionality is reversed, yes. I was going by memory, and I haven't worked with SSRS in a while. I...

The IIF expression takes three parameters: (1) a condition to check, (2) a value to pass on if the condition returns a True result, (3) a value to pass on...

If any of the first eight rows of data in the Excel sheet contains the extra-long string of more than 8,000 characters, then the Excel Source will apply the DT_NTEXT...

I finally found an acceptable workaround for the formatting I want. I moved the repeating header information out of the Page Header and into a separate grouping that is a...

What you are trying to do doesn't work that way. The rule in SSRS is that if ONE header row in a given grouping is set to print on every...

Technically you have unbalanced parentheses because you do not have a closing parenthesis in front of each comma that separates the value pairs of the function, and you do not...

The expression language in SSRS is a variety of Visual Basic, not T-SQL, so it does not support the BETWEEN comparison operator. You will have to use >= And <=,...

I would say that in general I try to put as much data into a single dataset as possible to minimize subreports or other even more complex ways of presenting...

If it were me, I would make the query like this:

SELECT

username,

grant,

grant_type = CASE

WHEN grant IN (240,241) THEN 'CLC'

WHEN...

You are on the right track with thinking that grouping is the key to your best solution. My suggestion is to incorporate all the values from the upper tablix dataset...

To gissah:

If you put Parameters!parameter_name.Label(3), you will be referencing only the fourth selected value of a set of values. I do not think this is your intention.

If I understand your...

No special SSRS expression is required, just a marginally more complex T-SQL WHERE clause that has separate conditions for each value of @enrollmentType. The WHERE clause would be something like...

I can appreciate wanting to deliver exactly what was asked for in the design, but I don't think what you are wanting is possible. Your best bet would be to...

For a multi-select parameter, you have to deal with the values as an array and use the JOIN function to extract the values into a delimited string, like this:

=Join(Parameters!parameter_name.Label, ",")

When...