kalittaair
asked on
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?
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?
ASKER
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.
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.
is your header row data the same on all header rows?
ASKER
No. The two header rows have different headers.
ASKER
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)
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)
<<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.
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.
ASKER
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!
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!
ASKER
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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>
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>
ASKER
Thanks! Worked great.
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.