[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1393
  • 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?????
0
fusionfx2000
Asked:
fusionfx2000
  • 2
1 Solution
 
ExpertAdminCommented:
Try this:

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

M@
0
 
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
0
 
ExpertAdminCommented:
OK...try this:

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

M@
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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