Hi,
Main Report
What you can do is ,Group By Job Number,Then Insert Summary Count of Job number .
Once done go to Details Section and Select Section Expert by right clicking then in Suppress DrillDown Click X+2 and enter the code below
Count ({Table_Job.JobNo}, {Table_Job.JobNo})=1
Suppress Group Header and Footer,
Subreport
Then save the same report as single record jobreport,follow the same process for grouping summary, but in that enter the below code for details section and suppress rest of the sections. this will be your subreport data
Count ({Table_Job.JobNo}, {Table_Job.JobNo})>1
Once done place the subreport in report footer of main report.
Cheers
Rahul
IP Logged
