Select record based on parameter

[MALICKA]

For my report i have a text box where user key in the quotaion number & based on that parameter i select the report.

Is there any way to select with following option
Case 1 if user enter single number show 1 record
case 2 a~b select all the record of a to b
Case 3 a,c,z selects only 3 record of a,c,z
Iam using cr 8.5 & sql server

How do i pass the parameter for these critera

 

[Naith]

In your record selection formula, you would just set up the following:

{YourRecord} = {YourParameter}

where YourParameter is a multiple value parameter.

Naith

 

[IanWaterman]

Naith's solution will work for case 1 and 3 but not case 2.

For this you will need annother conditional parameter.

eg {?Range}= Yes or No

For case two the user would enter Yes and only two entries for your existing parameter.

In your selection criteria enter the following condition.

If {?Range} = "Yes" then {YourREcord} in [Minimum{?YourParam} to Maximum{?YourParam}] else {YourREcord} = {?YourParam}

Regards

Ian