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?
>
Showing posts with label invisible. Show all posts
Showing posts with label invisible. Show all posts
Monday, February 20, 2012
Q: sub-report visible/invisible
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,
> >
>
>
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,
> >
>
>
Subscribe to:
Comments (Atom)