Expressions

Question

Expressions

Abs-225476

Hall of Fame

Points: 3483
More actions
December 2, 2009 at 9:29 am

#214426

Hi,
I have an expression in reporting services which will concatenate some text a date field and currency value.
It does work but I do not know how to fomat the currency value within the expression so that it shows the £ sign and formats the value to 2 decimal places.
Expression is as follows
=" Your account Balance is "+Fields!Balance.Value.Tostring

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004312 More actions · Answer 1

I can't believe that no one has answered this for you yet. I'd do it but I can't even spell SSIS. 😉 Maybe this response will act as the "bump" to get what seems to be a simple question answered.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Arunkumar S P SSCertifiable Points: 6415 More actions · Answer 2

Always use & symbol to concatenate two values

To round off

=Round(Fields!Test.Value,2)

OR

=Format(Fields!Test.Value,"#.##")

-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.

Thanks,
Arunkumar S P

Abs-225476 Hall of Fame Points: 3483 More actions · Answer 3

Yes this does work but how do I add the £ sign in front of the value.

="Your account balance is "&" "& format(round(fields!test.Value,2),"#,##")

Abs-225476 Hall of Fame Points: 3483 More actions · Answer 4

I think I have just answered it myself 😉 . just code the £ sign in front of the field

Jeff Moden SSC Guru Points: 1004312 More actions · Answer 5

😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Abs-225476 Hall of Fame Points: 3483 More actions · Answer 6

I forgot about the dates, how do I format the date in Day monthname and year format?