Print non changing data in Headers & Footers in views
I would like to have the facility to display certain column values in either a header or footer section in a view, instead of having to display them on each row. For example I create customer statements which have a period opening balance, a list of transactions and a closing balance. At the moment I have to display the period opening balance and period closing balance on each row. This is very confusing as the values are identical on each row. It is even more confusing that these values are totalled in the Grouping sections. The sum of these values are meaningless and should not be displayed. These values only need to be displayed once per statement, either in a header or footer. At the moment I have to export the view to excel and this loses the grouping so the view is fairly useless
ID 179
Category User Experience
Author
Denis Barry-Smith
Date Created 11/28/2007 10:41:24 AM
Date Updated 11/30/2007 5:04:44 AM
Status New Idea
Score 10
Promoted By
Denis Barry-Smith
Comments
Kirill Bondar Staff 11/28/2007 10:54:45 AM
FYI, you may control whether to calculate Group/Grand Total or Average for the column via column's Total and Average properties.
Denis Barry-Smith 11/28/2007 11:04:04 AM
Thanks Kirril but these are lookup fields and do not have that option
Kirill Bondar Staff 11/28/2007 11:21:57 AM
Lookup columns use settings from the column they refer to.
Denis Barry-Smith 11/28/2007 11:33:34 AM
I know that but it is only in this view I don't want them totalled.