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

How to use a Parameter to suppress but default all records.

Status
Not open for further replies.

dz0k52

Technical User
Jul 21, 2003
32
0
0
CA
I am using Crystal 8.5 with an Oracle 10 database.
I have a report which has three parameters a date range, A location field and Leadcraft selection. The leadcraft selection basically says show me all records that contain that leadcraft.This is a parameter which gets used to supress details other than what is selected.It is important to note that I need this to be a suppression as opposed to a selection feild because the other formulas in the report require all records be selected.
The Parameter feild is called: ?Trade
In the x-2 box of the suppresion function in the details I have:
{WORKORDER.LEADCRAFT} <>({?Trade})
I can select one value or multiple values and it works fine.
How can I have it use disreet value and have the default value be all records (All workorder.leadcraft values)

 
I figured it out. I used:
not ({WORKORDER.LEADCRAFT} like {?Trade})
in the x-2 and defaulted my discreet value to be *.
I should have figured it out in the first place ...sorry.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top