Crystal Reports XI Parameter Fields - Selecting Either Or

[PWD]

I have two Parameter Fields:-

{?Lookup type ref} & {?Lookup Code}

and this in the Selection Formulas; Record Selection:-

{LOOKUP.LOOKUP_TYPE_REF} = {?Lookup type ref} or  {LOOKUP.LOOKUP_CODE} = {?Lookup Code}

so that there is a choice of variables. This works OK if they choose from each variable. BUT if the user only wants to choose one of the variables it will only work if they choose something from the {?Lookup type ref}. If they attempt to not select from that field then the report just stalls on the ‘Enter Values’ window.

The {?Lookup type ref} is a ‘Number’ – it has to be – and the {?Lookup Code} is a String. I’ve tried reversing the order in the Record Selection.

Any ideas would be gratefully received.

Des.

 

[Turkbear]

Hi,
Depending on the CR version ( info that is good to specify when posting), a numeric parameter value must be supplied.
2 ways to handle it:

1:Create a default value for {?Lookup type ref} using a number never found in the data, like 0 or 999999.

2: Use a string and convert it in your formula:

{LOOKUP.LOOKUP_TYPE_REF} = {?Lookup type ref} or {LOOKUP.LOOKUP_CODE} = ToNumber({?Lookup Code})[COLOR=red] //could be an problem if no value is supplied, so a default value may still be needed as with the number type[/color]

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

I would suggest adding prompt instructions like this:

If you wish to select based on type reference, select a type; otherwise select 0.

If you wish to select based on code, select a code; otherwise, select "None".

Then in your record selection formula use:

(
(
{?Lookup type ref} <> 0 and
{LOOKUP.LOOKUP_TYPE_REF} = {?Lookup type ref}
) or
(
{?Lookup Code} <> "None" and
{LOOKUP.LOOKUP_CODE} = {?Lookup Code}
)
)

-LB

 

[PWD]

Thanks chaps. It seems just using a value outside the given range for each type appears to work - without having to put in the extra check in the record selection formula. Nice. I've added the extra user instruction to the prompt, so let's see how it goes.

Thanks again,

Des.