How to add Invoice information above detail grid in SSRS

I am trying to create a statement report in SSRS.  The report is grouped by employee number and displays the payment detail in a table.  I am printing one employee per page sorted by a date range.  So, the AP department will just need to select a date range and all statements for employees will print out and be ready to attach to a check for payment.  

What I am trying to do is put Pay to and pay from information on each page above the detail.  When I try now, it only displays on first page and then individual employee info only displays on each page after

Each page grouped by employee number should look like....

Company Name                                                      Pay To:  Employee Number
Company Address                                                                 Employee Name
                                                                                                  Employee Address


Payment Date  Start  To End
_____________________________________________________________________________
Employee pay detail.




thanks for any help
LVL 5
rtayIT DirectorAsked:
Who is Participating?
 
Nico BontenbalCommented:
If you haven't done so already you need to place all the information inside the tablix (table). Then group on employeeid. Add more rows to the group header to contain number, name address etc. Then use the information in this article to repeat the header rows:
https://msdn.microsoft.com/en-us/library/dd207045.aspx?f=255&MSPPError=-2147217396
(To display a static tablix member (row or column) on multiple pages).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.