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
Hi Anil.
I am assuming that the value at the bottom is generated by the grid’s enabled row summaries.
However, it isn’t clear to me how you are getting the first row in your grid with the Grand Total and values. It looks like that top row is actually a row in your data source. Is that the case?
Hi,
Yes Exactly. First row in my result set is having the Sum. This is the one of the scenario and we have similar kind of many scenarios. So please guide me to call the grid column summation operation manually or similar solutions.
The default summaries are going to account for all records in the datasource as equals. If you want to selectively filter out entries (which for us appear as just data rows) you would need to create a custom summary and use that rather then the inbox summaries.
In our help we discuss how this can be done.
Create a Custom Summary
It looks like Darrell gave you the link to creating custom summaries.
Please let me know if you have any questions or there is anything I can help with.