<div>
Write an IIF(&quot;if clause&quot;, true, false) clause in the Visibility property.
</div>


Write an IIF("if clause", true, false) clause in the Visibility property.

<div>
I can get that, but the problem that i am having is that there is just a big hole where that section should be, &nbsp;is there a property or something that i can change that will move everything below that hidden field up so there is not a big hole in the report?
</div>


I can get that, but the problem that i am having is that there is just a big hole where that section should be,  is there a property or something that i can change that will move everything below that hidden field up so there is not a big hole in the report?

<div>
Oops ... no ... that is not possible... tried it .. space will be there ... unless you move it to the end of the report.
</div>


Oops ... no ... that is not possible... tried it .. space will be there ... unless you move it to the end of the report.

<div>
Yeah that sounds right, buy where is the rows property? Im in visual stuido 2005. &nbsp;is it on the subreport properties in the main report, or in the actaul report properties of the report that i want to be a subreport....if that makes sense
</div>


Yeah that sounds right, buy where is the rows property? Im in visual stuido 2005.  is it on the subreport properties in the main report, or in the actaul report properties of the report that i want to be a subreport....if that makes sense

<div>
oh i think i see what you are saying. &nbsp;so put a actual table on my report and in each of the rows put a subreport in that?
</div>


oh i think i see what you are saying.  so put a actual table on my report and in each of the rows put a subreport in that?

<div>
thank you very much for your hlep
</div>


<div>
<div class="content wysiwyg-content">
How can i make a sub report disapear from a SQL report based on cretrin parameters. &nbsp;I know i can set the visiblility to Hidden = true, but I want it to not only disappear but i also want it to move everthing that is below it up. &nbsp;any adviss would be helpful
</div>
</div>


How can i make a sub report disapear from a SQL report based on cretrin parameters.  I know i can set the visiblility to Hidden = true, but I want it to not only disappear but i also want it to move everthing that is below it up.  any adviss would be helpful

SQL Reports SubReports

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.