Author |
Message |
ri88
Newbie
Joined: 30 Aug 2010
Online Status: Offline
Posts: 10
|
Topic: Crystal Report problem Posted: 30 Aug 2010 at 5:01pm |
I want to create crostab table from the database.
The row consist of date each year and the couloum consist of location of the warehouse. However, there are some user who have not fill the couloum (meaning the location was blank).
the problem happened when i filter one location (for example KAKA). the result is not only KAKA coloum was filtered, but also the blank coloum was not displayed after i filtered KAKA coloum.
Anybody can help?
|
IP Logged |
|
sukhveer
Newbie
Joined: 18 Aug 2010
Online Status: Offline
Posts: 22
|
Posted: 30 Aug 2010 at 8:57pm |
Easy way?
Go to your database and update all your Null values for location to some default value like 'No location'... then you should be good.
Will let you know if it can be done from crystal end.
|
IP Logged |
|
ri88
Newbie
Joined: 30 Aug 2010
Online Status: Offline
Posts: 10
|
Posted: 31 Aug 2010 at 4:26pm |
How to update the null value to no location? because the database is restricted to every one for updating. Can we update this in the crystal report if we cannot modify in the database?
|
IP Logged |
|
Senthil Raj
Newbie
Joined: 02 Aug 2010
Location: India
Online Status: Offline
Posts: 27
|
Posted: 31 Aug 2010 at 8:02pm |
if you are using a select query to retrieve data then you can handle in
query as isnull(field_name,'No location') or nvl(field_name,'No location')
|
IP Logged |
|
ri88
Newbie
Joined: 30 Aug 2010
Online Status: Offline
Posts: 10
|
Posted: 01 Sep 2010 at 9:14pm |
How To create query in the crosstab table:
in the coloum: null value, X Location, Y Location
in the row : Year 2008, Year 2009
Because if we use filter, it also remove the null value in the coloum (the things that we also want to see)
|
IP Logged |
|
ri88
Newbie
Joined: 30 Aug 2010
Online Status: Offline
Posts: 10
|
Posted: 02 Sep 2010 at 10:57pm |
Crosstab table.
This table below is before i filter the X location.
|
|
X |
Y |
Z |
1993 |
123 |
12 |
32 |
354 |
1994 |
123 |
34 |
2 |
4 |
1995 |
43 |
35 |
23 |
435 |
1996 |
65 |
325 |
34 |
132 |
However, when i filter X coloum, the null coloum also was filtered.
|
Y |
Z |
1993 |
32 |
354 |
1994 |
2 |
4 |
1995 |
23 |
435 |
1996 |
34 |
132 | Could we just filter the X without filter the null? Because i use select expert and just filter X.
|
IP Logged |
|
ri88
Newbie
Joined: 30 Aug 2010
Online Status: Offline
Posts: 10
|
Posted: 20 Sep 2010 at 9:35pm |
|
IP Logged |
|
Senthil Raj
Newbie
Joined: 02 Aug 2010
Location: India
Online Status: Offline
Posts: 27
|
Posted: 21 Sep 2010 at 12:47am |
use selection expert to use that query
|
Live And Let Live...
|
IP Logged |
|
ri88
Newbie
Joined: 30 Aug 2010
Online Status: Offline
Posts: 10
|
Posted: 21 Sep 2010 at 4:07pm |
i already use select expert to exclude X coloum, however, the blank coloum near x also filtered. how to fix it?
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 22 Sep 2010 at 4:34am |
Are you using an outer join in this report?
|
IP Logged |
|
|