Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.


Zero Values is not displaying in my Crystal Report

Zero Values is not displaying in my Crystal Report

When I generate the report based on my parameter those purchased transaction with zero amount in details for example is

Item 1 = 1,000
Item 2 = 0.00
Item 3 = 0.00

The Item 2 & 3 is not displaying in my details. im having a hard time now.

RE: Zero Values is not displaying in my Crystal Report

If there is no data for those items then they will not display.

Try adding a item list table and then joining your data to it using a left outer join.

All items will then display even if no data present. You will need to change your result column to a formula so that a zero displays if no data exists


RE: Zero Values is not displaying in my Crystal Report


Thanks Ian!

I tried joining data on my table however my problem is the OCRD and CRD1 (details of customer or vendor).
Every time I tried to insert the content the zero values were gone though it was connected in left outer join.

How can In change my result column into a formula? Any recommended formula, I already remove the check of all the suppressed by zero hoping it will solved my problem yet it still not working.


RE: Zero Values is not displaying in my Crystal Report

Do you have a filter on the joined table.
That will override the left outer join

So if you have a filter eg

Table2.field1 = 'X'

Try changing to

(Table2.field1 is null or Table2.field1 = 'X')


RE: Zero Values is not displaying in my Crystal Report

Ian, you can't solve a filtered outer join with an IsNull check in most cases. It will work if the only two options are a matching "X" record or no matching record. But if there are any matching "Y" records it will fail. There won't be a Null value because it found a match, but the match won't be an X. You will then lose your record. There is a better write-up here:

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close