I want a ssrs report with two tables adjacent,using same data set. I want to start row number/records in second table where rownumber of first table ends.and in second page first table should start where second table of first page ends.Please tell me how it is possible.

Need Help!!

Hello,

Yes, it's possible and it's called "Newspaper style", even if it's only 2 columns; see:

Creating Newsletter-Style Reports

How to: Create a Newsletter-Style Report (Reporting Services)

No its not clear. Its not working. Can you please brief me on this

Thanks!!

What's not clear? You only have to change report property "Columns" from 1 to 2; no need to modify existing tablix or anything else.

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.

Its only working while exporting to pdf. 

I don't need to separate data on basis of even or odd rows.  

 It just a example Abinav, You can modify the grouping logic based your scenario.Can you post your sam

I tried this. But its only working while exporting data to PDF.

Hi Abhinav ,

Get the two tables inside a list and add another dataset for the list which will have all the group numbers and then do a page break based on the groupnumber.

Hi AbhinavSultania,

According to your description, you want to have second table continue the records in first table. And each table show 4 records on each page. Right?

In this scenario, I assume you already have a row number column. You can create a calculated field(named calculatedgroup) to give a number for ever 4 records. Use the expression below:

=(Fields!rownumber.value-1)\4

Then we have the records group on this calculated field. Since you need the second table continue with the records in first table. We can add two different filters on these two tables.

Filter1:

Fields!calculatedgroup.value mod 2

=

0

Filter2:

Fields!calculatedgroup.value mod 2

=

1

Then the first table will only show even group records, and the second one will only show odd group records. It will look like below:

Ps: You can delete the group column and keep associated groups.

R