Supress Dynamic cascading prompt 1

[gofrenzy]

Hi,

I am trying to build a report which has 2 dynamic cascading parameters and 2 normal parameters.
Two of the Normal parameters 'Business' and 'Division' prompts should be prompted as usual.But it is not the same with my cascading prompts.

I have say a dynamic cascading prompt MOU_Val and MOU_Region and another dynamic cascading prompt of Region and Center.

My requirement is when I select MOU_Val as "MOU" then it should prompt for MOU_Region and automatically force Region and Centre prompts to take "ALL" of there values or supress them from showing its feilds for selection.

Similarly when i select MOU_Val as "Non MOU" then it should prompt for Region and center prompts and automatically take "ALL" of MOU_Region values or supress it from showing its feilds for selection.

I tried by writing an If then else expression in select expert but mine did not work. And all these prompt values already have "-ALL-" value in its list of values which is done at the database level itself.

Any help is appreciated.

Thanks,
Sai

 

[gofrenzy]

Can someone please advice on my above issue.

Thanks,
Sai

 

[lbass]

You cannot suppress prompts, but they can be ignored in the record selection formula. Try a record selection
formula like:

(
(
{?MOU Val} = "MOU" and
(
if {?MOU Region} <> "-All-" then
{table.MOU_region} = {?MOU Region} else
if {?Mou Region} = "-All-" then
true
)
) or
(
{?MOU Val} = "Non MOU" and
(
if {?Region} <> "-All-" then
{table.region} = {?Region} else
if {?Region} = "-All-" then
true
) and
(
if {?Centre} <> "-All-" then
{table.centre} = {?Centre} else
if {?Centre} = "-All-" then
true
)
)
)

-LB

 

[gofrenzy]

Thanks alot lbass. I shall try that and let you know.

 

[gofrenzy]

lbass,

I tried with the above logic. When i selected MOU_Val as 'MOU' at the top it was still asking me for Region and Center.Similarly when i entered Non MOU it prompted for MOU_Region.

No matter what I select, it always prompted for all prompts with all list of values. Is it anything to do with these prompts being dynamic cascading prompts? Please advice.

Thanks.

 

[lbass]

As I said earlier, there is no way to eliminate the prompts, but the report will work correctly despite the prompts. You can instruct the users in the prompt text, like this for {?Region}:

"If {?Mou Val} above equals "MOU," then select "-All-"; otherwise select a region from the dropdown list."

It doesn't really matter if they do this, but the prompts would then appear more logical.

-LB

 

[gofrenzy]

lbass

Its working perfect except for the MOU_Val data field which is being retrieved on the report. If I select either MOU/NON MOU in the prompt, final report is retrieving all list of values for MOU_VAL (MOU & NON MOU& ALL.)instead of just a single MOU_Val

But if I select MOU_VAL prompt as 'MOU' and MOU_Region as 'East' whatever I may later on enter for Region or Center prompt the final report is pulling for all List of values for Regions and Centers.

Similarly if I select MOU_VAL prompt as 'Non MOU' then it is automatically taking all list of values of MCU Region( East, west, All) in the final report.This is how it should work but MOU_VAL is retrieving all list of values,even if MOU_val selected is either MOU or Non MOU.

 

[gofrenzy]

lbass, thanks for the help.I am very close to the requirement. I am working around to get the MOU_Val working.

 

[gofrenzy]

lbass,

MOU_VAL issue stated above is solved if I added {TBL.MOU_Val} = {?MOU} inside the code

like below,
(
{?MOU_Val} = "MOU" and
(
if {?MOU_Region} <> "- ALL -" then
{TBL.MOU_REGION} = {?MOU_Region} and
{TBL.MOU_Val} = {?MOU} else
if {?MOU_Region} = "- ALL -" ...............ETC

Thanks again for your help.

 

[lbass]

I didn't realize there was an {?MOU} parameter. Glad you got it working.

-LB