Report Builder labels not flowing to next column

PhillipK 121 Reputation points
2023-04-06T13:15:16.4633333+00:00

I have a query that creates a label and columns but somehow when running the report it does not flow to the next column. Any ideas is appreciated.

enter image description here

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

Accepted answer
  1. AniyaTang-MSFT 12,421 Reputation points Microsoft Vendor
    2023-04-10T03:21:59.8733333+00:00

    Hi @PhillipK I understand. Based on the link you provided, this is the display of the print layout. I tested that when I resized the paper to the right size in the print settings, the preview of the print layout would show three columns. But when you run the report normally, it will only show one column. 1

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know. Best regards, Aniya

    1 person found this answer helpful.
    0 comments No comments

3 additional answers

Sort by: Most helpful
  1. Olaf Helper 43,246 Reputation points
    2023-04-06T13:26:07.5966667+00:00

    I can't see anything in that micro-sized screenshot. Anyway, have you set the "CanGrowth" / "CanShrink" property for the TextBox?


  2. AniyaTang-MSFT 12,421 Reputation points Microsoft Vendor
    2023-04-07T01:20:34.8866667+00:00

    Hi @PhillipK I can't see your screenshot clearly. But you seem to have only created one column in the table, and the data will expand in this column and will not flow to the next column unless you insert a column and import the data. 1

    Can you show you what your source data looks like? Best regards, Aniya


  3. PhillipK 121 Reputation points
    2023-04-10T20:11:49.4466667+00:00

    Strangely I cannot see the middle column even after setting it all ok.