Capturing data with criteria

[aramraj]

Hi,
I have a database field which at the end contains required info like (Q for Quarterly, SA for Semi Annual, A for Annual). I have to extract the data and save it to display the discount %age on page footer.
In addition to the required data I have some items which are dummy (Like membership doesn't get any discount). When I write a formula it is taking the last record into consideration. I cannot do re-ordering of the records as they want to display as-is.
For eg if I have
C1 Q
Membership
as two lines. I should able to save Q in the first line and ignore membership line.

How should I acheive this in crystal reports

 

[Madawc]

You should be able to do it with running totals. If you're not already familiar with Crystal's automated totals, see FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

You should show sample data and also show the formula you tried that didn't quite work. This is too abstract to follow as is.

-LB