This is a migrated thread and some comments may be shown as answers.

Adding Totals Row

5 Answers 620 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
JV
Top achievements
Rank 1
JV asked on 05 Jan 2012, 09:16 PM
I have been experimenting with using Telerik Reporting now for a bit to replace an existing reporting component.  So far I have been impressed.  I have been recreating existing reports in Telerik and have recently come up against a wall.  I have a feeling it is a quick fix that is just eluding me.  I have a table that I can not add the total row to.  The "Add Total" option on the context menu is greyed out.  Am I missing something here?

Thanks.

5 Answers, 1 is accepted

Sort by
0
Elian
Telerik team
answered on 09 Jan 2012, 07:58 PM
Hello,
  1. The table should be bound (it should have a dataSource set in the designer, not in code)
  2. The field you want to add a total on should be numeric
  3. You should click in the body of the table (not in the header)
Greetings,
Elian
the Telerik team

Q3’11 of Telerik Reporting is available for download. Register for the What's New in Data Tools webinar to see what's new and get a chance to WIN A FREE LICENSE!

0
Steve Healey
Top achievements
Rank 1
answered on 03 Feb 2012, 12:07 PM
Is there a way to have a totals row if the data source is set in the code?  I have a report thats binds to a different data source based upon input values therefore I am using the table NeedDataSource event.

Many thanks.
0
Elian
Telerik team
answered on 06 Feb 2012, 06:54 PM
Hi Steve,

Yes, you can. What the "Add Totals" option from the context menu actually does is to add a static row group to the table (adjacent below to the detail group). See the two screenshots I have attached for a reference on how to add a static group to the table. 

Regards,
Elian
the Telerik team
Sharpen your .NET Ninja skills! Attend Q1 webinar week and get a chance to win a license! Book your seat now >>
0
NPL IT
Top achievements
Rank 1
answered on 15 Jan 2021, 03:48 PM

Hi Elian, can you get some clarification on the attached sceenshot.  I might be missing something.

 

 

0
Mads
Telerik team
answered on 20 Jan 2021, 02:15 PM

Hello Shawn,

As we also discussed this in another conversation I will use some of the replies I wrote there:

The "Add Totals" option should be enabled as long as the field is a number. In my investigation, as long as the field was returned as an integer from the SQL Server, the option was enabled. If you wish for us to look into this further, an option is to send us the report and I can look into the definition to see if I might find the cause.

 You can as well add this in a bit more manual way. Start by adding an extra row, outside of the group, as shown in the picture below

Then, inside the new row, add '= Sum(fields.Pieces)' as a value in the textbox where you want it to be. This should result in the same design as directly adding totals.

Regards, Mads Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Tags
General Discussions
Asked by
JV
Top achievements
Rank 1
Answers by
Elian
Telerik team
Steve Healey
Top achievements
Rank 1
NPL IT
Top achievements
Rank 1
Mads
Telerik team
Share this question
or