I have a grid that is programmatically created in Page_Load that also includes a varying number of calculated columns. Each column contains an aggregate (count, sum, etc.). However, one of my columns is a percentage that is calculated based on other bound columns. Each row's calculation is done perfectly, but the grid footer should apply the same expression to the rest of the footer's values. The real trick is that the expression being used by the grid is not known at design time so I am unable to manually create a custom aggregate.
Anyone have any ideas how I can use the expression and datafields from the GridCalculatedColumn to evaluate that column's footer?
Anyone have any ideas how I can use the expression and datafields from the GridCalculatedColumn to evaluate that column's footer?