zeros and negatives wont display
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21593
Printed Date: 29 Apr 2024 at 1:33am
Topic: zeros and negatives wont display
Posted By: shatcher94
Subject: zeros and negatives wont display
Date Posted: 10 Jul 2015 at 1:37am
|
I have a report that has multiple 0 values, but instead of showing the zero, crystal shows a blank space instead. then, 2 columns over i have a field that should subtract another field from that 0 and be negative, but since the zero field is empty, it wont and the sum comes up empty two. Any idea how to fix this?
|
Replies:
Posted By: hilfy
Date Posted: 10 Jul 2015 at 4:11am
Are the fields truly 0 or are they "null"? To tell for sure, try this:
Create a formula using the field. Is should look something like this:
If IsNull({MyTable.MyField}) then 0 else {MyTable.MyField})
Use this on your report instead of the field. If it now shows "0", then the field is null. If this is the case, you'll also need to use this formula when you're subtracting in order to get a value to show.
-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
Posted By: shatcher94
Date Posted: 10 Jul 2015 at 4:13am
|
that worked, null was the issue
|
|