How can I report on a field that doesn't exist?
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22567
Printed Date: 03 May 2024 at 4:54am
Topic: How can I report on a field that doesn't exist?
Posted By: dan231
Subject: How can I report on a field that doesn't exist?
Date Posted: 30 Mar 2018 at 6:45am
I have a custom table/field that is built into a report.
The formula is as follows:
if {APPLICATIONPROPERTY.ITEM_NAME} = "OXLN_DP_SOLD_BY"
then {APPLICATIONPROPERTY.APPLICATION_ITEM_VALUE}
else ""
The problem is that I have 1 record that is missing in the report because this custom record doesn't exist, so the report skips it. How can I modify the formula to still include the data if this field doesn't exist?
-------------
Thanks,
Dan
|
Replies:
Posted By: DBlank
Date Posted: 02 Apr 2018 at 3:11am
|
set the formula to use 'default values for nulls'
|
Posted By: dan231
Date Posted: 02 Apr 2018 at 3:14am
I am not sure how to do that.
Can you please elaborate on that?
-------------
Thanks,
Dan
|
Posted By: dan231
Date Posted: 02 Apr 2018 at 3:34am
ok..in report option I found Convert Database NULL to Default land Convert other Noll to default.
I tried both of those options and my 1 record is still not displaying
-------------
Thanks,
Dan
|
Posted By: kevlray
Date Posted: 02 Apr 2018 at 6:49am
Sounds like a table join issue to me. Because if {APPLICATIONPROPERTY.ITEM_NAME} is Null or not equal to "OXLN_DP_SOLD_BY" then you return the "".
|
Posted By: DBlank
Date Posted: 02 Apr 2018 at 7:00am
Kevlray may be onto something. I assumed your joins were OK.
However, inside the Formula Editor there should be an option (pick list) on how to handle nulls. You can set this per formula.
|
|