CRXI- select multiple related parameters from 2 lists

[mgason]

Hi,
I have a table with 2 fields from which I need the user to select multiple items.
The 2 fields are Recipe and Revision.

I need the user to select multiple recipes. This is fine.
BUT for each recipe the user needs to select the appropriate Revision as well. This can be different for each recipe (it is a number).

I then get data based on Recipe and revision.
I also group by Recipe and Revision.

Each revision number needs to be somehow tied to the right recipe.

How do I go about setting this up?
The user selection dialogs that is.
Can I do this?

thanks
mark

 

[lbass]

This is a perfect candidate for a dynamic cascading parameter. Create a new parameter->select dynamic and add {table.recipe} as your first parameter field and click on the right hand column "Create parameter". Then add revision as the second parameter on the next line, again checking "create" parameter. For each, be sure to set "allow multiple values" to true. Then go to report->record selection and add the parameters like this:

{table.recipe} = {?parm} and
{table.revision} = {?parm-ext}

I can't remember exactly how the parm names will look--I think one will have an extension on it so you can relate it to the right field.

-LB

 

[mgason]

Hi,
thanks for the guidance. I had been attempting to do a cascading parameter but had not quite been getting it right.

I am on the right track now but there are some issues.

1.
If you select a Recipe in the first parameter box
then add a Revision in the next
Then go back and add a second Recipe in the top box
The first Revision is cleared
This may be how is should work, but it would be more logical for the user to enter one Recipe and its Revision at a time

2.
If you add all the Recipes first.
then when you add a Recipe the appropriate Revisions available appear in the Revision box.
When you add a second Recipe the available Revisions for that recipe are added. As Revisions are A, B, C etc this is odd.
You get something like A,A,B,B,C,C,D,E,F
Obviously pick a few Recipes and this will get really messy.

3.
If I add recipe 1 which has Revisions A and B
Then add Recipe 2 that has Revisions, A,B,C,D
I have a Revision list A,A,B,B,C,D
I select Recipe 1 in the top list right box of already added Recipes.
I can add a Revision of D which I should not be able to do.

thanks for your help
of which there has been much over the last few months
mark

 

[mgason]

While I am working on this I really should explain a bit more that is required.

For each Recipe/Revision combination the user needs to be able to enter a number of pounds of that combination that he wishes to make.

So a third parameter that needs to be typed in by the user not selected from a list, and still associated with the previous selections.

mark

 

[lbass]

How many recipes could be selected? I wonder if it would make more sense to have multiple cascading parameters, with one recipe per prompt, along with the corresponding revisions, and number of pounds.

-LB