I have a report that uses 7 subreports. Some reports show, some don't
depending on the data received from the Shared Datasource. My initial report
appears fine in the viewer, however I have a single page following the last
page with data containing only the header. When I create a pdf, I have 4
pages at the end with only headers. The main report and the first subreport
should be the only ones outputting data.
Ideas?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200510/1I have found my problem, but no solution. When the subreports run, they are
given "space" on the report even if their visibility is set to False. This
is what is generating my "blank pages". This poses a new and even uglier
issue for me, What Now? My requirements are to have a single report that
gives alternate data depending on the needs of the user. I have two ideas:
1) Can I manually launch a subreport in code WITHOUT navigating away from
the parent report?
2) Is it possible to dynamically add a Subreport to the main report via VB
Code so only the subreports needed are run?
I am researching both avenues, but any advice you could offer would be WELL
received!
Rick wrote:
>I have a report that uses 7 subreports. Some reports show, some don't
>depending on the data received from the Shared Datasource. My initial report
>appears fine in the viewer, however I have a single page following the last
>page with data containing only the header. When I create a pdf, I have 4
>pages at the end with only headers. The main report and the first subreport
>should be the only ones outputting data.
>Ideas?
Message posted via http://www.sqlmonster.com|||I am also running into the same issue and finding no solution. Any help is
appreciated.
"Rick via SQLMonster.com" wrote:
> I have found my problem, but no solution. When the subreports run, they are
> given "space" on the report even if their visibility is set to False. This
> is what is generating my "blank pages". This poses a new and even uglier
> issue for me, What Now? My requirements are to have a single report that
> gives alternate data depending on the needs of the user. I have two ideas:
> 1) Can I manually launch a subreport in code WITHOUT navigating away from
> the parent report?
> 2) Is it possible to dynamically add a Subreport to the main report via VB
> Code so only the subreports needed are run?
> I am researching both avenues, but any advice you could offer would be WELL
> received!
> Rick wrote:
> >I have a report that uses 7 subreports. Some reports show, some don't
> >depending on the data received from the Shared Datasource. My initial report
> >appears fine in the viewer, however I have a single page following the last
> >page with data containing only the header. When I create a pdf, I have 4
> >pages at the end with only headers. The main report and the first subreport
> >should be the only ones outputting data.
> >
> >Ideas?
>
> --
> Message posted via http://www.sqlmonster.com
>|||Has Microsoft any answer to this problem as this is something has been faced
by many people and doesnt seem to find any solution.
Setting page size and margine is one part of avoiding blank pages but with
sub reports, it not only introduce blank pages and sometimes change the whole
look of the report.
"manish" wrote:
> I am also running into the same issue and finding no solution. Any help is
> appreciated.
> "Rick via SQLMonster.com" wrote:
> > I have found my problem, but no solution. When the subreports run, they are
> > given "space" on the report even if their visibility is set to False. This
> > is what is generating my "blank pages". This poses a new and even uglier
> > issue for me, What Now? My requirements are to have a single report that
> > gives alternate data depending on the needs of the user. I have two ideas:
> >
> > 1) Can I manually launch a subreport in code WITHOUT navigating away from
> > the parent report?
> >
> > 2) Is it possible to dynamically add a Subreport to the main report via VB
> > Code so only the subreports needed are run?
> >
> > I am researching both avenues, but any advice you could offer would be WELL
> > received!
> >
> > Rick wrote:
> > >I have a report that uses 7 subreports. Some reports show, some don't
> > >depending on the data received from the Shared Datasource. My initial report
> > >appears fine in the viewer, however I have a single page following the last
> > >page with data containing only the header. When I create a pdf, I have 4
> > >pages at the end with only headers. The main report and the first subreport
> > >should be the only ones outputting data.
> > >
> > >Ideas?
> >
> >
> > --
> > Message posted via http://www.sqlmonster.com
> >|||This is a good question, I see this issue often on many boards I post to. In
this case, it was my error. I was setting sub reports to hidden, however the
Rectangle they were in were not being set to hidden. Hence the blank pages.
When I set the Rectangle to invisible, it works like a charm. If you run
into this issue, I suggest you look at the container you placed your Sub
Report in, that just might be your error.
manish wrote:
>Has Microsoft any answer to this problem as this is something has been faced
>by many people and doesnt seem to find any solution.
>Setting page size and margine is one part of avoiding blank pages but with
>sub reports, it not only introduce blank pages and sometimes change the whole
>look of the report.
>> I am also running into the same issue and finding no solution. Any help is
>> appreciated.
>[quoted text clipped - 22 lines]
>> > >
>> > >Ideas?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200511/1|||Also, if you set the subreport (or its container) to be invisible
conditionally, any pagebreaks selected for that subreport or container
will be ignored. For me, it is a really anoying "feature".
