Showing posts with label returned. Show all posts
Showing posts with label returned. Show all posts

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) Can this be
done without redoing the whole report and taking out the subreports? I
have tried everything I can think of. Any ideas?
Thanks in advance.
Missyaggiechick717 wrote:
> 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) Can this be
> done without redoing the whole report and taking out the subreports? I
> have tried everything I can think of. Any ideas?
> Thanks in advance.
> Missy
I have a similar issue but I am not able to figure it out please let me
know if you have found an answer
Thanks
shri|||I think i found a soln .......not confident about it
though.......try placing the subreport in a rectangle .let me know if
this helps
Thanks
shri|||I didn't get it to work...did you?
shri wrote:
> I think i found a soln .......not confident about it
> though.......try placing the subreport in a rectangle .let me know if
> this helps
> Thanks
> shri

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
> >