Using two Scopes in SSRS

Navinkumar Kanagaraj 86 Reputation points

Can I use two scopes in SSRS, Where in sum(Expression, Scope).

For Example, In a tablix I have Grouped the Data in row level based on one field and I have grouped the Column based on one Field.

In that Column can I use both the Column Scope and Row Scope and get the Sum.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,358 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Isabellaz-1451 3,606 Reputation points

    Hi @Navinkumar Kanagaraj

    There are two ways you can get the sum :
    One way is using expression =Sum(Fields!SALES.Value) ,without scope name.

    The other way as the below screenshot ,use the Add Total selection


    Best Regards,

    0 comments No comments