Reporting Services 2005 - Currency Format Style for fixed currency symbol

Posted on 2006-06-07
Last Modified: 2008-01-09
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

Question by:djehmli
    1 Comment
    LVL 14

    Accepted 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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Suggested Solutions

    Title # Comments Views Activity
    SQL Server Reporting 5 142
    Calculated field in Crystal Reports Crosstab 8 71
    SSRS hide tablix 1 250
    Can you help me to resolve it ? 5 62
    Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
    I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now