Zero Values is not displaying in my Crystal Report

[JessicaMesa78910]

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.

 

[IanWaterman]

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

 

[JessicaMesa78910]

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

 

[IanWaterman]

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

 

[kenhamady]

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/