Good Morning folks. I really couldn't come up with a smart enough Subject Line but I will try and make it up in the body.
I currently have a report that accepts Parameters on the Parameter Form. They are
Employee ID# and
Number of Copies. The Employee ID is stored in the Employee table but the number of copies is not.
The output on the Report shows all the different addresses and Phone Numbers the Employee has. Lets say, Employee ID 0001 has two addresses -- Home and Office. In the Report output based on my Query, it is going to return me two records in the Repeating Group. I however, have another parameter along with the Employee ID which is the Number of Copies. In this case, if the Number of Copies to be printed is 1, then its not an issue. However, if the
Number of Copies entered by the User is 4, I would expect in that case 4 x 2 = 8 pages of Report output (4 with the Home Address and 4 with the Office Address).
I know there is way to do this using a
Temporary table in
AfterPForm and then using the results in the Query by joining my query to the Temporary table but I was really hoping to avoid this situation if it can be handled through the Query.
Main Query:
SELECT e.emp_no,
e.saln||e.first_name||' '||e.last_name emp_name,
a.street,
a.city||' '||a.province||' '||a.postal_code city,
'('||a.tel_area||') '||a.tel_number telephone
FROM employee e, emp_address a
WHERE e.emp_no = a.emp_no
AND e.emp_no = :P_EMP_NO;
Any help is appreciated. Thanks!