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

170

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,845 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.