Showing posts with label sub-reports. Show all posts
Showing posts with label sub-reports. Show all posts

Monday, February 20, 2012

q: this strange problem

Hello,
I have different sub-reports in my main report. I have rectangles around my
sub-reporta to be able to put page breaks te the start of rectangle. I need
to make some sub-report visible and invisible based on a parameter. However I
am using =iif(Parameters!MyPar.Value = "true",false, true) in the visibility
property and this creates problem in the page break of the visible reports.
Any idea?If the sub-report becomes not visible then the page break is ignored.
To fix this, use a seperate rectangle control (make it tiny and place
it below the subreport on the master report) and set the page break
property on this new rectangle control.
HTH-
Matt A

Q: sub-report visible/invisible

Hello,
I have a parameter and may sub-reports. I want to make one sub-report be
visible or invisible based one of the parameter true or false. Can I do this?answered in your other post, but answer is yes.
from other thread -
Yes that should work fine, right click on the greyed out subreport on your
master report, go to properties and visibility and stick the expression in
the box.
=iif(parameters!name.value = "true",false, true)
basically says "if parameter is true then show else don't show."
Greg
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:DB8F757A-0E83-4665-8205-04A51AF539BB@.microsoft.com...
> Hello,
> I have a parameter and may sub-reports. I want to make one sub-report be
> visible or invisible based one of the parameter true or false. Can I do
> this?
>

Q: report manager

Hello,
How can I make my sub-reports invisible in the report manager, I do not want
users click them and try to run.
Thanks,In report manager there is a properties tab, there is a check box for not
showing it in list view.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:8815E795-7DA9-4190-AC09-3E669725A84D@.microsoft.com...
> Hello,
> How can I make my sub-reports invisible in the report manager, I do not
> want
> users click them and try to run.
> Thanks,
>|||I think it is labeled "Hide Report"
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Bruce L-C [MVP]" wrote:
> In report manager there is a properties tab, there is a check box for not
> showing it in list view.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:8815E795-7DA9-4190-AC09-3E669725A84D@.microsoft.com...
> > Hello,
> > How can I make my sub-reports invisible in the report manager, I do not
> > want
> > users click them and try to run.
> > Thanks,
> >
>
>