christimess
Programmer
Hi,
I am trying to create a report that uses AL_CHK_DATA (for the TEMP_DEPTID and AL_CHK_HRS_ERN (to pull the earnings that go with the TEMP_DEPTID).
I can have up to 9 TEMP_DEPTID's and neeed to find a way to include all of them in one report, one line for each TEMP_DEPTID.
In looking at the report I can see that I somehow want to say ENTRY_NBR 1 from the AL_CHK_DATA equals ENTRY_NBR 1 from the AL_CHK_HRS_ERN. ENTRY_NBR 2 from the AL_CHK_DATA equals ENTRY_NBR 2 from the AL_CHK_HRS_ERN. (and the same for 3, 4, 5, 6, 7, 8, 9.)
I would think that I would want one table for each ENTRY_NBR, but that would be 2 tables per number, which means a total of 18 tables. Then I have additional tables in this report such as PERSONAL_DATA and JOB. I am concerned about creating a report with over 20 tables. Has anyone tried anything like this? Is this to many tables?
Any help that anyone can give me I would appreciate it.
I am trying to create a report that uses AL_CHK_DATA (for the TEMP_DEPTID and AL_CHK_HRS_ERN (to pull the earnings that go with the TEMP_DEPTID).
I can have up to 9 TEMP_DEPTID's and neeed to find a way to include all of them in one report, one line for each TEMP_DEPTID.
In looking at the report I can see that I somehow want to say ENTRY_NBR 1 from the AL_CHK_DATA equals ENTRY_NBR 1 from the AL_CHK_HRS_ERN. ENTRY_NBR 2 from the AL_CHK_DATA equals ENTRY_NBR 2 from the AL_CHK_HRS_ERN. (and the same for 3, 4, 5, 6, 7, 8, 9.)
I would think that I would want one table for each ENTRY_NBR, but that would be 2 tables per number, which means a total of 18 tables. Then I have additional tables in this report such as PERSONAL_DATA and JOB. I am concerned about creating a report with over 20 tables. Has anyone tried anything like this? Is this to many tables?
Any help that anyone can give me I would appreciate it.