Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: How can I report on a field that doesn't exist? Post Reply Post New Topic
Author Message
dan231
Newbie
Newbie


Joined: 03 Oct 2014
Online Status: Offline
Posts: 13
Quote dan231 Replybullet Topic: How can I report on a field that doesn't exist?
    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
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 02 Apr 2018 at 3:11am
set the formula to use 'default values for nulls'
IP IP Logged
dan231
Newbie
Newbie


Joined: 03 Oct 2014
Online Status: Offline
Posts: 13
Quote dan231 Replybullet Posted: 02 Apr 2018 at 3:14am
I am not sure how to do that.
Can you please elaborate on that?
Thanks,
Dan
IP IP Logged
dan231
Newbie
Newbie


Joined: 03 Oct 2014
Online Status: Offline
Posts: 13
Quote dan231 Replybullet 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
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet 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 "".
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.