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!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select ALL or one or many

Status
Not open for further replies.
mart10

mart10

MIS
Nov 2, 2007
394
GB
I am using Crystal 10.


I have a parameter where I enter rather than pick a company code to drive a letter

I would like the option to select ALL or multiple codes. How can i do this please
 
Sort by date Sort by votes
If you searched this forum there are lots of posts on this subject.

Add the word All as default to your parameter

in select

(If {?param} <> 'All' then {field} = {?param} else true)

Ian
 
Upvote 0 Downvote
I did a search on ALL and Parameters and found just 2 posts,

will try your suggestion
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mmck1964
  • Locked
  • Question
Using "OR" to select data
Replies
4
Views
437
mmck1964
mmck1964
john432
  • Locked
  • Question
Select Expert
Replies
2
Views
201
john432
john432
Cpreston
  • Locked
  • Question
Only Select certain rows 1
Replies
7
Views
422
Cpreston
Cpreston
Cpreston
  • Locked
  • Question
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
294
Cpreston
Cpreston
inkbird01
  • Locked
  • Question
Filters &gt; Record Selection for dates between
Replies
4
Views
323
pmax9999
pmax9999

Part and Inventory Search

Sponsor

Back
Top