<div>
Can you please explain in details your iisue.. currently your syntax is wrong
</div>


Can you please explain in details your iisue.. currently your syntax is wrong

<div>
<div class="content wysiwyg-content">
In the following expression:<br />
<br />
=Sum(iif(cint(Fields!Range<wbr />.Value) &gt;= 0 And cint(Fields!Range.Value) &lt;= 124999 <br />
&nbsp;And (Fields!Date2 = Max(iif(Fields!Range.Value<wbr /> &gt;= 0 And Fields!Range.Value &lt;= 124999 and Fields!Date1.Value<br />
&nbsp; =Max(Fields!Date1.Value, &nbsp;&quot;Master_Policy_Number&quot;) <br />
&nbsp; ,Fields!Date2, Nothing), &quot;Master_Policy_Number&quot;)),<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;cint(Fields!Range.Value), 0))<br />
<br />
I need to sum 1 and ONLY one where the coditions are met..<br />
<br />
<br />
How???
</div>
</div>


In the following expression:

=Sum(iif(cint(Fields!Range.Value) >= 0 And cint(Fields!Range.Value) <= 124999 
 And (Fields!Date2 = Max(iif(Fields!Range.Value >= 0 And Fields!Range.Value <= 124999 and Fields!Date1.Value
  =Max(Fields!Date1.Value,  "Master_Policy_Number") 
  ,Fields!Date2, Nothing), "Master_Policy_Number")),
	cint(Fields!Range.Value), 0))

I need to sum 1 and ONLY one where the coditions are met..


How???

SQL expression /// sum  SSRS

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.