<div>
Its because the grouping is not valid outside the list. Make a wrapper group and try adding them in the wrapper group. 
</div>


Its because the grouping is not valid outside the list. Make a wrapper group and try adding them in the wrapper group.

<div>
Can you please provide details on how to make a wrapper group? &nbsp;Are you referring to a parent group?
</div>


Can you please provide details on how to make a wrapper group?  Are you referring to a parent group?

<div>
Yes, its parent group. Just do grouping without the field which is involved in the total.
</div>


Yes, its parent group. Just do grouping without the field which is involved in the total.

<div>
<div class="content wysiwyg-content">
We're trying to count a grand total at the very end of our report. &nbsp;We have 2 lists with totals that work fine. &nbsp;However, when we try to perform the grand total, with the expression outside the list box, we get an inscope error. &nbsp;If we move the expression inside the list box, the totals aren't giving a grand total. &nbsp;How do we write the correct inscope function? &nbsp;Here is the current expression that is giving the errors:<br />
<br />
=&quot;Grand Total - &nbsp; &nbsp;Inspections: &nbsp; &nbsp;&quot; &amp;&nbsp;CountDistinct(Fields!INSP_<wbr />ID.Value, &quot;Compliance&quot;) &amp;&nbsp;<br />
&quot;; &nbsp; &nbsp;Inspections With Violations: &quot;&nbsp;&amp; CountDistinct(IIF((Fields!<wbr />VIOL_ID.Va<wbr />lue, &quot;Compliance&quot;) &gt;&nbsp;1, (Fields!INSP_ID.Value, &quot;Compliance&quot;),Nothing)) &amp;<br />
&quot;; &nbsp; &nbsp;Violations: &nbsp; &nbsp;&quot; &amp;&nbsp;CountDistinct(Fields!VIOL_<wbr />ID.Value, &quot;Compliance&quot;) &amp;&nbsp;<br />
&quot;; &nbsp; &nbsp;Enforcements: &nbsp; &nbsp;&quot; &amp;&nbsp;CountDistinct(Fields!ENF_I<wbr />D.Value, &quot;Compliance&quot;)
</div>
</div>


We're trying to count a grand total at the very end of our report.  We have 2 lists with totals that work fine.  However, when we try to perform the grand total, with the expression outside the list box, we get an inscope error.  If we move the expression inside the list box, the totals aren't giving a grand total.  How do we write the correct inscope function?  Here is the current expression that is giving the errors:

="Grand Total -    Inspections:    " & CountDistinct(Fields!INSP_ID.Value, "Compliance") & 
";    Inspections With Violations: " & CountDistinct(IIF((Fields!VIOL_ID.Value, "Compliance") > 1, (Fields!INSP_ID.Value, "Compliance"),Nothing)) &
";    Violations:    " & CountDistinct(Fields!VIOL_ID.Value, "Compliance") & 
";    Enforcements:    " & CountDistinct(Fields!ENF_ID.Value, "Compliance")

InScope Function in 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.