How to add multiple default values in CRXI

[PNC]

Hi,

I'm using CRXI, and I would like to specify multiple default values for a parameter that allows multiple values, I know it was possible in CR10, but I don't see the option in CRXI.

Thanks.

 

[lbass]

In the parameter creation screen, at the bottom is a section called "Options". In the line where it says "Allow multiple values", change the setting to true.

-LB

 

[PNC]

Thanks for your reply, but what I'm trying to do is to enter multiple values in the default field, so that in the prompt I have this:

Available Selected
1 1
2 2
3
4 4
5

 

[lbass]

What is the problem you are running into? You should be able to either select "Static" and then add the values one by one by clicking and entering each value, or choose "dynamic" and select the field to populate the default options.

-LB

 

[bugzy]

What is the problem you are running into? You should be able to either select "Static" and then add the values one by one by clicking and entering each value, or choose "dynamic" and select the field to populate the default options.

-LB

I have the same problem, and it's not possible in CRXI to define multiple default values... any ideas how to workaround this problem???

Thanks.

 

[Turkbear]

Hi,
Work it from the 'other' direction:
Use the parameters only when non-default values are desired - test for that first, something like this:

If IsNull({?Parameter}) or Trim({?Parameter}) = "" then
{table.field} = [list of default values] else
{table.field} = {?Parameter}

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

 

[bugzy]

If IsNull({?Parameter}) or Trim({?Parameter}) = "" then
{table.field} = [list of default values] else
{table.field} = {?Parameter}

This works well, when I'm using static parameters, but If I use it a dynamic parameter, I don't get any records... weird!?!

If IsNull({?Parameter}) or Trim({?Parameter}) = "" then
{table.field} = [list of default values] else
{table.field} = {?Parameter} AND
{table.field1} = {?Parameter1} // static -- ok
{table.field2} = {?Parameter2} // dynamic -- no records

 

[synapsevampire]

Makes no sense, if you are DEFINITELY passing values in the dynamic list, then it will show them.

I'd guess that you AREN'T pass anything in parameter3

If that's the case, then you'll also have to code for that.

Note that Turk's exampel demonstarted when using ONE parameter and how to check for it, then you come back wioth 3 parameters and you're not checking to verify if the 3rd parameter has any values before passing it.

-k

 

[lbass]

Sorry, I misunderstood. As far as I know, in CR XI you must choose parameter values, therefore there wouldn't be a way to have a null. If you were using static values, you could add a blank value to the parameter selection list, and then set up your record selection formula like:

(if {?parm} <> "" then
{table.field} = {?parm} else
{table.field} in ["A","B","C"]
) and //etc.

For a dynamic list, I thought you could create a command that used a union statement to add another field like "Three Values" to the parameter list, but even though you can use the command for the list, it will not display the hard value in the parameter value list.

Of course, if you ALWAYS want those three values included, you could just change your record selection formula to:

{table.field} in ["A","B","C"] or
{table.field} = {?parm}

-LB