1 Replies - 1667 Views - Last Post: 18 April 2013 - 06:07 PM Rate Topic: -----

#1 sabirmgd  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • 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  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 572
  • View blog
  • Posts: 2,985
  • Joined: 19-May 09

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

Posted 18 April 2013 - 06:07 PM

http://www.codeproje...s-Report-viewer
Was This Post Helpful? 1
  • +
  • -

Page 1 of 1