<div>
Try this:<br />
<br />
=count(*)where( Fields!ISSUE_PRIORITY.Valu<wbr />e='(1) High')<br />
<br />
M@
</div>


Try this:

=count(*)where( Fields!ISSUE_PRIORITY.Value='(1) High')

M@

<div>
It told me count is no longer supported and to use countrows; &nbsp;when i used <br />
<br />
=countrows(*)where( Fields!ISSUE_PRIORITY.Valu<wbr />e='(1) High'), I'm getting the following error:<br />
<br />
The value expression for the textbox ‘ISSUE_NAME_2’ has a scope parameter that is not valid for an aggregate function. &nbsp;The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a data set.<br />
<br />
I have 2 list boxes like this:<br />
<br />
lst_projects (which contains group by projectname)<br />
&nbsp; &nbsp; lst_issues (which contains group by issuename)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; count is located here within lst_projects
</div>


It told me count is no longer supported and to use countrows;  when i used

=countrows(*)where( Fields!ISSUE_PRIORITY.Value='(1) High'), I'm getting the following error:

The value expression for the textbox ‘ISSUE_NAME_2’ has a scope parameter that is not valid for an aggregate function.  The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a data set.

I have 2 list boxes like this:

lst_projects (which contains group by projectname)
    lst_issues (which contains group by issuename)
                                                                    count is located here within lst_projects

<div>
<div class="content wysiwyg-content">
I'm using Sql server reporting services and trying to get an expression to work, but it isn't; this is what I want it to do, but not working:<br />
<br />
=count(Fields!ISSUE_NAME.V<wbr />alue)where<wbr />( Fields!ISSUE_PRIORITY.Valu<wbr />e='(1) High')<br />
<br />
maybe the where is wrong?????
</div>
</div>


I'm using Sql server reporting services and trying to get an expression to work, but it isn't; this is what I want it to do, but not working:

=count(Fields!ISSUE_NAME.Value)where( Fields!ISSUE_PRIORITY.Value='(1) High')

maybe the where is wrong?????

Sql Server Reporting Services Expression HELP Please!!!!! Count(not working)

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.