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?
kalittaairAsked:
Who is Participating?
 
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
 
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
planoczCommented:
is your header row data the same on all header rows?
0
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.