<div>
SQL returns data only. That kind of logic would have to be done in the report side of things.<br />
<br />
Lee
</div>


SQL returns data only. That kind of logic would have to be done in the report side of things.

Lee

<div>
inside your report say we have table<br />
<br />
&lt;table style=&quot;&lt;%=rs(&quot;dd&quot;)%&gt;<br />
<br />
here rs(&quot;dd&quot;) : rs is record set and dd is field name<br />
<br />
now come to query part<br />
<br />
select <br />
case when fieldname =&quot;test&quot; then &quot;display:none&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;else &quot;display:&quot;<br />
end as dd from tablenme<br />
<br />
Syntax might be wrong its just an idea
</div>


inside your report say we have table

<table style="<%=rs("dd")%>

here rs("dd") : rs is record set and dd is field name

now come to query part

select
case when fieldname ="test" then "display:none"
         else "display:"
end as dd from tablenme

Syntax might be wrong its just an idea

<div>
I was using the TRIM function but that only solves one side of the problem i'm trying to avoid if possible creating two diffrent reports.<br />
<br />
although the TRIM function removes the cell what I'm trying to work out is if &nbsp;for example the cell which shows the bussiness name for it to hide the cell which shows the customer name. 
</div>


I was using the TRIM function but that only solves one side of the problem i'm trying to avoid if possible creating two diffrent reports.

although the TRIM function removes the cell what I'm trying to work out is if  for example the cell which shows the bussiness name for it to hide the cell which shows the customer name.

<div>
<div class="content wysiwyg-content">
Hi,<br />
&nbsp;Is there any function in SQL which will allow to to hide cells on my Visual Studio report if theres another cell which is currently showing ?<br />
<br />

</div>
</div>


Hi,
 Is there any function in SQL which will allow to to hide cells on my Visual Studio report if theres another cell which is currently showing ?



Hiding cells function SQL

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 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.