Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


InScope Function in SSRS

Posted on 2011-10-18
Medium Priority
Last Modified: 2013-11-05
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")
Question by:GaleMellinger
  • 2
  • 2
LVL 25

Expert Comment

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

Author Comment

ID: 36995851
Can you please provide details on how to make a wrapper group?  Are you referring to a parent group?
LVL 21

Accepted Solution

Alpesh Patel earned 2000 total points
ID: 36997829
LVL 25

Expert Comment

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

Author Closing Comment

ID: 37007913
Thank you.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses
Course of the Month11 days, 2 hours left to enroll

571 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