CRXI-Dynamic Parameter not required, possible?

[marcela79]

Hi,

I have a report that has 4 parameters, one of them is a Dynamic type of prompt. The other three are static and I have a default value of 'ALL' making them "optional". I want to do the same for the dynamic prompt. If a user enters a value in any of the other prompts, I don't want the user to have to select something in the dynamic prompt, is this possible? If so, how?

Thank you!

 

[lbass]

You could create a command like this:

select table.`field`
from table

union

select 'All'
from table

Then write a record selection formula like this:

(
{?parm} = 'All' or
{table.field} = {?parm}
)

-LB

 

[marcela79]

I'm sorry but this is my first time creating commands, Where do I create the command?

Thank you!

 

[marcela79]

I forgot to mention that the dynamic prompt I'm trying to create is a cascading one... Does this make any difference in your suggestion?

 

[lbass]

Yes, it does matter. The command doesn't really work for a cascading prompt.

-LB