I have a data set:
Pay Code, Name, Work Type, Hours
A001, A Jones, Travel, 20
A001, A Jones, Field, 30
A001, A Jones, Office, 40
A002, A Smith, Travel, 30
A002, A Smith, Field, 40
A002, A Smith, Office, 50

For each person I want to create one page of the report - the first page would be as follows.

Pay Code : A001
Name : A Jones

Work Type Hours
Travel 20
Field 30
Office 40

The pay code & name are text boxes, the Work Type & Hours are in a tablix as there could be different work types for each employee.

I have got my program to work for one person at a time - using a loop.
I use the data set for one person
Pay Code, Name, Work Type, Hours
A001, A Jones, Travel, 20
A001, A Jones, Field, 30
A001, A Jones, Office, 40

and produce one page - the user can print it, or save it as an excel file, this then repeats for the next person, etc.

But the user wants a multipage report with one page for each person so they only have to press the print button once.

I don't know how to set up the rdlc file to do this, or if this is possible.
Help would be appreciated.
Thanks