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

Select a Customer

Status
Not open for further replies.

EMax1

MIS
Apr 8, 2004
95
US
I would like to make a report where user could be prompted to select a customer or other specific info he needs.
Is it possible to have a 'window' open where user could enter the ciustomer number for example.
Thanks in advance
 
Go to the field explorer->parameter->new and create a parameter
{?custno}. If the customer number is a number, choose "number" as the datatype, otherwise select "string". If you want the ability to select multiple customers, then set that option to allow multiple values (or in higher versions, set multiple values to true). Then go to report->selection formula->record and enter:

{table.customernumber} = {?custno}

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top