I have a report that that when printed, produces two reports with all of the same results except one field.
One table has the ability to have more than one answers in it. When I print the report it puts one answer on one report and the other answer on another report. What I would like to do is to have both answers on the same line in one report. any help please. The table with multiple answers in it is linked to the main table with a common field "INCIDENT.ID". I've tried 'equal join', 'left outer', right outer' and others without any luck. I,ve also reversed the link, no luck.
Thanks.
CR8.5
ODBC
Oricle
Phillipg
One table has the ability to have more than one answers in it. When I print the report it puts one answer on one report and the other answer on another report. What I would like to do is to have both answers on the same line in one report. any help please. The table with multiple answers in it is linked to the main table with a common field "INCIDENT.ID". I've tried 'equal join', 'left outer', right outer' and others without any luck. I,ve also reversed the link, no luck.
Thanks.
CR8.5
ODBC
Oricle
Phillipg