Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Crystal Report problem Post Reply Post New Topic
<< Prev Page  of 2
Author Message
ri88
Newbie
Newbie


Joined: 30 Aug 2010
Online Status: Offline
Posts: 10
Quote ri88 Replybullet Posted: 22 Sep 2010 at 3:16pm
should we use outer join or not?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 23 Sep 2010 at 3:45am
i do not know as i have never seen the data or table structure but if you added a select statement that may have turned the outer join into an inner join.
more likely you did something like a sleect statment of
field<>'X'
go back into the select expert and there is a setting (pick list) for NULLS
change it to use 'Default Values For Nulls'
IP IP Logged
ri88
Newbie
Newbie


Joined: 30 Aug 2010
Online Status: Offline
Posts: 10
Quote ri88 Replybullet Posted: 27 Sep 2010 at 5:03am
How i know if i already have turned the outer join into an inner join.
because i already chose the outer join in the database link in database expert.
 
What does it mean
Change it to use 'Default Values For Nulls' in the select expert?
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 27 Sep 2010 at 5:11am
Open the select expert
click on the show formula
click on the formula editor
In here there is the 'Expression Editor'
In the expression editor there is a pick list option that is likely defaulted to use 'Exceptions for Null'
change this to use 'Default values for Nulls'
IP IP Logged
ri88
Newbie
Newbie


Joined: 30 Aug 2010
Online Status: Offline
Posts: 10
Quote ri88 Replybullet Posted: 27 Sep 2010 at 4:27pm


Joined: 19 Dec 2008
Location: United States
Online Status: Offline
Posts: 3534
Quote DBlank Replybullet Posted: Today at 5:11am
Open the select expert
click on the show formula
click on the formula editor
In here there is the 'Expression Editor'
In the expression editor there is a pick list option that is likely defaulted to use 'Exceptions for Null'
change this to use 'Default values for Nulls'


Joined: 19 Dec 2008
Location: United States
Online Status: Offline
Posts: 3534
Quote DBlank Replybullet Posted: Today at 5:11am
Open the select expert
click on the show formula
click on the formula editor
In here there is the 'Expression Editor'
In the expression editor there is a pick list option that is likely defaulted to use 'Exceptions for Null'
change this to use 'Default values for Nulls'


Joined: 19 Dec 2008
Location: United States
Online Status: Offline
Posts: 3534
Quote DBlank Replybullet Posted: Today at 5:11am
Open the select expert
click on the show formula
click on the formula editor
In here there is the 'Expression Editor'
In the expression editor there is a pick list option that is likely defaulted to use 'Exceptions for Null'
change this to use 'Default values for Nulls'
I already see the null in the usual table. however, the null didn't appear in the crostab table when we filter one coloum using select expert. and the null appear again when we didn't filter one coloum.

and this is just happen when i created the crostab table.

anybody can help?

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Sep 2010 at 4:04am

That was whta i was trying tot tell you. IN your select statment you did not tellit how to handle nulls so it omits them. By changing that option it tells it what to do. YOu could also change your selecy statment if you want.

isnull(field) or field<>'X'
IP IP Logged
ri88
Newbie
Newbie


Joined: 30 Aug 2010
Online Status: Offline
Posts: 10
Quote ri88 Replybullet Posted: 04 Oct 2010 at 12:29am
 
I tried
 
If IsNull({YourField}) then "Empty"
else {YourField}
 
and it worked. Thanks for your help.
IP IP Logged
<< Prev Page  of 2
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.031 seconds.