Looks to me like you have a page break on the group... Edit the group and
ensure that page break before and after group is NOT selected.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
[quoted text, click to view] "josef@wainz.net" wrote:
> Is there something I need to do to get Nested Lists to print correctly?
> When I preview the report, it displays correctly, grouped by Year,
> Resource and Part. Yet when I print it or even print preview it,
> instead of printing on one page:
>
> Year 2005
> Resource A
> Part 1
> Part 2
> Part 3
> Resource B
> Part 4
> Part 5
>
> It prints two pages:
>
> Year 2005
> Resource A
>
>
>
>
> Resource B
>
>
> as page one and:
>
> Part 1
> Part 2
> Part 3
>
>
> Part 4
> Part 5
>
> as page two.
>
> If I place page one over page two and hold it up to the light, the
> formatting and grouping is correct!
>
> I'm using SQL Server 2000 Reporting Services and Visual Studio.NET 2003.
>
Thanks for the suggestions Wayne, but that was one of the first things
I looked at.
I had to address the objects and their relationships.
This heirarchy works:
ReportHeader[Rectangle]
lstYear[List] (Grouping on Year)(Shows "Year 2005", "Year 2006" ...)
lstResource[List] (Grouping on Resource)
GroupHeader0[Rectangle] (Shows "Resource A", "Resource B" ...)
Detail[List] (Displaying "Part 1", "Part 2" ...)
There is still an issue concerning blank pages between filled pages,
but the odd grouping is resolved.
After all the above work with objects and nesting, it may in fact be
related to page size and margins. The problem occurred again, but I
went through and adjusted page and object sizes and margins, making
sure everything fit inside of 8.5 inches and voila the problem went
away.
