row too long when exporting to PDF

if I have a table with 3 rows and 3 columns and the columns are wide so that
2 columns just fit on one page.By default reporting server, when exporting to
PDF, puts first 3 rows and 2 columns on one page and last column for all the
rows on second
first page:
header1 header2
1row 1col 1row 2 col
2row 1 col 2row 2 col
second page:
header 3
1 row 3 col
2 row 3 col
Is it possible to do so that it splits the data for all rows separately:
header 1 header 2
1 row 1 col 1 row 2 col
header 3
1 row 3 col
header 1 header 2
2 row 1 col 2 row 2 col
header 3
2 row 3 colOn May 16, 9:49 am, pardik <par...@.discussions.microsoft.com> wrote:
> if I have a table with 3 rows and 3 columns and the columns are wide so that
> 2 columns just fit on one page.By default reporting server, when exporting to
> PDF, puts first 3 rows and 2 columns on one page and last column for all the
> rows on second
> first page:
> header1 header2
> 1row 1col 1row 2 col
> 2row 1 col 2row 2 col
> second page:
> header 3
> 1 row 3 col
> 2 row 3 col
> Is it possible to do so that it splits the data for all rows separately:
> header 1 header 2
> 1 row 1 col 1 row 2 col
> header 3
> 1 row 3 col
> header 1 header 2
> 2 row 1 col 2 row 2 col
> header 3
> 2 row 3 col
You might try grouping on a report item at the row level. Then set
'Page break at end' as part of the grouping. If this does not work,
you could try using a matrix control and rearranging your dataset
(query/stored procedure) output to format the matrix in the above
format. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant