We help IT Professionals succeed at work.

table-wrapping

kalittaair
kalittaair asked
on
Medium Priority
737 Views
Last Modified: 2012-05-11
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?
Comment
Watch Question

CERTIFIED EXPERT

Commented:
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.

Author

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.
CERTIFIED EXPERT

Commented:
is your header row data the same on all header rows?

Author

Commented:
No. The two header rows have different headers.

Author

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)
CERTIFIED EXPERT

Commented:
<<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.

Author

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!

Author

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?
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT

Commented:
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>

Author

Commented:
Thanks! Worked great.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.