Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

limit records based on count?

Status
Not open for further replies.

ericb1

Programmer
Oct 22, 2004
175
US
I'm sure I'm doing something stupid, but can't quite figure it out. In Crystal_10, I have my report all set up:

Main table of claims, and their associated errors. Errors are a many to 1 relationship with claims. I group on claim number, so for each claim, you can see multiple errors listed.

Now, I want to restrict this by only showing claims with 5 or more errors. But every time I try to limit the report based on a count of the errors, I get an error: "this function cannot be used because it must be evaluated later".

Not sure why it won't let me. Where should I be doing this restriction? Any help is appreciated, thanks!
 
On the toolbar go to Report - Selection Formulas - Group.
Put your formula there and it should work.
 
Thanks! I had it in there, but the formula was incorrect. Just had to stop a get a fresh set of eyes on it. Thanks again!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top