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

Showing Results When Parameter is Blank

Status
Not open for further replies.
newjim

newjim

Programmer
Sep 8, 2001
21
CA
I have a parameter field for "Title" in my report which is used as a record selection field. Sometimes I want to select only those records where the Title field is blank. How do I do this? If I make the parameter '', or 'NULL', it shows nothing.
 
Status
Not open for further replies.

Similar threads

D
  • Locked
  • Question
Stored Procedure with no Parameters
Replies
1
Views
573
hilfy
hilfy
RoknRole
  • Locked
  • Question
Static parameter list of values limitation
Replies
1
Views
384
RoknRole
RoknRole
Niki_S
  • Locked
  • Question
Error when creating parameter fields
Replies
4
Views
414
kray4660
kray4660
PeteyN.O
  • Locked
  • Question
Crystal Report passing a date parameter to a number type field
Replies
3
Views
299
hilfy
hilfy
mohebkasem
  • Locked
  • Question
Using Case in a crystal reports command parameter.
Replies
1
Views
455
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top