Link to home
Start Free TrialLog in
Avatar of Norm-al
Norm-alFlag for United States of America

asked on

On Get Footer Summary Styles Event assistance

I need to highlight the group summary box based on its value being over $350,000.  My code only gives me NULL values.  Help? (i also included commented code that continues to give me NULL AValues)

//  AIndex :=  AView.DataController.Summary.FooterSummaryItems.IndexOfItemLink(gvSalesForecastSales_Amount);
//  AValue := AView.DataController.Summary.FooterSummaryValues[AIndex];
//
//  if ((AColumn = gvSalesForecastSales_Amount) and (AFooterGroupLevel <> -1) and (AValue > 350000)) then AStyle := dmLeads.cxStyle2;

  if (AColumn.Index = 6) and (AView.DataController.Summary.FooterSummaryValues[AColumn.Index] > 350000) then
   AStyle := dmLeads.cxStyle2;

Open in new window

Avatar of Thommy
Thommy
Flag of Germany image
This should work...
AIndex :=  AView.DataController.Summary.FooterSummaryItems.IndexOfItemLink(gvSalesForecastSales_Amount);
AValue := AView.DataController.Summary.FooterSummaryValues[AIndex];

if (AValue > 350000) then AStyle := dmLeads.cxStyle2;

Open in new window

Avatar of Norm-al
Norm-al
Flag of United States of America image

ASKER

I tried that and it looks like it keeps giving me the same Index and NULL Value. Trying it again...
Avatar of Norm-al
Norm-al
Flag of United States of America image

ASKER

It highlighted all Group Summary items even though they were not more than 350000. Am I using the wrong event?  The summary that I am using values on is the Group Footer Summary Values (not the footer)
Avatar of Norm-al
Norm-al
Flag of United States of America image

ASKER

Let me clarify that. I have a subgrouping by date. If the subgrouped values for SalesAmount within that group (that group's summary value) is over $350,000 then highlight that Group Footer Summary Value.
ASKER CERTIFIED SOLUTION
Avatar of Thommy
Thommy
Flag of Germany image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Norm-al
Norm-al
Flag of United States of America image

ASKER

I need to apply styles based on values not row index.

How do I get the value of the group footer summary?
Avatar of Geert G
Geert G
Flag of Belgium image
are you precreating the footers or letting the users create the footers and then highlight them  ?
Avatar of Norm-al
Norm-al
Flag of United States of America image

ASKER

I set the group footer summary on the grid myself.. Those are the values I want to highlight based on if they are greater than $350000
Avatar of Norm-al
Norm-al
Flag of United States of America image

ASKER

Here's a screenshot; I want those highlights there but ONLY if that group summary total is over $350000
untitled.bmp