Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4667
  • Last Modified:

Reporting Services 2005 - Currency Format Style for fixed currency symbol

What is the syntex for a format expression to left justify <fix> the currency symbol in reporting services?

In excel I would use: _($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)

i've tried format(Fields!Amount.Value,"_($*#,##0.00_)")  and of course it didn't like that.

Basically I want my currency detail to look like:
$     123.45
$ 45678.34
$      10.12

In Crystal I would just mark it as fixed :(

Thank you for any assistance

1 Solution
I'm not aware of a format in RS that would do this.  As a workaround you could have a column before the field that contains the $, and then just a normal numeric field after it.  e.g.

-- -----------
$      123.45
$  45678.34

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now