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

Parameters Question

Status
Not open for further replies.

slickp007

MIS
Feb 18, 2008
46
GB
Crystal XI

Hi, this is gonna sound like a simple question but i've been racking my brains all morning. I have an insurer report which reports on all insurers. What i'd like a parameter to do is allow the user to select either all insurers or allow them to select mulitple insurers given them the option to input they required insurer number. How can i do this?
 
If the parameter is set up as a number, then add an option of 0 to the picklist (with a description of "All"), and then create a record selection formula like:

(
(
{?parm} <> 0 and
{table.number} = {?parm}
) or
{?parm} = 0
)

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top