I have a report that has a number of sub reports. sometimes a report
doesn't need certain sub reports due to the nature of the data. In these
cased I wanted to set the sub report visible property to False and hope that
the space where it resides would collapse. 2 Ways I can think of doing this
is either set a flag in the data on the main form and then when the report
renders run some logic (somewhere...) like if x<0 then subreportX.visible =
True, else subreportX.visible=False.

Any good advise out there?

Thanks.

btw: I'm running ssrs. sp2.

--
moondaddy@nospam.nospam

Hello,

Based on my scope, dynamic change report properties according to the result
the dataset is not currently support in RS. The following is just a
possible method using Web application. However, it may take some time to
implement this and it is unofficially support.

1. Retrieving RDL from catalog
2. Edit RDL on the fly according to the your own query result according to
the dataset running
3. Save the RDL to the catalog
3. Render the report by calling reporting service

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================


This posting is provided "AS IS" with no warranties, and confers no rights.




--------------------
| From: "moondaddy" <moondaddy@nospam.nospam>
| Subject: now to make sub report NOT visible based on value in another
field
| Date: Mon, 20 Jun 2005 17:23:09 -0500
| Lines: 18
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| Message-ID: <#g9gkZedFHA.1292@tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: cpe-24-175-69-234.houston.res.rr.com 24.175.69.234
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:46338
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I have a report that has a number of sub reports. sometimes a report
| doesn't need certain sub reports due to the nature of the data. In these
| cased I wanted to set the sub report visible property to False and hope
that
| the space where it resides would collapse. 2 Ways I can think of doing
this
| is either set a flag in the data on the main form and then when the
report
| renders run some logic (somewhere...) like if x<0 then subreportX.visible
=
| True, else subreportX.visible=False.
|
| Any good advise out there?
|
| Thanks.
|
| btw: I'm running ssrs. sp2.
|
| --
| moondaddy@nospam.nospam
|
|
|