Hello,
I have a grid with a summary row as shown below in the attached pic. I would like to change/customize the Sum value displayed in the Grand Total row for Col A. I do not want it to add duplicate values in the grand total. So, since 8,289 is displayed twice, it should add it only once in the grand total. So the Grand Total for Col A should be displayed as 2,147,120.00 - 8,289 = 2,138,821.00. Col B should continue displaying as is.
Any help would be greatly appreciated!
Thanks
..
Hello Ozzlaren,
Could you please review the sample attached to this post and see if it meets your requirements. Please feel free to let me know if I misunderstood you or if you have any other questions.
Hello Boris,
Thank you so much for your quick response. Really appreciate it. I tried the code that you suggested and it does exactly how I wanted. However, now I have a slight display issue. It displays the calculated summary in a new line. I would like it to display the calculated summary value of 2138831 in the existing summary line instead of 2,147,120.00.
Please view attached pic..
Thanks in advance!
Actually I got it... I used Bands[0].Summaries.Clear() and then added my summaries in code for each of the columns i wanted it to be in.
Thank you for your help! :)
Hi,
I am glad to hear that you got it in time. Happy that you found your solution. Please feel free to let me know if a question about our tool set comes up on your mind.