Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
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
Joined: 30 Aug 2010
Online Status: Offline
Posts: 10
Posted: 27 Sep 2010 at 4:27pm
Joined: 19 Dec 2008 Location: United States Online Status: Offline Posts: 3534
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
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
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.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
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.
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