<div>
<div class="content wysiwyg-content">
I have a report that I am building in Visual Studio Reportviewer. I need for one of the texboxes in the matrix(table) to compare two fields. The two fields equal certian data then in that textbox show the value (data) of a third field. Below is an example of what I am talking about.<br />
=IIF(Fields!EDU_MARKET.Val<wbr />ue = &quot;21&quot; AND Fields!EDU_CLASS_NM.Value = &quot;Sales University&quot;, Fields!STAFFCNT21.Value,<br />
IIF(Fields!EDU_MARKET.Valu<wbr />e = &quot;22&quot; AND Fields!EDU_CLASS_NM.Value = &quot;Sales University&quot;, Fields!STAFFCNT22.Value, <br />
IIF(Fields!EDU_MARKET.Valu<wbr />e = &quot;23&quot; AND Fields!EDU_CLASS_NM.Value = &quot;Sales University&quot;, Fields!STAFFCNT23.Value,<br />
IIF(Fields!EDU_MARKET.Valu<wbr />e = &quot;24&quot; AND Fields!EDU_CLASS_NM.Value = &quot;Sales University&quot;, Fields!STAFFCNT24.Value, etc.....<br />
<br />
So In this examplr if EDU_MARKET equals 21 and EDU_CLASS_NM equals Sales University then display/show the data in STAFFCNT21<br />
then proceed to the nes IIF statement.
</div>
</div>


I have a report that I am building in Visual Studio Reportviewer. I need for one of the texboxes in the matrix(table) to compare two fields. The two fields equal certian data then in that textbox show the value (data) of a third field. Below is an example of what I am talking about.
=IIF(Fields!EDU_MARKET.Value = "21" AND Fields!EDU_CLASS_NM.Value = "Sales University", Fields!STAFFCNT21.Value,
IIF(Fields!EDU_MARKET.Value = "22" AND Fields!EDU_CLASS_NM.Value = "Sales University", Fields!STAFFCNT22.Value, 
IIF(Fields!EDU_MARKET.Value = "23" AND Fields!EDU_CLASS_NM.Value = "Sales University", Fields!STAFFCNT23.Value,
IIF(Fields!EDU_MARKET.Value = "24" AND Fields!EDU_CLASS_NM.Value = "Sales University", Fields!STAFFCNT24.Value, etc.....

So In this examplr if EDU_MARKET equals 21 and EDU_CLASS_NM equals Sales University then display/show the data in STAFFCNT21
then proceed to the nes IIF statement.

SSRS expression problem for VS2012 Report viewer report IIF

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

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.