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)
ortherAsked:
Who is Participating?
 
ExpertLogin_890Connect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.