I am developing a check stub report. The data table has the employee check detail information in it (employid, pay rate, number of units, paycode, paycode type, etc). I need to separate the paycode types (earning, deduction, Taxes, benefits) into their separate subreports for formating. I have the earning subreport set to return the payrate, units, and employid from the table. That is linked to the employid for the Report Page. When I preview the report the subreport is returned once for each line item in the main table.
So what I get is
PageHeader (This employee has 5 line items)
Subreport
Subreport
Subreport
Subreport
Subreport
PageHeader (This employee has 3 line items
Subreport
Subreport
Subreport
...
Each subreport is correct and shows the proper items for the employee.
I'm at an impass here. I assume I'm overlooking something very basic but I can't find it.
Thank you.
Tim Roop
"If you can do something about it, why waste time getting upset? If you can't do anything about it, why bother getting upset on top of it? -Shantideva
So what I get is
PageHeader (This employee has 5 line items)
Subreport
Subreport
Subreport
Subreport
Subreport
PageHeader (This employee has 3 line items
Subreport
Subreport
Subreport
...
Each subreport is correct and shows the proper items for the employee.
I'm at an impass here. I assume I'm overlooking something very basic but I can't find it.
Thank you.
Tim Roop
"If you can do something about it, why waste time getting upset? If you can't do anything about it, why bother getting upset on top of it? -Shantideva