All the record are displaying on one page - how to display page by page

Question

Hi,

I have created one reports but all the records are displaying on one page.  Please help me to find a solution to display the records page by page.   I created the same report without group so the records are displaying in page by page.

please find the design

---

[e-mail]

Answer 1

Read this article

https://technet.microsoft.com/en-us/library/ms156434(v=sql.100).aspx

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence

Answer 2

Hi P Noushad,

According to your description, all record display in one page, but you want to split them into different pages, right?

In your scenario, you can add a page break between each instance of the table1_EMPLOYEE_ID row group. Then each page will display each instance of Employee_ID record. Please refer to screenshots below:

Before adding a page break:

After adding a page break:

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

---

Qiuyun Yu
TechNet Community Support