Monday, February 13, 2012

always show subreport

I have a report with many subreports. Recently the user requested that
they would like the subreport to show even if no data is returned in
the subreport. (They want the space on the report to show) Inside the
subreport is a table where the data is returned. Can this subreport be
shown spaces and all
without redoing the whole report and taking out the subreports? I
have tried everything I can think of. Any ideas?
Thanks in advance.
MissyNo, BUT, what you could do is have text that appears and says something like
No Data Available or something like that. You could make it verbiage that is
specific to the subreport. In your main report click on the subreport. There
is a proberty called No Data or something like that where you can set it to
some text.
See if that will be enough for them.
Note depending on what you are doing, subreports might be the only way to do
it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"aggiechick717" <mhoppe@.chkenergy.com> wrote in message
news:1164732075.527332.124750@.80g2000cwy.googlegroups.com...
>I have a report with many subreports. Recently the user requested that
> they would like the subreport to show even if no data is returned in
> the subreport. (They want the space on the report to show) Inside the
> subreport is a table where the data is returned. Can this subreport be
> shown spaces and all
> without redoing the whole report and taking out the subreports? I
> have tried everything I can think of. Any ideas?
> Thanks in advance.
>
> Missy
>|||Yes I have done that, but they still want space to write (a couple of
lines) is there any way to add lines to the no data comment?
Bruce L-C [MVP] wrote:
> No, BUT, what you could do is have text that appears and says something like
> No Data Available or something like that. You could make it verbiage that is
> specific to the subreport. In your main report click on the subreport. There
> is a proberty called No Data or something like that where you can set it to
> some text.
> See if that will be enough for them.
> Note depending on what you are doing, subreports might be the only way to do
> it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "aggiechick717" <mhoppe@.chkenergy.com> wrote in message
> news:1164732075.527332.124750@.80g2000cwy.googlegroups.com...
> >I have a report with many subreports. Recently the user requested that
> > they would like the subreport to show even if no data is returned in
> > the subreport. (They want the space on the report to show) Inside the
> > subreport is a table where the data is returned. Can this subreport be
> > shown spaces and all
> > without redoing the whole report and taking out the subreports? I
> > have tried everything I can think of. Any ideas?
> >
> > Thanks in advance.
> >
> >
> > Missy
> >

No comments:

Post a Comment