Cascading prompts in the select expert

[hanchilicious]

Hi,

I'm using CRXI, and I have a dynamic parameter set up like this:

1) Country
2) Company

The parameter assumes the latter field name and incorporates this into the parameter name. (e.g. {?myparameter - company})

How do I use this parameter in the selection criteria? If I go:

{?myparameter - company} = {company} then, I get the right company name, but for all the countries it's in.

If I add "and {?myparameter - company} = {country}" then nothing gets returned.

What is the proper syntax for referring each field to a cascading prompt in the selection criteria?

thanks.

 

[hanchilicious]

Sorry to bump this, but I guess it kind of got missed in all the other stuff. Someone must have already done this before.

Be very appreciative if you could share, thanks.

 

[lbass]

If you are setting up a cascading parameter {?location}, you would first check "dynamic" and then insert the country field and click the right hand column, which creates the parameter {?location-country}. Then in the same screen, select the company field and click on the right hand column to create {?location-company}. Then in the record selection formula you would use:

{table.country} = {?location-country} and
{table.company} = {?location-company}

-LB