Getting Sum of an expression in a textbox of table present in the design of a SSRS report.

(0) Share

Report

Posted on by Apratim

149

Hi,

Thanks in advance.

I have a SSRS report in which I have added a table in design. In one of the table textbox I have an expression shown below.

IIF(sum(Fields!Qty.Value)=0,0,
(sum(Fields!QtyTwo.Value)-sum(Fields!Qty.Value))/(sum(Fields!Qty.Value)))

The row here in this table is grouped by itemId. So it will show multiple rows for different itemid and each itemid will have an output for this expression mentioned above.

I want to get the sum of the output of this expression for all itemId at the bottom of the table in the report design.

Thanks.

All responses (1)

Answers (0)

Suggested answer

GirishS 27,821 Super User 2024 Season 1 on at

Like (0)

Report

RE: Getting Sum of an expression in a textbox of table present in the design of a SSRS report.

Hi Apratim,

Try adding the row and outside of the group and check.

Just select the last row and select "Insert row >> Outside group below - On that group you can write expression for the totals irrespective of the groups.

Thanks,

Girish S.