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

How to add summary boxes on table

1 Answer 684 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Alex
Top achievements
Rank 1
Alex asked on 03 Mar 2011, 01:52 AM
Hi,

I've got a report that has one table in the detail section.  This table has a SQLDatasource and displays the rows and columns correctly.

I want to add a summary to the bottom of the table showing the sum of values under each column.  When I add a textbox to the detail section and manually place it under a column I am not able to reference the datasource fields.  When I open the expression window and select fields it shows "no data source".

How can I add these summary boxes to a few columns in my table?

Thanks

1 Answer, 1 is accepted

Sort by
1
Alex
Top achievements
Rank 1
answered on 03 Mar 2011, 11:26 PM
I figured it out on my own.  By right clicking the first column field in the table and choosing "Insert Row -> Outside Group - Below".

This will add a row to the end of the group/table where you will have access to the datasource.  You can then apply custom styles and formatting to the "summary row".  Using expressions to calculate the aggregate values for the columns.
Tags
General Discussions
Asked by
Alex
Top achievements
Rank 1
Answers by
Alex
Top achievements
Rank 1
Share this question
or