Edited: 5/2/2012 11:01 PM | |  | |
| Sum a Calculated Column Starting from a post on Sharepoint 2010 Forum, here are steps "How to"
First, i created a new page, in which in first side i inserted the values from a list as they are. One of these columns is a calculated column, and is named: Difference
In the bottom side, already exist the DataFormWebpart modified. The page can be found here.
After I created the page with an initial DFWP I have selected from ribbon "Sort & Group".
In the new window select one single line column, a mandatory column; in my case "Title"
Next I need to group all items, in one group. For this, I will select all items with Title field not empty. To do it, select in the right side button "Edit Sort Expression...". In the new window i will insert a new code, as bellow:
Next step , check "Show group footer":
and select "Show column totals per group"
Click OK button, and now we have in our page sum calculated values for each column. What i have to do is to customize itNow, let's customize the page. First, I will eliminate row named: "Count" as bellow:
For this, select word "Count" and then goto code side and remove the code:
As you can see , the row isn't there anymore.
Last step, customize the row which contain sum values:
| |  |  |
|
Manage Subscriptions
/_layouts/images/ReportServer/Manage_Subscription.gif
/_layouts/ReportServer/ManageSubscriptions.aspx?list={ListId}&ID={ItemId}
0x80
0x0
FileType
rdl
350
Manage Data Sources
/_layouts/ReportServer/DataSourceList.aspx?list={ListId}&ID={ItemId}
0x0
0x20
FileType
rdl
351
Manage Shared Datasets
/_layouts/ReportServer/DatasetList.aspx?list={ListId}&ID={ItemId}
0x0
0x20
FileType
rdl
352
Manage Parameters
/_layouts/ReportServer/ParameterList.aspx?list={ListId}&ID={ItemId}
0x0
0x4
FileType
rdl
353
Manage Processing Options
/_layouts/ReportServer/ReportExecution.aspx?list={ListId}&ID={ItemId}
0x0
0x4
FileType
rdl
354
Manage Cache Refresh Plans
/_layouts/ReportServer/CacheRefreshPlanList.aspx?list={ListId}&ID={ItemId}
0x0
0x4
FileType
rdl
355
View Report History
/_layouts/ReportServer/ReportHistory.aspx?list={ListId}&ID={ItemId}
0x0
0x40
FileType
rdl
356
View Dependent Items
/_layouts/ReportServer/DependentItems.aspx?list={ListId}&ID={ItemId}
0x0
0x4
FileType
rsds
350
Edit Data Source Definition
/_layouts/ReportServer/SharedDataSource.aspx?list={ListId}&ID={ItemId}
0x0
0x4
FileType
rsds
351
View Dependent Items
/_layouts/ReportServer/DependentItems.aspx?list={ListId}&ID={ItemId}
0x0
0x4
FileType
smdl
350
Manage Clickthrough Reports
/_layouts/ReportServer/ModelClickThrough.aspx?list={ListId}&ID={ItemId}
0x0
0x4
FileType
smdl
352
Manage Model Item Security
/_layouts/ReportServer/ModelItemSecurity.aspx?list={ListId}&ID={ItemId}
0x0
0x2000000
FileType
smdl
353
Regenerate Model
/_layouts/ReportServer/GenerateModel.aspx?list={ListId}&ID={ItemId}
0x0
0x4
FileType
smdl
354
Manage Data Sources
/_layouts/ReportServer/DataSourceList.aspx?list={ListId}&ID={ItemId}
0x0
0x20
FileType
smdl
351
Load in Report Builder
/_layouts/ReportServer/RSAction.aspx?RSAction=ReportBuilderModelContext&list={ListId}&ID={ItemId}
0x0
0x2
FileType
smdl
250
Edit in Report Builder
/_layouts/images/ReportServer/EditReport.gif
/_layouts/ReportServer/RSAction.aspx?RSAction=ReportBuilderReportContext&list={ListId}&ID={ItemId}
0x0
0x4
FileType
rdl
250
Edit in Report Builder
/_layouts/ReportServer/RSAction.aspx?RSAction=ReportBuilderDatasetContext&list={ListId}&ID={ItemId}
0x0
0x4
FileType
rsd
250
Manage Caching Options
/_layouts/ReportServer/DatasetCachingOptions.aspx?list={ListId}&ID={ItemId}
0x0
0x4
FileType
rsd
350
Manage Cache Refresh Plans
/_layouts/ReportServer/CacheRefreshPlanList.aspx?list={ListId}&ID={ItemId}&IsDataset=true
0x0
0x4
FileType
rsd
351
Manage Data Sources
/_layouts/ReportServer/DataSourceList.aspx?list={ListId}&ID={ItemId}
0x0
0x20
FileType
rsd
352
View Dependent Items
/_layouts/ReportServer/DependentItems.aspx?list={ListId}&ID={ItemId}
0x0
0x4
FileType
rsd
353