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

166

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.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

GirishS 27,827 Moderator on at

Like (0)

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.

Was this reply helpful? Yes No