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

How to make parameter optional? - Urgent please

Status
Not open for further replies.

bandarna

Programmer
Jan 2, 2003
122
US
Hi,
I have 5 parameters (all are allow range).
Right now report is running fine, but I pass all 5 parameter values.( All parameters are mandatory)
How can I make them make them optional?


See the code below:
{coa_elem_desc.element_id} = {?P_Element_1} or
{coa_elem_desc_1.element_id} = {?P_Element_2} or
{coa_elem_desc_2.element_id} = {?P_Element_3} or
{coa_elem_desc_3.element_id} = {?P_Element_4}

Example: I can enter P_Element_1 values as 1100 to 1103
and P_Element_2 values as 2100 to 2200
and P_Element_3 Values as null to null
and P_Element_4 values as null to null

Report should run for a given parameters. can anyone help me?

Thanks
nb
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top