Publishing subreports

One of my reports uses a subreport. I use a script that runs under RS.EXE to
publish the reports, with the result that the subreport appears in the list
view where the user may be tempted to go in and try to run it, even though
it's not intended for stand-alone use.
I can hide it by going to Properties/General and checking off "Hide in list
view", but I would prefer to make the setup completely automatic.
Is there any way to set "Hide in list view" directly from the script?
Thanks,
PeterSure. Have a look at the scripts generated by Reporting Services Scripter
for a hidden report
http://www.sqldbatips.com/showarticle.asp?ID=62
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"jpstewart" <jpeterstewart@.hotmail.com.nospam> wrote in message
news:399E98E6-3543-4204-A9F6-484A1C527D99@.microsoft.com...
> One of my reports uses a subreport. I use a script that runs under RS.EXE
> to
> publish the reports, with the result that the subreport appears in the
> list
> view where the user may be tempted to go in and try to run it, even though
> it's not intended for stand-alone use.
> I can hide it by going to Properties/General and checking off "Hide in
> list
> view", but I would prefer to make the setup completely automatic.
> Is there any way to set "Hide in list view" directly from the script?
> Thanks,
> Peter
>|||Did you get an idea of how to access Hide in List view property programatically?. I am also strugling with the same problem. Please send me the reply to my gmail
From http://www.developmentnow.com/g/115_2005_8_0_0_574025/Publishing-subreports.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Published Report Not Showing Correctly in Report Manager webpage

have a report that in the designer in Visual Studio it displays correctly on
the preview tab.
The report has 5 subreports and one of the subreports is a matrix.
On the report I have a parameter for the user to choose rather to see the
matrix subreport or not.
When I view the report in the report manager web page and the user select to
yes to view the matrix sub report, the main report is missing fields and
formatted incorrectly, if you select no on the parameter for viewing the
matrix sub report, the fields return on the main report but are still not
alligned correctly. None of the missing fields have any expressions to
control the visible property , only the matrix sub report. The matrix
subreport is several inches away from any of the fields that end up missing.
The fields that are missing are unbound textboxes used as labels.
I tried to delete the report from the report server and re-deploy but still
the same effect.
Why is the report manager different than the Visual Studio preview and
causing this bug?What version are you on? In RS 2000 the report designer had its own
renderer. In RS 2005 it uses the same rendering engine as the server does.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RBS" <RBS@.discussions.microsoft.com> wrote in message
news:831D8D9D-B3C2-485D-8B16-089A6DC76563@.microsoft.com...
> have a report that in the designer in Visual Studio it displays correctly
> on
> the preview tab.
> The report has 5 subreports and one of the subreports is a matrix.
> On the report I have a parameter for the user to choose rather to see the
> matrix subreport or not.
>
> When I view the report in the report manager web page and the user select
> to
> yes to view the matrix sub report, the main report is missing fields and
> formatted incorrectly, if you select no on the parameter for viewing the
> matrix sub report, the fields return on the main report but are still not
> alligned correctly. None of the missing fields have any expressions to
> control the visible property , only the matrix sub report. The matrix
> subreport is several inches away from any of the fields that end up
> missing.
> The fields that are missing are unbound textboxes used as labels.
>
> I tried to delete the report from the report server and re-deploy but
> still
> the same effect.
>
> Why is the report manager different than the Visual Studio preview and
> causing this bug?
>