SSRS report - split table into two columns

mark goldin 691 Reputation points
2021-08-30T19:14:02.703+00:00

I need to split a table into 4 columns while the data has two columns. There result might look like this:
127656-image.png

The data is something like this:
127721-image.png

I have the following table configuration:
Row group expression:
=ceiling(rownumber(nothing) / 2)
Column group expression:
=rownumber(nothing) mod 2

Table filter:
127694-image.png

For some reason as th first image show the result has two extra empty rows.
No matter what I do I cannot get rid of them. However, teh same technique would profuce the correct results for the same number of original rows.
The problem only happens where the source table woud have two rows after filtering.

Thanks

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,849 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Olaf Helper 42,486 Reputation points
    2021-08-31T06:33:57.95+00:00

    User a "newsletter style" pagination instead to get the table into 2 columns, see Pagination in reports (Report Builder and SSRS) => Newsletter-Style Columns

    0 comments No comments

  2. Joyzhao-MSFT 15,566 Reputation points
    2021-08-31T07:26:11.12+00:00

    Hi @mark goldin ,
    I did the test locally.
    First of all, please filter the dataset, delete and select the required two sets of data. As shown below:
    127822-01.jpg
    127841-02.jpg
    Then I create a Matrix in the report, as shown in the following figure:
    127750-03.jpg

    Use your previous expressions in row groups and column groups:

    127842-04.jpg
    127844-05.jpg
    Row group expression:

    =ceiling(rownumber(nothing) / 2)  
    

    Column group expression:

    =rownumber(nothing) mod 2  
    

    Preview:

    127817-06.jpg

    Best Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  3. mark goldin 691 Reputation points
    2021-08-31T11:23:22.073+00:00

    I have two datasets. One is working fine:
    127900-image.png

    The other is not working:
    127839-image.png

    In the first one I am showing faults with fault_cnt <> 0.
    In the second I am showing Category with category_cnt <> 0.

    The difference in two datasets is that in the first one records to show naturally come together, while in the second they are not.
    I tried sorting as an addition to filtering, but it was even worse.