Divide rows into 2 parts using Report Builder 3.0

Pranesh Sankpal 1 Reputation point
2021-06-09T04:02:29.897+00:00

I want to divide the rows of 2 columns into 2 parts without affecting the other columns. I don't want to use Row groups as those columns will be always blank when report is generated and there is no Parent / Child relationship between those columns with others.

103647-report-builder-capture.png

Like shown in above screen capture my other columns (Test1, Test2, Test3, Test4) should contain single rows but Test6 and Test7 columns should contain split rows without any values.

Is there any possible way to do this?

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.
3,061 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 41,491 Reputation points
    2021-06-09T06:22:50.23+00:00

    Hi @Pranesh Sankpal ,

    From SSRS side, there is no ready-made way to divide textbox into 2 parts directly.

    Here are two workaround to do that.

    1.You may use rectangle and line to meet your needs.

    Combine a rectangle and line in the report and then move them to the empty textbox.

    Remember to adjust the line to be horizontal line and set the border of the rectangle.

    103724-0609.png

    2.Or you may add an image as the Test6 shown and insert the image to the textbox.

    Regards,

    Zoe


    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.
    Hot issues October

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.