Table Control in Report Header

[Srinath]

Hi,

I am using Table Control in Report Header to show summary data for the report.
I am using sqlDataSource to bind data to the table in the designer.

The summary information is shown properly, but i need to total the summary information.
So i basically need to add another row at the bottom of table which sums the individual column values for each row in the table.

But my menu has "Add Total" Disabled.

Pls help me out.

Thanks.
Srinath.

[Elian]

Hi Srinath,

The totals are added for each column separately. In order to be able to set a Total:

1. The table should be bound to a DataSource component
2. The cell you have selected must have a numeric type expression

If you want to add Totals manually, you have to create a static row group (adjacent below to the detail group) - see screen.png, then simply add the desired expressions in the table cells. A static group is a group with no grouping expressions (you have to first create the group with some expression and when done you can edit the group and delete the grouping expression, then the group will become static). 

Detailed information on table and how to manipulate it you may find in the help chapter Table/Crosstab/List.
 
All the best,
Elian
the Telerik team