Results 1 to 3 of 3

Thread: [RESOLVED] how do i change field value 0 to Blank in crystal report 8.5?

  1. Oct 25th, 2012, 08:49 AM #1
    kaushal.jam
    kaushal.jam is offline

    Thread Starter
    Lively Member
    Join Date
    Jul 2012
    Posts
    90

    Resolved [RESOLVED] how do i change field value 0 to Blank in crystal report 8.5?

    hi all,

    i am using crystal report 8.5 and vb6 for code and access for database.

    now in my table some fields have its value " 0 " and those are numeric fields. now i dont want to display " 0 " in those fields when i create a report in crystal report 8.5.

    can anyone help for that?

    Please Help ASAP....thanks in advance...

    kaushal
    Reply With Quote Reply With Quote
  2. Oct 25th, 2012, 02:55 PM #2
    jggtz
    jggtz is offline
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: how do i change field value 0 to Blank in crystal report 8.5?

    Right click over each field (or you could multiselect fields)
    A popup menu appear
    Select "Format Field"
    A "Format Editor" window appear
    Select "Number" tab
    Click "Customize" button
    Check "Suppress If Zero"
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...
    Reply With Quote Reply With Quote
  3. Oct 26th, 2012, 04:22 AM #3
    kaushal.jam
    kaushal.jam is offline

    Thread Starter
    Lively Member
    Join Date
    Jul 2012
    Posts
    90

    Re: how do i change field value 0 to Blank in crystal report 8.5?

    THANKS A LOT JGGTZ. its nicely done...

    Kaushal
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width