My reporting guy tells me this is impossible, and I just can't quite accept that. I am interested in generating columns of numbers in SSRS reports that emulate the Excel "accounting" format. Specifically:
parentheses are used to indicate negative numbers
the numbers are all alligned on the decimal point, regardless of whether they are positive or negative (essentially, the positive numbers have to be slightly inset from the right margin by the width of a parenthesis character)
the $ character is left justified in the cell, regardless of the length of the number
zeroes are indicated by a "-" character
In Excel, all this is encompassed in the "Accounting" format. I do believe that this format is not directly supported in SSRS, but can all (or some) of this behavior be simulated in SSRS? Does SSRS in SQL Server 2008 R2 offer any additional support for this, if SQL Server 2005 does not? I am embedding an image here, showing what I am after, both the "ideal" as well as an alternate that gives up on the $ character:
I am also attaching an Excel file that was used to generate the above.
Again, if there's something supported in SSRS 2008 edition that might help, that would be a great selling point on investing in a new version of SQL. Many thanks! Accounting-Format-Example.xls