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!

Record Selection

Status
Not open for further replies.

danielw

Technical User
Apr 22, 2003
9
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