开发者

SSRS: Summing Static Rows Defined by Expressions

开发者 https://www.devze.com 2023-03-30 16:22 出处:网络
I am building a report that looks like: Last 30 DaysLast 60 DaysLast 90 Days SLA Met*1开发者_开发技巧35

I am building a report that looks like:

          Last 30 Days     Last 60 Days     Last 90 Days
SLA Met*      1          开发者_开发技巧      3                5 
SLA Missed*   2                4                6 
Total         3                7                11 

The datasource is via FetchXML and only one dataset is being used for the table. I am calculating the static rows, SLA Met and SLA Missed, using the expresion:

=(Count(IIf Condition, 1, Nothing)). 

Any ideas how I would get the total of these two static rows, as they do not belong to a group, not fields that I can easily sum, and are defined by an expression?

Thanks.


If I clearly understood the problem, the solution would be simple: = (expression) + (expression)

This amount must be in the same table.


You can create calculated fields with your condition, then use that data to create your total rows. They would then belong to the group and would be easy to sum up.

0

精彩评论

暂无评论...
验证码 换一张
取 消