remove decimal from crystal report

Discussion in 'Microsoft VB .NET' started by jaYPee, Jan 28, 2005.

  1. jaYPee

    jaYPee Guest

    I have a report created in crystal report. My problem is on how can I
    remove the decimal point without converting the value.

    say for example if I have this data:

    Unit
    2
    1.5
    2
    3

    Crystal Reports automatically convert the 1.5 to 2. in this case my
    report display this data.

    2
    2
    2
    3

    anyone know how to display data in a report without the use of crystal
    report's own formating?
     
    jaYPee, Jan 28, 2005
    #1
    1. Advertisements

  2. jaYPee

    Peter Proost Guest

    This is a vb.net group but if you in crystal reports right click the field
    then choose format field and then the number tap I think you should find
    your answer there

    hth

    Greetz Peter

    "jaYPee" <> wrote in message
    news:...
    > I have a report created in crystal report. My problem is on how can I
    > remove the decimal point without converting the value.
    >
    > say for example if I have this data:
    >
    > Unit
    > 2
    > 1.5
    > 2
    > 3
    >
    > Crystal Reports automatically convert the 1.5 to 2. in this case my
    > report display this data.
    >
    > 2
    > 2
    > 2
    > 3
    >
    > anyone know how to display data in a report without the use of crystal
    > report's own formating?
     
    Peter Proost, Jan 28, 2005
    #2
    1. Advertisements

  3. jaYPee

    jaYPee Guest

    Yah I go to the format menu but don't know what formula should I use.
    I don't want to use the formating of crystal reports so that it must
    be based on the record on my table.

    thanks


    On Fri, 28 Jan 2005 09:34:00 +0100, "Peter Proost"
    <> wrote:

    >This is a vb.net group but if you in crystal reports right click the field
    >then choose format field and then the number tap I think you should find
    >your answer there
    >
    >hth
    >
    >Greetz Peter
    >
    >"jaYPee" <> wrote in message
    >news:...
    >> I have a report created in crystal report. My problem is on how can I
    >> remove the decimal point without converting the value.
    >>
    >> say for example if I have this data:
    >>
    >> Unit
    >> 2
    >> 1.5
    >> 2
    >> 3
    >>
    >> Crystal Reports automatically convert the 1.5 to 2. in this case my
    >> report display this data.
    >>
    >> 2
    >> 2
    >> 2
    >> 3
    >>
    >> anyone know how to display data in a report without the use of crystal
    >> report's own formating?

    >
     
    jaYPee, Jan 28, 2005
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. GaryB

    truncating a decimal to 2 decimal places??

    GaryB, Sep 8, 2004, in forum: Microsoft VB .NET
    Replies:
    5
    Views:
    388
    Ken Tucker [MVP]
    Sep 8, 2004
  2. Stu
    Replies:
    2
    Views:
    363
  3. Scott
    Replies:
    1
    Views:
    481
    Guest
    Mar 3, 2005
  4. Scott
    Replies:
    2
    Views:
    287
    chanmmn
    Mar 6, 2005
  5. John Smith
    Replies:
    0
    Views:
    833
    John Smith
    Jan 17, 2007
Loading...

Share This Page