Passing a value to a GroupFooter - Crystal Rpt 8

[SGIORDANO]

I have this problem in passing data to the groupfooter.

This is a picture of what I want.
I have an sum in the GroupFooter per country.

As a parameter I need to enter an amount which is >= to that amount.

Basically I need to do : (AmountEntered) >= (Amount in Group).
Using the Group Selection Editor is still not giving me any result.
Can someone give me an idea of how to tackle these situations.

Thanks
Steve

 

[kenhamady]

Question isn't clear. But it sounds like you want to only show groups that are less than your parameter entry. Your Group selection formula should be:

{?ParameterField} >= Sum ( {Amount} , {Country})

The right half of this comparison should be a Group Level Sigma in your field list. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[SGIORDANO]

Hi Ken

Thanks for you reply. What I wanted to say in the question is to : How to make parameters directly compare with the Grouping Amounts or Counts without giving you the error '

So basically the I was doing it all wrong as I was putting: On the other side.

Sum ( {Amount} , {Country}) <= {?ParameterField}

An other question. Where should I put the expression ?

&quot;Sum ( {Amount} , {Country}) <= {Amount_Parameter}&quot;. Is it the the Group Selection ?

Thank You
Steve

 

[kenhamady]

Yes. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com