Hi all I have a column where the users select the Measure based on a parameter. In one case the Measure is a dollar amount and I would like to apply the "C" format with comma. In the other two cases the Measure is a number and I would like to apply standard integer number formatting with the comma. In pseudo-code, I think it is something like this... =Iif(Parameter.Value = "Money", format as money, format as number) But how do I do this in real code? Suggestions? Thanks

Hello, That's possible to format so. In property "Format" choose "Expression" in in the editor enter you code like =IIF (Fields!Adresse.Value MOD 2 = 0, "C", "#,##0.000") This example would format every second as currency and the other with 3 fix decimals.Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing

Hi Olaf I am not sure where to go with this. I can find the format property, but I don't understand the Fields!Adresse.Value part of things. I will experiment but if you could explain this a bit it would be great! Thanks

Hi Olaf Got it! Thanks

"Fields!Adresse.Value" is just an example and in this case "Adresse" is a column from my dataset. So you have to change it to the column (or other data) containing the (condition for) format information.Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing