Blank pages in Print Layout version of report

Hi All

I have a report that looks and works fine in the native 'screen layout' but when I select the Print Layout option, a blank page is inserted after each page. These blank pages contain the header and footer, but not the body section of the report. Has anyone else seen this sort of thing? Is there something in my report layout causing this, or is it a bug in the Print Layout rendering?

Thanks much

On your report layout, is the white background width, plus the size of your right and left margins (in Report, Properties) greater than your page width in report, properties?

This will cause page breaks.

BobP

|||

I have the same or similiar question.

When I preview my report in Report Services I have no blank pages. When I print preview it there is one or two pages that are blank. Well they are half blank or partial blank.

My report has a header and body. I have the labels of the body in the header because I can't get the repeatwith Property to work(That's being addressed in another thread.). In the Body I have a list box and sub list box. I have it grouped by a field contained in the list box. Some the pages end where the grouping ends, but not all. It's strange. If I edit the size of the list box or somehow or decrease the size of the report the blank pages changes. Such as now it's half blank on page 4 and 3/4 blank on page 30. out of 50. I change the list box a little and it changes my blank pages to be on 15 and 22.

Anyone got a sufggestion for this?

Card Gunner

Black Reports in Print Layout

Hello all,
We have an issue with reports we created using the VS 2005 Team System. When
we open a report everything looks fine and report prints fine as well.
The problem is that when we click the Print Layout button on the report we
get a black page and only report title and group headers are visible. Mind
you, the report still prints fine on the printer but none of the data is
visible in the report.
Any ideas and solutions appreciated.
BR,
GAZOn Dec 24, 8:33 am, "GAZ" <g...@.gaz.com> wrote:
> Hello all,
> We have an issue with reports we created using the VS 2005 Team System. When
> we open a report everything looks fine and report prints fine as well.
> The problem is that when we click the Print Layout button on the report we
> get a black page and only report title and group headers are visible. Mind
> you, the report still prints fine on the printer but none of the data is
> visible in the report.
> Any ideas and solutions appreciated.
> BR,
> GAZ
This should help.
http://support.microsoft.com/kb/935356/en-us
Regards,
Enrique Martinez
Sr. Software Consultant|||"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:d2fc2115-efce-4d3e-9ee2-4965bd60ec77@.f52g2000hsa.googlegroups.com...
> On Dec 24, 8:33 am, "GAZ" <g...@.gaz.com> wrote:
>> Hello all,
>> We have an issue with reports we created using the VS 2005 Team System.
>> When
>> we open a report everything looks fine and report prints fine as well.
>> The problem is that when we click the Print Layout button on the report
>> we
>> get a black page and only report title and group headers are visible.
>> Mind
>> you, the report still prints fine on the printer but none of the data is
>> visible in the report.
>> Any ideas and solutions appreciated.
>> BR,
>> GAZ
>
> This should help.
> http://support.microsoft.com/kb/935356/en-us
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Thanks for the info. Got it but it won't install. Every single hotfix
reports a failure to install. Has anyone else had any problems with the
installation of the said hotfix?
BR,
GAZ|||On Dec 25, 3:41 am, "GAZ" <g...@.gaz.com> wrote:
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:d2fc2115-efce-4d3e-9ee2-4965bd60ec77@.f52g2000hsa.googlegroups.com...
>
> > On Dec 24, 8:33 am, "GAZ" <g...@.gaz.com> wrote:
> >> Hello all,
> >> We have an issue with reports we created using the VS 2005 Team System.
> >> When
> >> we open a report everything looks fine and report prints fine as well.
> >> The problem is that when we click the Print Layout button on the report
> >> we
> >> get a black page and only report title and group headers are visible.
> >> Mind
> >> you, the report still prints fine on the printer but none of the data is
> >> visible in the report.
> >> Any ideas and solutions appreciated.
> >> BR,
> >> GAZ
> > This should help.
> >http://support.microsoft.com/kb/935356/en-us
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Thanks for the info. Got it but it won't install. Every single hotfix
> reports a failure to install. Has anyone else had any problems with the
> installation of the said hotfix?
> BR,
> GAZ
You're welcome. You may have to install the Hot fixes in a particular
order. Have you tried verifying the order in which the hot fixes must
be installed? Hope this helps further.
Regards,
Enrique Martinez
Sr. Software Consultant|||"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:3d431f4b-bd40-49c7-bb5f-c0f2b2c4b64e@.21g2000hsj.googlegroups.com...
> On Dec 25, 3:41 am, "GAZ" <g...@.gaz.com> wrote:
>> "EMartinez" <emartinez...@.gmail.com> wrote in message
>> news:d2fc2115-efce-4d3e-9ee2-4965bd60ec77@.f52g2000hsa.googlegroups.com...
>>
>> > On Dec 24, 8:33 am, "GAZ" <g...@.gaz.com> wrote:
>> >> Hello all,
>> >> We have an issue with reports we created using the VS 2005 Team
>> >> System.
>> >> When
>> >> we open a report everything looks fine and report prints fine as well.
>> >> The problem is that when we click the Print Layout button on the
>> >> report
>> >> we
>> >> get a black page and only report title and group headers are visible.
>> >> Mind
>> >> you, the report still prints fine on the printer but none of the data
>> >> is
>> >> visible in the report.
>> >> Any ideas and solutions appreciated.
>> >> BR,
>> >> GAZ
>> > This should help.
>> >http://support.microsoft.com/kb/935356/en-us
>> > Regards,
>> > Enrique Martinez
>> > Sr. Software Consultant
>> Thanks for the info. Got it but it won't install. Every single hotfix
>> reports a failure to install. Has anyone else had any problems with the
>> installation of the said hotfix?
>> BR,
>> GAZ
>
> You're welcome. You may have to install the Hot fixes in a particular
> order. Have you tried verifying the order in which the hot fixes must
> be installed? Hope this helps further.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Thanks for your answer.
The hotfixes are acutally rolled into one package which does not give you an
option to choose a particular order for installation. When we start the
installation it always asks for the SQL installation disk and then it reads
files from it and reports that the hotfix installation failed. And so on for
each of the components.
Well, I guess that we'll have to wait for the SP3 to have the issue
resolved.
Thanks again for your help.
BR,
GAZ|||On Dec 26, 1:58 am, "GAZ" <g...@.gaz.com> wrote:
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:3d431f4b-bd40-49c7-bb5f-c0f2b2c4b64e@.21g2000hsj.googlegroups.com...
>
> > On Dec 25, 3:41 am, "GAZ" <g...@.gaz.com> wrote:
> >> "EMartinez" <emartinez...@.gmail.com> wrote in message
> >>news:d2fc2115-efce-4d3e-9ee2-4965bd60ec77@.f52g2000hsa.googlegroups.com...
> >> > On Dec 24, 8:33 am, "GAZ" <g...@.gaz.com> wrote:
> >> >> Hello all,
> >> >> We have an issue with reports we created using the VS 2005 Team
> >> >> System.
> >> >> When
> >> >> we open a report everything looks fine and report prints fine as well.
> >> >> The problem is that when we click the Print Layout button on the
> >> >> report
> >> >> we
> >> >> get a black page and only report title and group headers are visible.
> >> >> Mind
> >> >> you, the report still prints fine on the printer but none of the data
> >> >> is
> >> >> visible in the report.
> >> >> Any ideas and solutions appreciated.
> >> >> BR,
> >> >> GAZ
> >> > This should help.
> >> >http://support.microsoft.com/kb/935356/en-us
> >> > Regards,
> >> > Enrique Martinez
> >> > Sr. Software Consultant
> >> Thanks for the info. Got it but it won't install. Every single hotfix
> >> reports a failure to install. Has anyone else had any problems with the
> >> installation of the said hotfix?
> >> BR,
> >> GAZ
> > You're welcome. You may have to install the Hot fixes in a particular
> > order. Have you tried verifying the order in which the hot fixes must
> > be installed? Hope this helps further.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Thanks for your answer.
> The hotfixes are acutally rolled into one package which does not give you an
> option to choose a particular order for installation. When we start the
> installation it always asks for the SQL installation disk and then it reads
> files from it and reports that the hotfix installation failed. And so on for
> each of the components.
> Well, I guess that we'll have to wait for the SP3 to have the issue
> resolved.
> Thanks again for your help.
> BR,
> GAZ
You're welcome. Have you checked the Event Viewer for errors that
might be logged during the process? That might provide some better
details. Hope this helps further.
Regards,
Enrique Martinez
Sr. Software Consultant|||"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:7c2d5ac2-a280-4fe0-9a51-a53e315ea7dd@.1g2000hsl.googlegroups.com...
> On Dec 26, 1:58 am, "GAZ" <g...@.gaz.com> wrote:
>> "EMartinez" <emartinez...@.gmail.com> wrote in message
>> news:3d431f4b-bd40-49c7-bb5f-c0f2b2c4b64e@.21g2000hsj.googlegroups.com...
>>
>> > On Dec 25, 3:41 am, "GAZ" <g...@.gaz.com> wrote:
>> >> "EMartinez" <emartinez...@.gmail.com> wrote in message
>> >>news:d2fc2115-efce-4d3e-9ee2-4965bd60ec77@.f52g2000hsa.googlegroups.com...
>> >> > On Dec 24, 8:33 am, "GAZ" <g...@.gaz.com> wrote:
>> >> >> Hello all,
>> >> >> We have an issue with reports we created using the VS 2005 Team
>> >> >> System.
>> >> >> When
>> >> >> we open a report everything looks fine and report prints fine as
>> >> >> well.
>> >> >> The problem is that when we click the Print Layout button on the
>> >> >> report
>> >> >> we
>> >> >> get a black page and only report title and group headers are
>> >> >> visible.
>> >> >> Mind
>> >> >> you, the report still prints fine on the printer but none of the
>> >> >> data
>> >> >> is
>> >> >> visible in the report.
>> >> >> Any ideas and solutions appreciated.
>> >> >> BR,
>> >> >> GAZ
>> >> > This should help.
>> >> >http://support.microsoft.com/kb/935356/en-us
>> >> > Regards,
>> >> > Enrique Martinez
>> >> > Sr. Software Consultant
>> >> Thanks for the info. Got it but it won't install. Every single hotfix
>> >> reports a failure to install. Has anyone else had any problems with
>> >> the
>> >> installation of the said hotfix?
>> >> BR,
>> >> GAZ
>> > You're welcome. You may have to install the Hot fixes in a particular
>> > order. Have you tried verifying the order in which the hot fixes must
>> > be installed? Hope this helps further.
>> > Regards,
>> > Enrique Martinez
>> > Sr. Software Consultant
>> Thanks for your answer.
>> The hotfixes are acutally rolled into one package which does not give you
>> an
>> option to choose a particular order for installation. When we start the
>> installation it always asks for the SQL installation disk and then it
>> reads
>> files from it and reports that the hotfix installation failed. And so on
>> for
>> each of the components.
>> Well, I guess that we'll have to wait for the SP3 to have the issue
>> resolved.
>> Thanks again for your help.
>> BR,
>> GAZ
>
> You're welcome. Have you checked the Event Viewer for errors that
> might be logged during the process? That might provide some better
> details. Hope this helps further.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Thanks for your help. Unfortunatelly the Event Log is of no help as it does
not provide any useful information. The logs created by the installation
process say that the hotfix package could not be found but i have no idea
what to do with that information as the package physically exists on the
hard drive where the setup process extracted it.
Well, I can only wait for the next SP i guess.
BR,
GAZ|||On Dec 27, 12:06 pm, "GAZ" <g...@.gaz.com> wrote:
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:7c2d5ac2-a280-4fe0-9a51-a53e315ea7dd@.1g2000hsl.googlegroups.com...
>
> > On Dec 26, 1:58 am, "GAZ" <g...@.gaz.com> wrote:
> >> "EMartinez" <emartinez...@.gmail.com> wrote in message
> >>news:3d431f4b-bd40-49c7-bb5f-c0f2b2c4b64e@.21g2000hsj.googlegroups.com...
> >> > On Dec 25, 3:41 am, "GAZ" <g...@.gaz.com> wrote:
> >> >> "EMartinez" <emartinez...@.gmail.com> wrote in message
> >> >>news:d2fc2115-efce-4d3e-9ee2-4965bd60ec77@.f52g2000hsa.googlegroups.com...
> >> >> > On Dec 24, 8:33 am, "GAZ" <g...@.gaz.com> wrote:
> >> >> >> Hello all,
> >> >> >> We have an issue with reports we created using the VS 2005 Team
> >> >> >> System.
> >> >> >> When
> >> >> >> we open a report everything looks fine and report prints fine as
> >> >> >> well.
> >> >> >> The problem is that when we click the Print Layout button on the
> >> >> >> report
> >> >> >> we
> >> >> >> get a black page and only report title and group headers are
> >> >> >> visible.
> >> >> >> Mind
> >> >> >> you, the report still prints fine on the printer but none of the
> >> >> >> data
> >> >> >> is
> >> >> >> visible in the report.
> >> >> >> Any ideas and solutions appreciated.
> >> >> >> BR,
> >> >> >> GAZ
> >> >> > This should help.
> >> >> >http://support.microsoft.com/kb/935356/en-us
> >> >> > Regards,
> >> >> > Enrique Martinez
> >> >> > Sr. Software Consultant
> >> >> Thanks for the info. Got it but it won't install. Every single hotfix
> >> >> reports a failure to install. Has anyone else had any problems with
> >> >> the
> >> >> installation of the said hotfix?
> >> >> BR,
> >> >> GAZ
> >> > You're welcome. You may have to install the Hot fixes in a particular
> >> > order. Have you tried verifying the order in which the hot fixes must
> >> > be installed? Hope this helps further.
> >> > Regards,
> >> > Enrique Martinez
> >> > Sr. Software Consultant
> >> Thanks for your answer.
> >> The hotfixes are acutally rolled into one package which does not give you
> >> an
> >> option to choose a particular order for installation. When we start the
> >> installation it always asks for the SQL installation disk and then it
> >> reads
> >> files from it and reports that the hotfix installation failed. And so on
> >> for
> >> each of the components.
> >> Well, I guess that we'll have to wait for the SP3 to have the issue
> >> resolved.
> >> Thanks again for your help.
> >> BR,
> >> GAZ
> > You're welcome. Have you checked the Event Viewer for errors that
> > might be logged during the process? That might provide some better
> > details. Hope this helps further.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Thanks for your help. Unfortunatelly the Event Log is of no help as it does
> not provide any useful information. The logs created by the installation
> process say that the hotfix package could not be found but i have no idea
> what to do with that information as the package physically exists on the
> hard drive where the setup process extracted it.
> Well, I can only wait for the next SP i guess.
> BR,
> GAZ
You're welcome. Do you have SQL Server and/or Reporting Services
installed in a non-standard location (i.e., on a D or E partition)? If
that is the case, this could be the problem.
Regards,
Enrique Martinez
Sr. Software Consultant