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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Newbie Question

Status
Not open for further replies.

Johnkylex

Technical User
Dec 19, 2001
17
US
I am new to crystals and need some simple help. I have database I only want to pull certain records from according to a field equalling a certain criteria. EX: I want all data from the database where the group field equals H.

Thanks,
John
 
Click on Report, Edit Selection formula, Group, and in the group selection formula, enter the logic that you mentioned.

The record selection formula works much the same way. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office
 
Thanks....so would the formula be

Count ({TEST.GROUP}) = "H"

 
In the group selection formula:
Left({Groupname},1)="H"

count() would return an integer

Or, if the database field value you are looking for is "H", then in the record selection formula, {Fieldname}="H" Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top