Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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):
Solved! Go to Solution.
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.
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.