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

Selection based a few parameters

Status
Not open for further replies.

thebobman

Programmer
Sep 25, 2000
12
US
I have a report that has about 5 parameters that the user can use. How do I write a query based on a few parameters?

I want to ignore the parameters that are NULL
 
Please include technical information, such as the version of Crystal, it's extremely important as the functionality differes greatly during the past 2 years.

In general you don't write queries using parameters, you write the Record Selection Formula to allow for filtering on the database.

An example might be (report->Edit Selection Formula->Record):

(
{table.date} > {?MyDateParm}
)
and
(
{table.Someid} = {?MyIDParm}
)
etc.

Hopefully this is what you are intending, if not, please include technical information in your posts, such as Crystal and database version.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top