Hello. I am trying to write a report showing only records that meed certain criteria.
I have a table with employee number and pay code for instance. The employee record is repeated for every pay code record. I have grouped by employee, and listed the paycodes in that group. The problem is, I only want to see records where pay code =910 and/or =990.
If they have 990 only i want to see it.
If they have 990 and 910 i want to see it.
If they have 990 and paycodes other than 910 i don't want to see it.
If they have 990, 910 and other paycodes i don't want to see it.
I can't use the select expert because if i set that equal 910 or 990 then it will pull only those records even if the employee has additional paycodes. The evaluation has to happen after ALL of the records have been pulled into the report. I wrote running totals to count the 990 and 910 paycodes for each employee group and to count the total number of different paycodes for each employee group. I then tried to suppress each section based on a comparisong of these results. The problem is, i can't evaluate group selection on running totals because the totals aren't computed until the data is pulled.
Question is....
How can i see all employees (grouped) that have either 910 only, 990 only, or 910 and 990 only?
Sounds simple but I can't figure it out.
Thanks in advance
I have a table with employee number and pay code for instance. The employee record is repeated for every pay code record. I have grouped by employee, and listed the paycodes in that group. The problem is, I only want to see records where pay code =910 and/or =990.
If they have 990 only i want to see it.
If they have 990 and 910 i want to see it.
If they have 990 and paycodes other than 910 i don't want to see it.
If they have 990, 910 and other paycodes i don't want to see it.
I can't use the select expert because if i set that equal 910 or 990 then it will pull only those records even if the employee has additional paycodes. The evaluation has to happen after ALL of the records have been pulled into the report. I wrote running totals to count the 990 and 910 paycodes for each employee group and to count the total number of different paycodes for each employee group. I then tried to suppress each section based on a comparisong of these results. The problem is, i can't evaluate group selection on running totals because the totals aren't computed until the data is pulled.
Question is....
How can i see all employees (grouped) that have either 910 only, 990 only, or 910 and 990 only?
Sounds simple but I can't figure it out.
Thanks in advance