Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

On Get Footer Summary Styles Event assistance

Posted on 2013-02-04
9
Medium Priority
?
414 Views
Last Modified: 2013-06-07
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

0
Comment
Question by:Bianca
  • 6
  • 2
9 Comments
 
LVL 19

Expert Comment

by:Thommy
ID: 38853212
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

0
 

Author Comment

by:Bianca
ID: 38853219
I tried that and it looks like it keeps giving me the same Index and NULL Value. Trying it again...
0
 

Author Comment

by:Bianca
ID: 38853232
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)
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:Bianca
ID: 38853240
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.
0
 
LVL 19

Accepted Solution

by:
Thommy earned 2000 total points
ID: 38854059
The right events are OnGetGroupSummaryStyle or OnCustomDrawGroupSummaryCell ...

This will probably help you...
Group summary color based on group by index

Also have a look at the downloadable sample code at the above url...
0
 

Author Comment

by:Bianca
ID: 38855388
I need to apply styles based on values not row index.

How do I get the value of the group footer summary?
0
 
LVL 38

Expert Comment

by:Geert Gruwez
ID: 38858326
are you precreating the footers or letting the users create the footers and then highlight them  ?
0
 

Author Comment

by:Bianca
ID: 38859579
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
0
 

Author Comment

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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Suggested Courses

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question