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 ?
1 Replies - 931 Views - Last Post: 18 April 2013 - 06:07 PM
The Sum (Total ) of report viewer's field doesn't change with
Posted 17 April 2013 - 02:51 AM
Replies To: The Sum (Total ) of report viewer's field doesn't change with
Page 1 of 1