How to make the total column of a summary row recalc when I show/hide other columns of that summary row

[James Blibo]

I have a summary rows above my header as follows:

sumary 1: 1446 -- 300 --- 250 -- 341 -- 555
---------------------------------------------
header : ------ 1Q06 -- 2Q06 --- 3Q06 --4Q06
---------------------------------------------
Caption1--1445-- 300 --- 250 -- 341 -- 555
Record 1:--742-- 140 --- 150 --- 230 -- 222
record 2:--704-- 160 --- 100 --- 111 -- 333


I have a select box that shows all the quarters (1Q06, 2Q06, 3Q06 and 4Q06). When the user select a specific quarter, I am hiding the columns of the other

quarters. For example, when the user selects 3Q06, I hide 1Q06, 2Q06, and 4Q06. I am showing/hiding columns thru VisibleColumns Add/Remove

How can I make the totals of the summary row and the caption row reflect only the total of the selected quarter INSTEAD of the total of the entire grid (all

quarters). I do not want to re-bind the datasource again.

[Administrator]

Hi James,

We were not able to reproduce the issue here. Is it possible for you to upload us a sample or modify the attached samples to reproduce the issue here? This will help us to analyse the issue further.

Here is a sample.
GGCShowSummaryCaption.zip

Best Regards,
Haneef