Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
E12345
Resolver II
Resolver II

Can Paginated Report allow you to show multiple columns underneath each other as a group?

Hi, I need to create a Paginated report where I can group columns based on ticket ID, but I also want to fit many columns onto a page that can be exported to PDF? I have 20 columns that do not fit on one line. I tried to use the matrix with various rown where I just merged cells to create areas for my columns. But some of my columns need different widths and matrix forces me to adhere to a specific structure. Can I just have free standing columns in SSRS? For example, in Crystal Reports I could just create sections (split the body into sections one underneath another nad have text boxes containing my columns and headers). But in SSRS I do not see a way to split the body into sections. How can I do that? 

Below is a picture of what I need: I need the report to let me place the columns one by one however I want: like such (matrix comes close, but it is hard to change if I need to add more rows and fit every column perfectly because it forces a grid and I just need to add stand alone boxes where I need them and not in a matrix. Any ideas or links to edicational videos would be appreciated - thanks):

 

E12345_0-1725068531383.png

E12345_1-1725068551701.png

E12345_2-1725068575868.png

 

 







1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @E12345 

Creating a paginated report in SSRS with free-standing columns can be challenging, but there are a few approaches you can try:

Use Tablix with Multiple Tablix Controls: Instead of using a single matrix, you can use multiple Tablix controls. Each Tablix can be configured to display a subset of your columns. This way, you can control the width of each column independently.

Custom Layout with Text Boxes: You can manually place text boxes in the report body to create a custom layout. This approach gives you the flexibility to position each column exactly where you want it. However, it can be time-consuming to maintain if your report structure changes frequently.

 

 

 

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @E12345 

Creating a paginated report in SSRS with free-standing columns can be challenging, but there are a few approaches you can try:

Use Tablix with Multiple Tablix Controls: Instead of using a single matrix, you can use multiple Tablix controls. Each Tablix can be configured to display a subset of your columns. This way, you can control the width of each column independently.

Custom Layout with Text Boxes: You can manually place text boxes in the report body to create a custom layout. This approach gives you the flexibility to position each column exactly where you want it. However, it can be time-consuming to maintain if your report structure changes frequently.

 

 

 

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you for the suggestion. I ended up adding text boxes into a list control, and that worked for me. 
I sorted the list control on the column I need to sort on, which gave me my groups with free standing columns. The titles of the columns were added manually inside text boxes, and then I pulled the fields inside the text boxes. 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.