Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Check Stub report (sub report returns several times)

Status
Not open for further replies.

timroop

IS-IT--Management
Dec 20, 2004
157
US
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
 
Nevermind...
I had the group defined from the subreport and not the main report page data.

If you are reading this...thanks for looking.

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top