Problem in crystal report null value.

Discussion in 'Software' started by priyamtheone, Sep 24, 2008.

  1. priyamtheone

    priyamtheone

    Joined:
    Jul 29, 2008
    Messages:
    6
    Likes Received:
    0
    Hello everyone,
    I hav been facing a problem since a few days. I'm using crystal report with vb.net 2005 (.Net framework 2.0). In a report I'm retrieving the values from a database table and showing it. But the problem is that if a certain field is blank in database then it's showing a complete blank white field in the report also. This is what I don't want. For example- suppose there's a field in datbase named EntryDate which is not mandatory. So for a certain row if there's an entry for EntryDate it'll show it in the report otherwise if it's blank or null in database it'll show a user defined string in the report say 'Not Available' or something like that. For this I hav tried playing with the ZeroValueString property of the respective field in the crystal report also but of no avail. How can I solve it. Plz help with some code example.
    Regards.
     
    Last edited: Sep 24, 2008
    priyamtheone, Sep 24, 2008
    #1
    1. Advertisements

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.