List box and pagination issues rendering to .pdf

I have a report that is using lists. When previewed in reports services it
looks fine, but when exported to .pdf, I get extraneous unwanted blank pages.
It is NOT the margins or section sizes, I have checked all of that. It
appears to be related to the amount of data in one pas through a grouping in
the list. Yet, I have all the "keep together" options set to "false". How can
I get this report to render to .pdf properly'
thanks!Have you checked to see if any of your items are growing in width, and
pushing otherwise blank space off to the right? I'm wrestling with that on
a side-by-side matrix report right now.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Martha" <Martha@.discussions.microsoft.com> wrote in message
news:23DDF0CD-C743-46F3-B7D1-707B3136511E@.microsoft.com...
>I have a report that is using lists. When previewed in reports services it
> looks fine, but when exported to .pdf, I get extraneous unwanted blank
> pages.
> It is NOT the margins or section sizes, I have checked all of that. It
> appears to be related to the amount of data in one pas through a grouping
> in
> the list. Yet, I have all the "keep together" options set to "false". How
> can
> I get this report to render to .pdf properly'
> thanks!
>|||Yes, I have checked for that. If I sort my list in a different order, I don't
have the issue so I know it has something to do with the amount of data in
one grouping of the list. None of the "keep together" options are marked
though so I can not figure out what else to look for - very frustrating!
Any other ideas anyone'
thanks!
"Jeff A. Stucker" wrote:
> Have you checked to see if any of your items are growing in width, and
> pushing otherwise blank space off to the right? I'm wrestling with that on
> a side-by-side matrix report right now.
> --
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Martha" <Martha@.discussions.microsoft.com> wrote in message
> news:23DDF0CD-C743-46F3-B7D1-707B3136511E@.microsoft.com...
> >I have a report that is using lists. When previewed in reports services it
> > looks fine, but when exported to .pdf, I get extraneous unwanted blank
> > pages.
> > It is NOT the margins or section sizes, I have checked all of that. It
> > appears to be related to the amount of data in one pas through a grouping
> > in
> > the list. Yet, I have all the "keep together" options set to "false". How
> > can
> > I get this report to render to .pdf properly'
> >
> > thanks!
> >
> >
>
>|||Are the extraneous pages at the end, or interleaved? If interleaved, then
it's from extra space on the right, otherwise from extra space at the
bottom.
If it's extra space at the bottom, I was able to hold together a couple of
items by putting them in the same rectangle or list. The pagination is a
bit squirrelly right now. I'm certainly looking forward to future
improvements!
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Martha" <Martha@.discussions.microsoft.com> wrote in message
news:C464BF76-4F57-4465-9B0F-19379A7C57AA@.microsoft.com...
> Yes, I have checked for that. If I sort my list in a different order, I
> don't
> have the issue so I know it has something to do with the amount of data in
> one grouping of the list. None of the "keep together" options are marked
> though so I can not figure out what else to look for - very frustrating!
> Any other ideas anyone'
> thanks!
>
> "Jeff A. Stucker" wrote:
>> Have you checked to see if any of your items are growing in width, and
>> pushing otherwise blank space off to the right? I'm wrestling with that
>> on
>> a side-by-side matrix report right now.
>> --
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Martha" <Martha@.discussions.microsoft.com> wrote in message
>> news:23DDF0CD-C743-46F3-B7D1-707B3136511E@.microsoft.com...
>> >I have a report that is using lists. When previewed in reports services
>> >it
>> > looks fine, but when exported to .pdf, I get extraneous unwanted blank
>> > pages.
>> > It is NOT the margins or section sizes, I have checked all of that. It
>> > appears to be related to the amount of data in one pas through a
>> > grouping
>> > in
>> > the list. Yet, I have all the "keep together" options set to "false".
>> > How
>> > can
>> > I get this report to render to .pdf properly'
>> >
>> > thanks!
>> >
>> >
>>|||Jeff - the extra pages are "interleaved". As I mentioned, if I change the
sort order of the data, the position of the extra pages changes as well. This
is what leads me to believe that it is the amount of data in one grouping of
my list that is causing the issue and I have not been able to figure out how
to get it to fill the space and break on page size not data grouping - again,
any suggestions appreciated, my client is quite frustrated by the appearance
of some of their reports!
Martha
"Jeff A. Stucker" wrote:
> Are the extraneous pages at the end, or interleaved? If interleaved, then
> it's from extra space on the right, otherwise from extra space at the
> bottom.
> If it's extra space at the bottom, I was able to hold together a couple of
> items by putting them in the same rectangle or list. The pagination is a
> bit squirrelly right now. I'm certainly looking forward to future
> improvements!
> --
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Martha" <Martha@.discussions.microsoft.com> wrote in message
> news:C464BF76-4F57-4465-9B0F-19379A7C57AA@.microsoft.com...
> > Yes, I have checked for that. If I sort my list in a different order, I
> > don't
> > have the issue so I know it has something to do with the amount of data in
> > one grouping of the list. None of the "keep together" options are marked
> > though so I can not figure out what else to look for - very frustrating!
> >
> > Any other ideas anyone'
> >
> > thanks!
> >
> >
> > "Jeff A. Stucker" wrote:
> >
> >> Have you checked to see if any of your items are growing in width, and
> >> pushing otherwise blank space off to the right? I'm wrestling with that
> >> on
> >> a side-by-side matrix report right now.
> >>
> >> --
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "Martha" <Martha@.discussions.microsoft.com> wrote in message
> >> news:23DDF0CD-C743-46F3-B7D1-707B3136511E@.microsoft.com...
> >> >I have a report that is using lists. When previewed in reports services
> >> >it
> >> > looks fine, but when exported to .pdf, I get extraneous unwanted blank
> >> > pages.
> >> > It is NOT the margins or section sizes, I have checked all of that. It
> >> > appears to be related to the amount of data in one pas through a
> >> > grouping
> >> > in
> >> > the list. Yet, I have all the "keep together" options set to "false".
> >> > How
> >> > can
> >> > I get this report to render to .pdf properly'
> >> >
> >> > thanks!
> >> >
> >> >
> >>
> >>
> >>
>
>|||What's happening is that some element has got extra white space that is
getting pushed off the page. If you tighten your margins at the bottom and
right of the elements, it should eliminate the page breaking. The problem
is that this will probably mess up your spacing between items on the same
page. Again, the only thing I can suggest is to find out exactly which text
box or list box or other item is causing the white space to bump off the
page, and then eliminate that space. Then, what I would do is regroup the
items that need to be on the same page inside some rectangle(s), and move
around the rectangle(s) relative to other items to fix the spacing.
Again, if you have matrixes, they may push things off to the right. Other
things may be pushing space off the bottom depending on the amount of data.
Happy sleuthing...
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Martha" <Martha@.discussions.microsoft.com> wrote in message
news:387C6CE2-B57E-40E5-A0A7-B7D82012A76B@.microsoft.com...
> Jeff - the extra pages are "interleaved". As I mentioned, if I change the
> sort order of the data, the position of the extra pages changes as well.
> This
> is what leads me to believe that it is the amount of data in one grouping
> of
> my list that is causing the issue and I have not been able to figure out
> how
> to get it to fill the space and break on page size not data grouping -
> again,
> any suggestions appreciated, my client is quite frustrated by the
> appearance
> of some of their reports!
> Martha
>
> "Jeff A. Stucker" wrote:
>> Are the extraneous pages at the end, or interleaved? If interleaved,
>> then
>> it's from extra space on the right, otherwise from extra space at the
>> bottom.
>> If it's extra space at the bottom, I was able to hold together a couple
>> of
>> items by putting them in the same rectangle or list. The pagination is
>> a
>> bit squirrelly right now. I'm certainly looking forward to future
>> improvements!
>> --
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Martha" <Martha@.discussions.microsoft.com> wrote in message
>> news:C464BF76-4F57-4465-9B0F-19379A7C57AA@.microsoft.com...
>> > Yes, I have checked for that. If I sort my list in a different order, I
>> > don't
>> > have the issue so I know it has something to do with the amount of data
>> > in
>> > one grouping of the list. None of the "keep together" options are
>> > marked
>> > though so I can not figure out what else to look for - very
>> > frustrating!
>> >
>> > Any other ideas anyone'
>> >
>> > thanks!
>> >
>> >
>> > "Jeff A. Stucker" wrote:
>> >
>> >> Have you checked to see if any of your items are growing in width, and
>> >> pushing otherwise blank space off to the right? I'm wrestling with
>> >> that
>> >> on
>> >> a side-by-side matrix report right now.
>> >>
>> >> --
>> >> '(' Jeff A. Stucker
>> >> \
>> >>
>> >> Business Intelligence
>> >> www.criadvantage.com
>> >> ---
>> >> "Martha" <Martha@.discussions.microsoft.com> wrote in message
>> >> news:23DDF0CD-C743-46F3-B7D1-707B3136511E@.microsoft.com...
>> >> >I have a report that is using lists. When previewed in reports
>> >> >services
>> >> >it
>> >> > looks fine, but when exported to .pdf, I get extraneous unwanted
>> >> > blank
>> >> > pages.
>> >> > It is NOT the margins or section sizes, I have checked all of that.
>> >> > It
>> >> > appears to be related to the amount of data in one pas through a
>> >> > grouping
>> >> > in
>> >> > the list. Yet, I have all the "keep together" options set to
>> >> > "false".
>> >> > How
>> >> > can
>> >> > I get this report to render to .pdf properly'
>> >> >
>> >> > thanks!
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>|||I have the same issue with 2 reports that are using a list box. It
seems that the list box is at times trying to keep data
together...although I don't have the "fit on one page" option on. A
similar issue that I am having is that whole instances of the list box
are not showing up. I am not turning on or off the visible switch...and
the report is fine in a web page. The issue is really only when
rendering to a PDF.