How do you display positive numbers with a + sign?

[psrpsrpsr]

I'd like to display positive numbers on a trend report with a + sign in front of them.

I tried:
CASE WHEN [field] > 0 THEN '+'||[field] ELSE [field] END
...and that didn't work.

Is this possible?

[New_Guy]

Hi,
Did you try adding a text item and rendering based on the value > 0 ?
Good luck
New guy

[bdbits]

I think you could do this with a format string, e.g. +#,0.00;-#,0.00;"0.00";"null";

The first spec is positive values, second negative, third 0 values, fourth nulls.