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

Record Selection

Status
Not open for further replies.

danielw

Technical User
Joined
Apr 22, 2003
Messages
9
Location
NZ
I have a report with and operator field. The operator field is a string field with name of the operator in it.
When I refresh data it prompts for operator name or * for all operators. If there is no operator name in the record it doesn't show the record even when I use the *.
How can I get it to show all records even when the operator field is blank. Or show just that operator if I type his name at the prompt. If I remove the operator from record selections & have no prompt for operator it will show all.

Thanks,
Dan
 
Change your receord selection formula:

If {?operator}="*" then true else {?Operator}={Operator} Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com
 
Thanks dgillz worked like a charm.

Dan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top