Adding Totals Row

[JV]

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.

[Elian]

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

[Steve Healey]

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.

[Elian]

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

[NPL IT]

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

 

 

[Mads]

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