I'm using Crystal 9 with csv files. CLASS_csv and CLASS_NEW_csv. I'm trying to show what data entry changes were made.
Friday Data: CLASS_csv
class pattern_nbr days start_time start_date
101 1 M W 10:00 10/20/2014
102 1 T 09:00 10/21/2014
102 2 F 10:00 10/24/2014
103 1 M W 10:00 10/20/2014
=================================================
Monday Data: CLASS_NEW_csv
class pattern_nbr days start_time start_date
101 1 M 09:00 10/20/2014
101 2 W 10:00 10/22/2014
102 1 T F 09:00 10/21/2014
103 1 M W 10:00 10/20/2014
=================================================
I need the report to show:
class pattern_nbr days start_time start_date
NOW: 101 1 M 09:00 10/20/2014
101 2 W 10:00 10/22/2014
WAS: 101 1 M W 10:00 10/20/2014
NOW: 102 1 T F 09:00 10/21/2014
WAS: 102 1 T 09:00 10/21/2014
102 2 F 10:00 10/24/2014
I wouldn't want class 103 to show since there weren't changes.
=================================================
I have the CLASS_NEW_csv left outer joined = to CLASS_csv on the class field. I'm not sure how to go on from there (grouping, etc.)
Help is appreciated!
Thanks
Friday Data: CLASS_csv
class pattern_nbr days start_time start_date
101 1 M W 10:00 10/20/2014
102 1 T 09:00 10/21/2014
102 2 F 10:00 10/24/2014
103 1 M W 10:00 10/20/2014
=================================================
Monday Data: CLASS_NEW_csv
class pattern_nbr days start_time start_date
101 1 M 09:00 10/20/2014
101 2 W 10:00 10/22/2014
102 1 T F 09:00 10/21/2014
103 1 M W 10:00 10/20/2014
=================================================
I need the report to show:
class pattern_nbr days start_time start_date
NOW: 101 1 M 09:00 10/20/2014
101 2 W 10:00 10/22/2014
WAS: 101 1 M W 10:00 10/20/2014
NOW: 102 1 T F 09:00 10/21/2014
WAS: 102 1 T 09:00 10/21/2014
102 2 F 10:00 10/24/2014
I wouldn't want class 103 to show since there weren't changes.
=================================================
I have the CLASS_NEW_csv left outer joined = to CLASS_csv on the class field. I'm not sure how to go on from there (grouping, etc.)
Help is appreciated!
Thanks