Need Proper Number Format in SQL Reporting Services

Posted on 2011-10-18
Last Modified: 2012-08-13
The following statement returns a good value with the proper currency symbol and number format:
=Trim(Fields!CurrSymbol.Value) & FormatNumber (Sum(Fields!Unapplied_Amount.Value + Fields!Payment_Amount.Value, "MVTSStandardStatement"),2)

The following statement returns the data i am looking for but uses the wrong currency symbol:
=RunningValue((Fields!Unapplied_Amount.Value + Fields!Payment_Amount.Value), Sum, Nothing)

I would like to combine these 2 statements so the return will be the proper data in the proper format.  Below is the format I thought would work, but I receive the word #error when I run the report.
=RunningValue(Trim(Fields!CurrSymbol.Value) & FormatNumber((Fields!Unapplied_Amount.Value + Fields!Payment_Amount.Value), 2), Sum, Nothing)
Question by:orther
    LVL 3

    Accepted Solution

    please check below link may it help you to resolve your problem

    Try to convert this statement with string and then combine both string
    FormatNumber((Fields!Unapplied_Amount.Value + Fields!Payment_Amount.Value), 2), Sum, Nothing)

    Author Closing Comment

    =Trim(Fields!CurrSymbol.Value) & FormatNumber(RunningValue((Fields!Unapplied_Amount.Value + Fields!Payment_Amount.Value), Sum, Nothing),2)

    This is what actually worked.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
    It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    754 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