Hi Abhinav,
Below is the solution.
1. Drag two table control .
2. Create two datasets(1 for each table)
1st dataset:
table I considered
WITH T AS(SELECt *,NTILE(2) OVER (
ORDER BY DOA) AS 'GroupNumber' FROM EMPLOYEE)
SELECT * FROM T WHERE GroupNumber % 2 <> 0
2ns Dataset
WITH T AS(SELECt *,NTILE(2) OVER (
ORDER BY DOA) AS 'GroupNumber' FROM EMPLOYEE)
SELECT * FROM T WHERE GroupNumber % 2 = 0
Note: I have grouped the rows with 2 in your case it will be 4
3. Add row group on the GroupNumber field for each table and have a page break on each new group number.
4.It would give result like this
Output
Don't forget to mark helpful posts, and answers. It helps others to find relevant posts to the same question.