Crystal 2008 running on top of ORACLE 10g.
I have a report made up of three (3) tables -
EVALUATION_CASE
BOARD_MEETING
COMM_MEETING
There can be MEETING details for a single CASE_ID in both MEETING tables - but I only want to show the details of BOARD_MEETING or COMM_MEETING based on the CASE_CLASS value in EVALUATION_CASE.
CASE_CLASS = 'B' then only show details from BOARD_MEETING table.
CASE_CLASS = 'C' then only show details from COMM_MEETING table.
I will post the table examples below - but what I am trying to accomplish is to DYNAMIC LINK the tables based on the CASE_CLASS value in EVALUATION_CASE. I assume this would require some kind of a COMMAND...but I can't figure it out.
Thanks in advance for any help or advice!
Table = EVALUATION_CASE
CASE_ID EVALUATION_ID CASE_CLASS
----------------------------------------------------------
1012 5001 B
1012 5002 B
1012 5003 B
1013 5004 C
1014 5005 B
1015 5006 B
1016 5007 C
1016 5008 C
1017 5009 B
----------------------------------------------------------
Table = BOARD_MEETING
EVALUATION_ID BOARD_MEETING_ID BOARD_MEETING_DATE
----------------------------------------------------------
5002 6013 07/06/2011
5003 6014 20/06/2011
5004 6015 06/06/2011
5005 6016 07/06/2011
5007 6017 06/06/2011
5007 6018 07/06/2011
5009 6019 20/06/2011
----------------------------------------------------------
Table = COMM_MEETING
EVALUATION_ID COMM_MEETING_ID COMM_MEETING_DATE
----------------------------------------------------------
5002 6013 28/05/2011
5004 6014 29/05/2011
5005 6015 28/05/2011
5006 6016 29/05/2011
5007 6017 28/05/2011
5008 6018 28/05/2011
5008 6019 29/05/2011
----------------------------------------------------------
RESULTS
CASE_ID EVALUATION_ID MEETING_ID MEETING_DATE
----------------------------------------------------------
1012 5001 <NULL> <NULL>
1012 5002 6013 07/06/2011
1012 5003 6014 20/06/2011
1013 5004 6014 29/05/2011
1014 5005 6016 07/06/2011
1015 5006 <NULL> <NULL>
1016 5007 6017 28/05/2011
1016 5008 6018 28/05/2011
1016 5008 6019 29/05/2011
1017 5009 6019 20/06/2011
----------------------------------------------------------
Senior Business Intelligence Consultant
Toronto, Canada
SeagateInfo 7 -> Crystal Enterprise -> BOE-XI (R2) / (R3.1) | Crystal ( 7 -> 2008) design | WebI design | Best practices for Java / .Net / Web Services
I have a report made up of three (3) tables -
EVALUATION_CASE
BOARD_MEETING
COMM_MEETING
There can be MEETING details for a single CASE_ID in both MEETING tables - but I only want to show the details of BOARD_MEETING or COMM_MEETING based on the CASE_CLASS value in EVALUATION_CASE.
CASE_CLASS = 'B' then only show details from BOARD_MEETING table.
CASE_CLASS = 'C' then only show details from COMM_MEETING table.
I will post the table examples below - but what I am trying to accomplish is to DYNAMIC LINK the tables based on the CASE_CLASS value in EVALUATION_CASE. I assume this would require some kind of a COMMAND...but I can't figure it out.
Thanks in advance for any help or advice!
Table = EVALUATION_CASE
CASE_ID EVALUATION_ID CASE_CLASS
----------------------------------------------------------
1012 5001 B
1012 5002 B
1012 5003 B
1013 5004 C
1014 5005 B
1015 5006 B
1016 5007 C
1016 5008 C
1017 5009 B
----------------------------------------------------------
Table = BOARD_MEETING
EVALUATION_ID BOARD_MEETING_ID BOARD_MEETING_DATE
----------------------------------------------------------
5002 6013 07/06/2011
5003 6014 20/06/2011
5004 6015 06/06/2011
5005 6016 07/06/2011
5007 6017 06/06/2011
5007 6018 07/06/2011
5009 6019 20/06/2011
----------------------------------------------------------
Table = COMM_MEETING
EVALUATION_ID COMM_MEETING_ID COMM_MEETING_DATE
----------------------------------------------------------
5002 6013 28/05/2011
5004 6014 29/05/2011
5005 6015 28/05/2011
5006 6016 29/05/2011
5007 6017 28/05/2011
5008 6018 28/05/2011
5008 6019 29/05/2011
----------------------------------------------------------
RESULTS
CASE_ID EVALUATION_ID MEETING_ID MEETING_DATE
----------------------------------------------------------
1012 5001 <NULL> <NULL>
1012 5002 6013 07/06/2011
1012 5003 6014 20/06/2011
1013 5004 6014 29/05/2011
1014 5005 6016 07/06/2011
1015 5006 <NULL> <NULL>
1016 5007 6017 28/05/2011
1016 5008 6018 28/05/2011
1016 5008 6019 29/05/2011
1017 5009 6019 20/06/2011
----------------------------------------------------------
Senior Business Intelligence Consultant
Toronto, Canada
SeagateInfo 7 -> Crystal Enterprise -> BOE-XI (R2) / (R3.1) | Crystal ( 7 -> 2008) design | WebI design | Best practices for Java / .Net / Web Services