Last post Dec 05, 2016 07:46 AM by Cathy Zou
Dec 01, 2016 06:34 PM|acmedeepak|LINK
I have date,sub total in my RDLC table. I need to remove the time stamp in the Date and also make a sum of the sub totals and show it as total at the bottom of the screen. Can anyone please help me in this.
Time shows as: 16-11-2005 00:00:00, I need to remove zeros
Then show a Total at end of the report.
Dec 05, 2016 07:46 AM|Cathy Zou|LINK
From your description, I suggest you could use linq to datatable make a sum of the sub totals.
var sum = table.AsEnumerable().Sum(x=>x.Field<int>("SomeProperty"));
For your second problem, I suggest you could use substring in linq