1. Home
  2. Forum
  3. Report Platform
  4. Group and total
If you became a customer of the Syncfusion� Reporting Platform or the Report Viewer, Report Designer, or Report Writer components before October 2019 and have questions related to those products, you can request support through our forum system. However, please note that this support system is only for existing customers who are still using the Syncfusion� Reporting Platform or its components and not for new customers looking for reporting products from Syncfusion�.

For new customers or those with general reporting questions, we recommend contacting our support team at https://support.boldreports.com/, which is a separate brand created by Syncfusion� for its reporting solutions. Our team will be happy to assist you with any questions you may have.

Thank you for choosing Syncfusion� for your reporting needs.

Group and total

I'm trying to add a line with the sum or row values grouped by a column unsucessfully.
I managed to show my report exactly as you see in the picture in attachment but I don't find a solution to add a row with the sum of "ore" showed in the red boxes.
Sum of "ore" must be showed between the lines for every group of "Operazione" but following all the suggestions in the documentation, I could show this value only one after the other at the end of the table.
Is there a way to solve this problem ?

Thanks
Best Regards



Attachment: Groupandsum_d318d7ef.zip

4 Replies 1 reply marked as answer
MS Mahendran Shanmugam Syncfusion Team December 22, 2020 12:30 PM UTC

Hi Walter, 

Could you please add the total after the main group and add the sum of field value as shown in below snap. 
 

Regards, 
Mahendran S. 


Marked as answer
WM Walter Martin December 22, 2020 02:09 PM UTC

I simplifyed the RDLC to better show the problem
If you see now I have only one tablix without any grouped rows
I need to group the data by "operazione" that is the column before the last in the picture and show the sum of the "ore" that is the last column.
If you see my picture, the sum should be placed between the rows in the red rectangle and not at the end of the tablix because grouping by "operazione" it is the place where the information changes.

My data comes froma SQL server query where there's no "group by" function because I leave the RDLC to group them.
It seems to be I need to use the "row group" functio in some way but the sum is always placed at the end of the tablix and not when the grouped information changes

I hope now is more clear and to have a solution 
Thanks
Best Regards


Attachment: group_bea6dce7.zip

WM Walter Martin December 22, 2020 11:46 PM UTC

Don't worry about this request, I found the solution inside your documentation in the example of adding grouping and totals

https://help.boldreports.com/standalone-report-designer/designer-guide/report-items/tablix/add-grouping-and-totals-in-tablix-design/

Thanks
Best Regards

MS Mahendran Shanmugam Syncfusion Team December 23, 2020 07:43 AM UTC

Hi Walter,  

Thanks for your update. 

Please let us know if you need any assistance. 

Regards, 
Mahendran S. 


Loader.
Up arrow icon