Post reply

Paranthesis alignment and Negative Number

  • December 27, 2010 at 5:57 pm

    #232391

    I am representing negative number within parenthesis , but as I am working on reporting service, it is possible to make the exact alignment of the number and parenthesis.

    123,345

    (145,567)

    How can I make this alignment like

    123,345

    (145,567)

    where the parenthesis will be outside the number space keeping in mind the alignment is in right .

    Thanks

    Ragha

  • December 28, 2010 at 7:09 am

    #1266714

    I would start by trying an expression in the right padding that if the number was a positive number the padding was greater. You will have to experiment a bit to get the alignment you want, but you should be able to get it.

  • December 28, 2010 at 1:11 pm

    #1266901

    Hi

    Thanks for reply.I will try to research...plz let me know if you know anything more about it.

    Thanks

    Ragha

  • December 28, 2010 at 8:56 pm

    #1267000

    ry.sqldev (12/27/2010)

    I am representing negative number within parenthesis , but as I am working on reporting service, it is possible to make the exact alignment of the number and parenthesis.

    123,345

    (145,567)

    How can I make this alignment like

    123,345

    (145,567)

    where the parenthesis will be outside the number space keeping in mind the alignment is in right .

    Thanks

    Ragha

    --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 29, 2010 at 7:43 am

    #1267171

    ry.sqldev (12/28/2010)

    Hi

    Thanks for reply.I will try to research...plz let me know if you know anything more about it.

    Thanks

    Ragha

    In VS2008, right click your field and choose Text Box Properties. Click on the Alignment tab and you will see the padding options. Click on the Fx button to build an expression for the selected padding.

  • December 31, 2010 at 1:04 pm

    #1268176

    Jeff Moden (12/28/2010)

    ry.sqldev (12/27/2010)

    I am representing negative number within parenthesis , but as I am working on reporting service, it is possible to make the exact alignment of the number and parenthesis.

    123,345

    (145,567)

    How can I make this alignment like

    123,345

    (145,567)

    where the parenthesis will be outside the number space keeping in mind the alignment is in right .

    Thanks

    Ragha

    Apologies for that post. I apparently hit quote to see the alignment and then hit reply... but I didn't mean to.

    --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

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

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