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

Need Proper Number Format in SQL Reporting Services

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)
0
orther
Asked:
orther
1 Solution
 
ExpertLogin_890Commented:
please check below link may it help you to resolve your problem

http://msdn.microsoft.com/en-us/library/ms345242%28v=sql.90%29.aspx

Try to convert this statement with string and then combine both string
FormatNumber((Fields!Unapplied_Amount.Value + Fields!Payment_Amount.Value), 2), Sum, Nothing)
0
 
ortherAuthor Commented:
=Trim(Fields!CurrSymbol.Value) & FormatNumber(RunningValue((Fields!Unapplied_Amount.Value + Fields!Payment_Amount.Value), Sum, Nothing),2)

This is what actually worked.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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