SUM Function in RDLC Report | Aggregate Function In RDLC Report

hello viewers welcome to programming geek i am here with a new tutorial that is how to use sum function in rdlc report in c sharpens form application [Music] previous tutorial was how to create rdlc reporting situation form application with sql link given in the description box below okay this is the report what i have shown in the previous tutorial you can see this tutorial now i'm gonna create this tutorial to sum in rdls report in that case first of all i'm gonna add a column name find i i just added a find column in this table this data type is plot i mean number okay now in this data set there is no point column so first of all i'm gonna add the font column in the datasheet so go to the dataset that is it1.xsd this is the data table you can see that in for underscore tab now add a column this column i'll use to find yes find is edited in the dataset okay now expand the dataset folder and replace the dataset one okay find column is added now insert a column in the right yes now add find column yes find column is edited okay now all the code is same there's no change in this code okay debug load report yes the find column also added and the records and displaying in the rdlc report with find column okay now i'm gonna add some function to add some function of find column insert a text box yes in this point column right click and click on expression okay now expand the command functions in this conference just click on aggregate and then click on sum yes return some of the value of the specific expression you can see there are some example to use some function in rdlc report how to use some function rdlg report okay [Music] okay now you can write some after equal in the some expression for value or you can double click to the sum okay now just write code fields exclamation mark and then your field i mean your column is point dot value or dot value and close the first break and then click on ok yes it's added you can see some point is added now make it bold okay now debug click on load report yes it's edit and you can see the sum of the find column is displaying the below of point column okay now make it align right and insert one text object one more text object and put total finds achieved yes bold okay now i'm gonna add a rectangle to design this uh design this sum result so okay now change the back color of this rectangle yes now this is looking nice load report yes perfect report the find summer point is displaying the find below point column and total point achieved you can see that's this total point achieved thanks for watching this tutorial [Music] do [Music] you

Channel: ProgrammingGeek

Views: 9,889

Keywords: programminggeek, sum in rdlc report, aggregate function in rdlc report, sum in rdlc report table, rdlc report rutorial in c#, sum of one column in rdlc report, sum value of rdlc report, rdlc report sum of column, microsoft reports in c#, microsoft report viewer, rdlc report sum textbox value, aggregate function, rdlc report, sum function

Id: fs9X2cQaqZI

Length: 5min 3sec (303 seconds)

Published: Sun Apr 04 2021