I'm using SSRS sp2 and have a report which has a table which spans the width
of the report. I set the 'KeepTogether' property on this table to True, but
I have detail rows from this table spanning 2 pages. I thought this prop
would keep them together and force a pagebreak before. There's only about
10 rows total and a height of 0.3 for each row.
Also, I assume this property (when it works) will only effect the detail
rows. what I really want to keep the entire table together including
header, detail and footer rows. is there a way to not-allow a pagebreak
anywhere in the table?
Thanks
--
moondaddy@.nospam.nospamHi moondaddy,
Would you please send me a sample page with datasource? I understand the
information may be sensitive to you, my direct email address is
v-mingqc@.online.microsoft.com, you may send the file to me directly and I
will keep secure.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi. I found a workaround to this problem which may help you. As far as I can
tell, the table "keep together" property only applies to individual detail
rows i.e. if you have multiple detail lines, they can still span pages.
If you can use a single detail row with multiple lines, the keep together
will work on those lines.
To create a detail row with multile lines, you can use the
"environment.newline()" function in expressions within the detail row. (This
function does not appear to be documented in an obvious location).
e.g. an expression like . . .
=Fields!line_1.value & environment.newline() & Fields!line_2.value
will result in two lines, but using a single detail row.
Hope this helps. It won't help with keeping your whole table on one page.
Reporting Services seems to be deficient in this area.
"moondaddy" wrote:
> I'm using SSRS sp2 and have a report which has a table which spans the width
> of the report. I set the 'KeepTogether' property on this table to True, but
> I have detail rows from this table spanning 2 pages. I thought this prop
> would keep them together and force a pagebreak before. There's only about
> 10 rows total and a height of 0.3 for each row.
> Also, I assume this property (when it works) will only effect the detail
> rows. what I really want to keep the entire table together including
> header, detail and footer rows. is there a way to not-allow a pagebreak
> anywhere in the table?
> Thanks
> --
> moondaddy@.nospam.nospam
>
>|||Thanks. These sound like good tips. I wish they were better documented.
(sorry for the late reply. just got back from a long leave of absence)
--
moondaddy@.nospam.nospam
"Glen" <Glen@.discussions.microsoft.com> wrote in message
news:BBCEBF2B-9146-410B-AB6D-2039A103C275@.microsoft.com...
> Hi. I found a workaround to this problem which may help you. As far as I
> can
> tell, the table "keep together" property only applies to individual detail
> rows i.e. if you have multiple detail lines, they can still span pages.
> If you can use a single detail row with multiple lines, the keep together
> will work on those lines.
> To create a detail row with multile lines, you can use the
> "environment.newline()" function in expressions within the detail row.
> (This
> function does not appear to be documented in an obvious location).
> e.g. an expression like . . .
> =Fields!line_1.value & environment.newline() & Fields!line_2.value
> will result in two lines, but using a single detail row.
> Hope this helps. It won't help with keeping your whole table on one page.
> Reporting Services seems to be deficient in this area.
> "moondaddy" wrote:
>> I'm using SSRS sp2 and have a report which has a table which spans the
>> width
>> of the report. I set the 'KeepTogether' property on this table to True,
>> but
>> I have detail rows from this table spanning 2 pages. I thought this prop
>> would keep them together and force a pagebreak before. There's only
>> about
>> 10 rows total and a height of 0.3 for each row.
>> Also, I assume this property (when it works) will only effect the detail
>> rows. what I really want to keep the entire table together including
>> header, detail and footer rows. is there a way to not-allow a pagebreak
>> anywhere in the table?
>> Thanks
>> --
>> moondaddy@.nospam.nospam
>>|||I'm having a similar problem with the KeepTogether option on a table. I have
a report with a simple 4 row table. The pages break fine in the HTML
rendering but when I export to PDF, the pages will break in between detail
rows of a single table at times.
Has anyone come up with a viable solution to this problem? I'm running
Reporting Services for SQL Server 2000 SP1.
Thanks.
PhilK
"moondaddy" wrote:
> Thanks. These sound like good tips. I wish they were better documented.
> (sorry for the late reply. just got back from a long leave of absence)
> --
> moondaddy@.nospam.nospam
> "Glen" <Glen@.discussions.microsoft.com> wrote in message
> news:BBCEBF2B-9146-410B-AB6D-2039A103C275@.microsoft.com...
> > Hi. I found a workaround to this problem which may help you. As far as I
> > can
> > tell, the table "keep together" property only applies to individual detail
> > rows i.e. if you have multiple detail lines, they can still span pages.
> >
> > If you can use a single detail row with multiple lines, the keep together
> > will work on those lines.
> >
> > To create a detail row with multile lines, you can use the
> > "environment.newline()" function in expressions within the detail row.
> > (This
> > function does not appear to be documented in an obvious location).
> >
> > e.g. an expression like . . .
> >
> > =Fields!line_1.value & environment.newline() & Fields!line_2.value
> >
> > will result in two lines, but using a single detail row.
> >
> > Hope this helps. It won't help with keeping your whole table on one page.
> > Reporting Services seems to be deficient in this area.
> >
> > "moondaddy" wrote:
> >
> >> I'm using SSRS sp2 and have a report which has a table which spans the
> >> width
> >> of the report. I set the 'KeepTogether' property on this table to True,
> >> but
> >> I have detail rows from this table spanning 2 pages. I thought this prop
> >> would keep them together and force a pagebreak before. There's only
> >> about
> >> 10 rows total and a height of 0.3 for each row.
> >>
> >> Also, I assume this property (when it works) will only effect the detail
> >> rows. what I really want to keep the entire table together including
> >> header, detail and footer rows. is there a way to not-allow a pagebreak
> >> anywhere in the table?
> >>
> >> Thanks
> >>
> >> --
> >> moondaddy@.nospam.nospam
> >>
> >>
> >>
>
>
