• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1416
  • Last Modified:

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

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?????
  • 2
1 Solution
Try this:

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

fusionfx2000Author Commented:
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
OK...try this:

=countrows(*)where( ISSUE_PRIORITY='(1) High')

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now