Post reply

Format Expression problem

  • March 17, 2009 at 1:16 pm

    #198089

    hi,

    I have a problem whit this expression, i need to convert the integer values into money values, im using the following format but it doesnt work.

    =Format(Fields!D1AuxiliarOpSOP.Value,"##0'##0.##0")

    But it doesnt work.

    Thank you any help

  • March 17, 2009 at 1:39 pm

    #961347

    In the textbox that this value is displayed in, rather than an expression like you are using to format the value itself, just set the format property of the textbox itself.

    textbox value property = Fields!D1AuxiliarOpSOP.Value

    textbox format property = C2 (currency format, 2 decimals...)

    HAve a look at the following if you need more help with format strings...

    http://msdn.microsoft.com/en-us/library/dwhawy9k.aspx

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • March 17, 2009 at 2:10 pm

    #961371

    when i put the format value =C2(currency format, 2 decimals) it appear an error:

    Error1La expresión Format del objeto ‘D1AuxiliarOpSOP’ de tipo textbox contiene un error: [BC30451] No se ha declarado el nombre 'C2'.

    The object "C2" it haven been declared.

    Thank you any help.

  • March 17, 2009 at 2:16 pm

    #961377

    Sorry the stuff in () was just an explanation of what it does...

    Just put C2 in the format property.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • March 17, 2009 at 2:17 pm

    #961378

    Oh yeah, and no hablo Espanol so if you could translate the error message that would be helpful.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • March 17, 2009 at 2:28 pm

    #961388

    jeje, thank you! Luke, that was the error.

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

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