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

Enabling Select ALL in a parameter prompt in eportfolio lite

Status
Not open for further replies.

dgr01

IS-IT--Management
Apr 9, 2003
17
US
Im using CR9.0 Advanced Edition RAS, using reportListing.asp and pageViewr.asp.
I have two parameters in one of my reports asking for a location and insurance plan in a report, both parameters have several default values the users can select. Is it possible to give the users a button to select all or maybe if they leave the field blank it will default to all values? the current sql formula is below:

{EligibilityRequests.DeptLocation} = {?Location} and
{EligibilityRequests.InsurancePlan} = {?Insurance Plan}

Thanks, Dgr
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top