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
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
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,
Isabella