RecordSelectionFormula - Sum of a numeric field 1

[kab555]

In a Crystal Report, I am using a group in order to report data on one line per item. In doing so, I am using sums of numeric fields on the group footer (the detail section is not being used in this report). How can the sum of a numeric field be represented when using the RecordSelectionFormula in VB. I am trying to allow a user to chose data where the sum of the paid amounts for any claim is above an entered value.

An example of what I'm attemping right now is
ReportSelectionFormula = "Sum Of {table.field} >= " & Amt & ""
I wasn't suprised to see that this did not work. Is what I'm trying to do possible?

 

[dgillz]

I am a total VB infant, however I know crystal reports well and it supports both Record and Group Selection formulas. Try using GroupSelectionFormula= and see if that works. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[kab555]

You are right on the nose!! I had to play around with command a bit, because I just didn't think that the Crystal Group Selection Formula syntax would work in VB. It didn't look VBish enough to me. You can simply cut it from Crystal and paste it into VB. It couldn't be easier.

By the way, I think am a VB fetus....

 

[dgillz]

Kab555-

Speaking for me personally, if you want to start using VB with Crystal, I found Ken Hamady's quick reference guide to CR/VB to be a big help. It is very appropriate for us feti (plural of fetus?) who want to know a little about how the 2 products work together, but do not want full-scale VB training.

Good luck Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[kab555]

I bought it yesterday!!