INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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.

Jobs

Zero Values is not displaying in my Crystal Report

Zero Values is not displaying in my Crystal Report

(OP)
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

Ian

RE: Zero Values is not displaying in my Crystal Report

(OP)

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.


Jessica

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

Ian

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: http://kenhamady.com/cru/archives/1489

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
http://www.kenhamady.com/

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!

Resources

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