Using two Scopes in SSRS

Navinkumar Kanagaraj 86 Reputation points
2022-05-02T14:00:34.717+00:00

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,949 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Isabellaz-1451 3,616 Reputation points
    2022-05-03T01:50:32.94+00:00

    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

    198359-image.png

    Best Regards,
    Isabella

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.