pbare
Well Known Member
I have been asked to produce a report that shows any changes made to an Employee's information (F08042, F060116, F0115, F0111,F06017, F060117, F0101,F05115,F08330). All records must be of type E (F0101.At1) and in the date range specified in the processing options
The data must show all the information for 1 employee before printing the next employee and can have changes in 1 or more sections.
My initial design consisted of creating a master list of any changes that have occurred and then go back and print the information out.
But I don't know if this will be slow with the number of tables that I have to code against. I was also thinking of subsection joins but don't know too much about those.
If would appreciate any thoughts that anyone has (I am going to attach a sample of what the report should look like). In the spreadsheet are several tabs listing the different data types that I have to look at for the different sections of the report)
Thanks in advance
Pam
The data must show all the information for 1 employee before printing the next employee and can have changes in 1 or more sections.
My initial design consisted of creating a master list of any changes that have occurred and then go back and print the information out.
But I don't know if this will be slow with the number of tables that I have to code against. I was also thinking of subsection joins but don't know too much about those.
If would appreciate any thoughts that anyone has (I am going to attach a sample of what the report should look like). In the spreadsheet are several tabs listing the different data types that I have to look at for the different sections of the report)
Thanks in advance
Pam