My application have summary report which is binded to the XamGrid. In the Grid SummaryRowSettings is enabled. In report resultset in between few rows will be having SUM value. Which i want to eliminate while calculating the sum. But now when i click on SUM of any grid column its getting the sum of all the records which is actually wrong in my case.
So could you please provide a sample which shows the Summary operations are calculated manually through the service. Please suggest if there is any other alternative. It is high priority for me. if possible attach the sample.
Thanks
Anil Kumar
Hi Anil,
I’m not sure that I understand exactly your application design. Are you using hierarchical data and multiple columnlayouts? Is that what you are describing as “resultset in between few rows will be having SUM value”?
Perhaps you could add an image of what you are describing so that I would be better able to visualize. Or perhaps you could give me the details of your grid’s code design.
HiThanks for your quick rsponse. I am not using any hierarchical data. I have uploaded the screenshot for your better understanding. In the screenshot First record is having Grand Total. Which is sum of rest of the column values.So when i click on Summation operation on any XamGrid column then i want to make a sum of all the column values Accept "Grand Total" column value. So when i perform Sum on any XamGrid Column it should be eqaul to Grand Total amount.I feel you understand it now.Thank you Anil Kumar