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

Posted on 2006-06-01
Last Modified: 2008-01-09
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?????
Question by:fusionfx2000
    LVL 7

    Expert Comment

    Try this:

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


    Author Comment

    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
    LVL 7

    Accepted Solution

    OK...try this:

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


    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Introduction: Often, when running a query with joins, the results show up "duplicates", and often, those duplicates can be "eliminated" in the results using DISTINCT, for example. Using DISTINCT is simple: just add it after the SELECT keyword, an…
    Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now