Problem: Formatting The Sql Report

I created a report using SQL Report Server project. I was able to retrieve my data without any problem. I am having a hard time to format the data correctly: when somebody access the report he will have the option to export it to PDF file

Here is how I would like to format the PDF File:

14111 NC Test

12541 NC Test2

Page 1

For the second user I will have all the above template to be Repeated again

------------------------------------------------------------------------------------------------------------

14111 NC Test

12541 NC Test2

Page 2

I could not make it to copy the title in the second page. This is what I have so far

------------------------------------------------------------------------------------------------------------

14111 NC Test

12541 NC Test2

Department : A George Jebson

14111 NC Test

12541 NC Test2

Department : B Steve J

14111 NC Test

12541 NC Test2

I want the whole template to be repeated for each user. I do group by name but still I canĄŻt repeat title and the lines for each page. It will put everything under one title. Is there a design screen for pdf Or i just need to do everything in the layout tab for the report then expor it as a PDF

If you are using table to show data in reporting service just select table header and set in property repeaton each page = true.

Export my data to a PDF file it adds an empty page. For example

Page 1

Some Data

Page 2

Page 3

Some date

Page 4

Page 5

Some Data

I unchecked both boxes: insert a page break before the list and insert a page break after the list. any idea!

Thank you

Thank you Adam. I am still not following your suggestion !

In my list control properties -> Edit details group button -> i checked the check box 'page break at end' (i had to do that so each page will have one list displayed) but i still end up with empty pages can you be more specific when you said

"

Thank you soooo much. It worked, I have to say it was kinda weird because I thought my page was fitting perfectly, but it only worked when I gave it a bigger width size.

Thanks for your help