how to make two tablix same size?

Vashko 20 Reputation points
2023-03-15T11:12:24.9033333+00:00

Hello all,

I have a paginated report withing Report Builder, and they are laid out in this manner:

User's image

When I go into run mode, it is rendered like this:

User's image

How can I achieve that first table is the same length as the second one, without manually adjusting the rectangle which is behind the table? I tried to nest the tablix within the tablix, so that did not work or maybe I configured it wrongly.

Can you help me somehow?

Thank you

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,772 questions
{count} votes

2 answers

Sort by: Most helpful
  1. AniyaTang-MSFT 12,301 Reputation points Microsoft Vendor
    2023-03-16T02:36:22.0066667+00:00

    Hi @Vashko

    Do you mean that the lengths of the two tables are set to be the same when previewing? According to the situation of your two tables, the data of your two tables is different, and the number of rows is different, which leads to inconsistent lengths of the tables. The easier way to do this is to add a few blank lines to make the two tables the same length, if the number of rows in your two tables is about the same.

    If you want to adjust the length of the rectangle to be the same, you can embed the rectangle into the matrix, and then insert the table into the rectangle to adjust.

    Below is a preview of both operations.

    1

    If the answer is helpful, please click "Accept Answer" and upvote it. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

    0 comments No comments

  2. Olaf Helper 40,156 Reputation points
    2023-03-16T07:25:02.54+00:00

    How can I achieve that first table is the same length as the second one,

    By querying the same amount of records for both dataset for the tablix.

    Or better one dataset. But without knowing your base data/queries, I can't give a more detailed answer.

    0 comments No comments