Show only duplicated records

[kwirky]

I have created a simple report which shows the paper used in production. I only want the report to show the records where 'Job No' appears multiple times.

Job No Paper
523052 150gsm
523052 230gsm
523052 310gsm
523054 150gsm
523055 150gsm

So basically I would only want records like 523052 to show, and to suppress the other 2 kinds of records.
Can anyone help with a formula?
Thanks
Kwirky

 

[IanWaterman]

Group by Job Number, suppress header and footer

Then in group selection

count(jobno, jobno) > 1

Replace JobNo with your JobNo field.

Ian