if <fieldName> = previous(<fieldname>) or <fieldname> = next(<fieldname>) then
        0
else
        1

 

Now you supress the records where reprec <> 0

 

now you create a subreport with same data and formula. In that report you supress the records where reprec = 0.

 

so in this way u get the duplicate records in the top and non duplicate later.

 

I think this is not a correct way, but this may match exactly your requirement.

 

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

 

 

Suppress Group Header and Footer,

 

 

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

 

 

 

 

Cheers

Rahul