Good Morning, I have a really painful reports that I am modifing and trying to add some subreports to it and for the life of me I can get it the way my boss wants it.
The report main report and sub reports have no relation EXCEPT the JOB# itself.
1. I would like to know if I could pass over the jobs #from all my subreports and embeded them in the main report and all the jobs are line up numerically. Is that even possible?
2. Then I need the main report to add up the subreport and created the sub total for each job number, and grand total at the very bottom of the report. Is that even possible?
here is the main report and how its I got it to lay out right now
job# Job Desc materail labour overhead Cont1 Cont Cont3
2222-4 Sales 500 100 50
1202 -2 Sales2 1000 200 300
3333 -1 Sales 750 150 300
sub report 1
1202 -2 (300) 300
5555-6 (120) 200
Sub report 2
3333 - 7 (90) 90
sub report 3
1202 - 3 ( 120) (20) 140
Here is how we wants it to look like
job# Job Desc materail labour overhead Cont1 Cont Cont3
1202 -2 Sales2 1000 200 300
1202 - 3 ( 120) (20) 140
Subtotals 7000 80 280 300 140
so and so and so
at the very bottom
Grand Totals of all the amounts
*** Please help I need this really bad*****