[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 729
  • Last Modified:

table-wrapping

Experts,

Using SSRS 2008

I have a table that contains the data returned from a stored procedure. The width of this table exceeds that of the page width. The SSRS native behaviour prints the part of the table that exceeds the page width on the second page. I would like it to wrap around and print directly below the table, for each seperate row.

I've tried creating a smaller table below the main one to handle the data that exceeded the page width but all that did was print the main table grouped together and the smaller table below it, grouped together. However, my requirement is to have each row individually wrap before it prints the next row.

Any ideas?
0
kalittaair
Asked:
kalittaair
  • 6
  • 3
  • 2
1 Solution
 
Nico BontenbalCommented:
You could create another detail row and put the fields that don't fit on the page on this new row. Also when there are fields with a lot of text you could just make the columns smaller and SSRS will wrap the text inside the column.

If this doesn't help, could you attach a screenshot of the report as it is now. Or you could make a copy of the .rdl and rename the copy to .xml and upload the xml. (EE doesn't allow uploads of type .rdl).
This makes it easier to do suggestions to solve your problem.
0
 
kalittaairAuthor Commented:
Nicobo - Thanks for the response.

I inserted 2  (inside Group - below) rows to my table. The first one containes the column headers and the second contains the data. So my table now has 4 rows, the original header row and 3 detail rows. This may work fine with a little tweaking. I've got two questions. How do I get the original header column to repeat each time, and how do I put a litle space between repeating rows?

Right now it does this:
Header Row 1
Row 1 Data
Header Row 2
Row 2 Data
Row 1 Data
Header Row 2
Row 2 Data
......

I would like it to do this:
Header Row 1
Row 1 Data
Header Row 2
Row 2 Data

Header Row 1
Row 1 Data
Header Row 2
Row 2 Data

....

Thanks.
0
 
planoczCommented:
is your header row data the same on all header rows?
0
Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

 
kalittaairAuthor Commented:
No. The two header rows have different headers.
0
 
kalittaairAuthor Commented:
All header and data info is different from all others.

So the table would print like this:

header1  header2  header3  header4  header5
data1       data2      data3       data4      data5
header6  header7  header8
data6       data7       data8
<space>
header1  header2  header3  header4  header5
data1       data2      data3       data4      data5
header6  header7  header8
data6       data7       data8
<space>
..
..
..
(I hope this looks lined up to you)
0
 
Nico BontenbalCommented:
<<How do I get the original header column to repeat each time>>
Just make sure the first header row is also within the detail section. So on the first data row you do another 'add row inside Group - above'. Then you move all the labels from the original header row into this new row. And finally you can add another row (inside Group - below) to the second data row. You can leave this row empty to create some extra space. When you remove all the borders from this empty row you will actually get some white space between your data rows.
0
 
kalittaairAuthor Commented:
Thanks! I will try that.

One last twist. The widths of each column vary. So, in my example above, the header and data column 6 is smaller than header and data column 1. Under this setup, the widths of all 4 columns are locked together. What can I do about this?

Thanks!
0
 
kalittaairAuthor Commented:
Let me clarify - the widths of all 4 ROWS in the same column is locked together. I cannot adjust the column width of the top two rows without also adjusting the column width of the bottom two rows. What can I do here?
0
 
Nico BontenbalCommented:
When you select two or more cells on the same row you can right click and then choose 'Merge cells'. See:
http://msdn.microsoft.com/en-us/library/bb630416.aspx
This allows you to have different column sizes on each row. You could for example create 20 column of 1cm wide on your report. Then when you want a cell to be 3 cm wide you just merge 3 cells. If you want 6 centimeters you merge 6 cells. You can merge the cells differently on the two different data rows so the columns will no longer be locked.

0
 
planoczCommented:
i have used what I call a offset header and data columns on one width of the page (8 inches)
header1       header2       header3       header4       header5
            header6       header7        header8
data1            data2          data3            data4           data5
           data6            data7            data8
<space>
header1       header2       header3       header4       header5
            header6       header7        header8
data1            data2          data3            data4           data5
           data6            data7            data8
<space>

0
 
kalittaairAuthor Commented:
Thanks! Worked great.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 6
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now