How do I filter the data to be shown, so i don't show all records?

[Goodberrie]

I want to be able to filter data, and not show all records of the database, but I want it to be inserted by the user.

Like: What name(s) do you want to look? - Question box or something..

then: user types the data field.
Is it possible?

Thanks in advance.

 

[dgillz]

You need to create a parameter field to prompt the user, than you need to tie your record selection formula in with that parameter.

{Customer}={?Customer}

This is an example of a database field named {Customer} being compared to a Parameter field of the same name. This would restrict items on your report to the customer entered by the user.

You can also make Multi-Value and Range parameter fields. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office