# The Sum (Total ) of report viewer's field doesn't change with

Page 1 of 1

## 1 Replies - 3808 Views - Last Post: 18 April 2013 - 06:07 PMRate Topic: //<![CDATA[ rating = new ipb.rating( 'topic_rate_', { url: 'http://www.dreamincode.net/forums/index.php?app=forums&module=ajax&section=topics&do=rateTopic&t=318757&amp;s=5c50517beaf925188155b3b779a045c7&md5check=' + ipb.vars['secure_hash'], cur_rating: 0, rated: 0, allow_rate: 0, multi_rate: 1, show_rate_text: true } ); //]]>

### #1 sabirmgd

Reputation: 0
• Posts: 3
• Joined: 06-February 13

# The Sum (Total ) of report viewer's field doesn't change with

Posted 17 April 2013 - 02:51 AM

```
when filtering the data of specific column in report viewer for example filtering the Sales details for specific date , the total of a field doesn't change it's value according to the filtering , for example these are the sales for the all duration

Item Name       Item Buy Price          Item sell Price    count       profit

x                  10                       20               3           30

yy                 15                       30               2           30

z                  5                        10               5            25

85

and when i filter the table to display the sales of a specific day as follow

Item Name    Item Buy Price       Item sell Price    count       profit

x              10                    20                 3           30

z              5                     10                5            25

[color="#FF0000"]85[/color]

in the sum of the profit we found that the sum supposed to be 55 not 85 .. so the sum function execute the operation for the all field and it doesn't consider the filtering, how to display the right sum ?

```

Is This A Good Question/Topic? 0

## Replies To: The Sum (Total ) of report viewer's field doesn't change with

### #2 BobRodes

• Lovable Curmudgeon

Reputation: 594
• Posts: 3,055
• Joined: 19-May 09

## Re: The Sum (Total ) of report viewer's field doesn't change with

Posted 18 April 2013 - 06:07 PM