| Author |
Message |
siktui82
Newbie
Joined: 20 Jun 2007
Online Status: Offline
Posts: 8
|
   Topic: Data missing after adding new column
Posted: 27 Jun 2007 at 8:14pm |
HI,
Apparently when i added new column into exisiting CR, some of my data missing. how do i get it back?
Attached screen shorts.
p/s; the new column add-in is from another Table.    Original CR COL1 COL2 COL3 COL4 a a a a b b b b c c c c Amended CR COL1 COL2 COL3 COL4 COL5
a a a a a
c c c c c
 
|
 IP Logged |
|
|
BrianBischof
Admin Group
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
|
Posted: 27 Jun 2007 at 8:31pm |
|
I'm thinking that when you added the new table that you had to join it on a field. The new table doesn't have "b" in its table and thus that record got dropped out of the final results since there isn't a matching record between the two tables.
|
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
|
|
IP Logged |
|
siktui82
Newbie
Joined: 20 Jun 2007
Online Status: Offline
Posts: 8
|
Posted: 27 Jun 2007 at 8:44pm |
|
Ya. the new table is without 'b' in it. but what can i do to make it shown?
Thanks
|
|
IP Logged |
|
BrianBischof
Admin Group
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
|
Posted: 27 Jun 2007 at 8:54pm |
|
change the join property with the link and make it show all rows from table A. This is effectively a "left outer join" in SQL.
|
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
|
|
IP Logged |
|
siktui82
Newbie
Joined: 20 Jun 2007
Online Status: Offline
Posts: 8
|
Posted: 27 Jun 2007 at 10:17pm |
|
Hi Brian,
I tried but doesn't work.
SQL statement
SELECT
ARINV."INVNO", ARINV."CUSTNO", ARINV."CUSTNAME", ARINV."INVSTATUS", ARINV."INVDATE", ARINV."BILLINVAMT", ARINV."TTLINVCOST", ARINV."INVREM", ARINV."GSTAMT", ARINV."CGSTAMT",
ARINVREC."PAYTYPE"
FROM
ARINV left outer join arinvrec on arinv.invno=arinvrec.invno
WHERE
ARINV."INVNO" = ARINVrec."INVNO"
|
|
IP Logged |
|
siktui82
Newbie
Joined: 20 Jun 2007
Online Status: Offline
Posts: 8
|
Posted: 27 Jun 2007 at 10:33pm |
|
Hi Brian,
Think i found out the error, i remove the where clause. it work fine
Thanks.
|
|
IP Logged |
|
BrianBischof
Admin Group
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
|
Posted: 27 Jun 2007 at 10:35pm |
|
Great. Glad it works.
|
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
|
|
IP Logged |
|
|
|
