you could add a field and put an expression like the following as value =IIf(Fields!id.Value <0,"(-1)","") the function is to add to a new column you put in the report the IIF function evaluate an expression (here if the id value of my db is less than 0), then return the first thing after the comma if true (here the string "(-1)") or the next thing after the subsequent comma if false (here an empty string). Beware: both true parte and false parte are evaluated
On 4 Feb, 18:54, Renato <[email protected]> wrote: > Hi, I have many reports that I made with Microsoft Reporting on Visual > Studio 2008. > I need format these reports to show a number between parenthesis if the > number were negative. > Anyone knows how can I create a custom format to do that ? > > Thanks
