Ask Your Question
0

How to create an SSRS Paginated Report that displays identical records on every page?

asked 2023-06-15 00:00:47 +0000

plato gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2023-06-15 00:18:01 +0000

lakamha gravatar image

To create an SSRS Paginated Report that displays identical records on every page, follow these steps:

  1. Open SQL Server Data Tools and create a new Reporting Services Project.

  2. In the Solution Explorer, right-click on the Reports folder and select Add New Report.

  3. Select the Blank Report template and click OK.

  4. Drag a Table control from the Toolbox onto the report design surface.

  5. Set the DataSet property of the Table control to your data source.

  6. Drag the fields you want to display from the DataSet onto the Table control.

  7. Click on the Row Groups pane and right-click on the Details group.

  8. Select Group Properties and go to the Page Breaks section.

  9. Check the "Between each instance of a group" option and click OK.

  10. Preview the report to see the results.

This will create a report that displays identical records on every page, essentially creating a form that can be filled out repeatedly.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2023-06-15 00:00:47 +0000

Seen: 7 times

Last updated: Jun 15 '23