Post reply

Expressions

  • 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

  • December 2, 2009 at 8:05 pm

    #1086860

    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)
    Intro to Tally Tables and Functions

  • December 2, 2009 at 9:04 pm

    #1086877

    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

  • December 3, 2009 at 2:58 am

    #1086970

    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),"#,##")

  • December 3, 2009 at 3:32 am

    #1086973

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

  • December 3, 2009 at 8:16 am

    #1087114

    😉

    --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)
    Intro to Tally Tables and Functions

  • December 3, 2009 at 9:36 am

    #1087211

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

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

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