Sorry, I am sure you've guessed, but BLACK is the final ELSE part of the expression.

Also, make sure the case is correct for the colours, not all uppercase like I've...

Yes, and these work basically the same way as an excel IF...THEN...IF...THEN..ELSE statement.

if the value is "Prod" I'd like to see it displayed BLUE, BOLD

if the value is "QA"...

No, it's not defined anywhere.....

HOWEVER...

It might be that your parameter is a number, and therefore the error is that you are trying to join numbers and strings.

If this is the...

where are you writing the statement? is this in a control inside the report or is it in a dataset somewhere?

Sorry, but it DOES take .Value with the JOIN function, the thing you have to remove is the (0) part that is automatically added when you select the parameter name...

Use the following expression in your text box/cell/whatever:

=JOIN(Parameters!ParameterName.Value,'; ')

The last argument of this function '; ' is the one that will add the separator between each value, so you can...

Simple really, you already have the code to do it, just go to the Font Style area of the same properties and add the expression:

=IIf(UCase(RTrim(Fields!EnvName.Value)) = UCase("Prod") ,"Bold", "Normal")

Good luck,

SELECT CLM_DOUT

FROM All_Clients_Discount_Management_DEVON_ADV

WHERE (@DateType='Week' AND (YEAR(CLM_DOUT) = YEAR(GETDATE())) AND (DATEPART(wk, CLM_DOUT) = DATEPART(wk, GETDATE()))=@DateNumber)

OR (@DateType='Month' AND(MONTH(CLM_DOUT) = MONTH(GETDATE()))...

OK, I think I understand what you are trying to achieve, I am guessing that you want the user to be able to input either the week, month or year...

It really depends on how you are using your parameters inside the report or dataset. Normally what I would expect to see is one parameter only, and that parameter...

AHHHHHH !

So now I understand what you mean.

A question: Are there only two dates included on any row on this report (as I'm sure you know, the concept of...

Can you drop a small sample of the current output you're getting, I'm not sure I fully understand what you have at the moment. I certainly don't understand how...

OK, but the standard charting tool in BIDS does not give me the other functionality I need, which is why we use the awful piece of software called Dundas. ...

The Matrix is notorious for it's little tricks, but the way to do this is to right click on the heading of your second value column and select "Add Column"....

Well we both managed to learn something today, and you're right, quirky is certainly one word you could use for SSRS!!