Page 1 of 1

multiple table details

Posted: Thu Nov 04, 2010 6:05 pm
by David_(Guest)
Working on a sign-off report for payroll, with the following format on each page for each employee:____Header: pay period: (date range)__employee name__(first section of report)__list details from table "hours paid" file of that employee__sub total__(second section of report)__list details from table "time clock punches" file of that employee__subtotal____next page______I did the first section with the hours paid, how do I add the second section for time clock punch?____Thanks.______

=> RE: multiple table details

Posted: Mon Nov 08, 2010 10:14 pm
by kfleming
What you have is a multiple scan relation where a parent record has more than one scanned child at the same relation level.__There is a chapter in the help file that describes how to work with reports with this kind of relation structure.____Kathleen__R&R Support

==> RE: multiple table details

Posted: Thu Nov 11, 2010 5:58 pm
by David_(Guest)
I have setup the scan table for "hours paid" and "clock punches". But for the life of me, I cannot see how to change the band line properties to scan the two tables. It always band on "Record".

===> RE: multiple table details

Posted: Wed Nov 24, 2010 8:43 am
by kfleming
You add two record lines on the report, one with fields from the first scanned table and the second with the fields from the second scan. You then use Band Line Properties to select the appropriate scan table for each of these band lines.____Kathleen__R&R Support