So I have three chained parameters and its working fine. RE...

[JUAN ORTIZ]

So I have three chained parameters and its working fine.

REGION->OFFICE->SALESREP

But now the user requested to have one more parameter: Customer.

But, when I select One Region, One Office and One salesrep, I still get a full list of customers, instead what I need is a list of customers based on the OFFICE. This is my code:

-TYPE Region &REGION.(OR(FIND REGION IN SALES |FORMAT=A255V)).Region:.;

-TYPE Office &OFFICE.(OR(FIND IN SALES |FORMAT=A64V, WITHIN=REGION)).Office:.;

-TYPE Sales Rep &SALES_REP.(OR(FIND SALESREP IN SALES |FORMAT=A41V, WITHIN=OFFICE)).Sales Rep:.;

And this is what I tried to do:

-TYPE Region &REGION.(OR(FIND REGION IN SALES |FORMAT=A255V)).Region:.;

-TYPE Office &OFFICE.(OR(FIND IN SALES |FORMAT=A64V, WITHIN=REGION)).Office:.;

-TYPE Sales Rep &SALES_REP.(OR(FIND SALESREP IN SALES |FORMAT=A41V, WITHIN=OFFICE)).Sales Rep:.;

-TYPE Customer &CUSTOMER.(OR(FIND CUSTOMER IN SALES |FORMAT=A41V, WITHIN=OFFICE)).Customer:.;

I can see all customer belonging to the Office I chose, But now the saleReps are shown OUTSIDE the chained parameter window

And, can this even be done at the report level

[VisuaLizeFOCUS .]

Hi Juan,

The implementation can differ and will depend where you will have this report.

If this report can be inside HTML and there you have a run button to run this report then yes you can do something at report level but with Designer need to check.

[Martin Yergeau]

juan.ortiz:

 

-TYPE Customer &CUSTOMER.(OR(FIND CUSTOMER IN SALES |FORMAT=A41V, WITHIN=OFFICE)).Customer:.;

 

 

Above should not instead be

-TYPE Customer &CUSTOMER.(OR(FIND CUSTOMER IN SALES |FORMAT=A41V, WITHIN=SALES_REP)).Customer:.;

[Sarah Buccellato]

Hi Juan, were Rajesh and Martins recommendations helpful, or are you still facing the same issue

[JUAN ORTIZ]

They were useful, but the issue remains. Maybe it is a limitation on our version of the software

[Sarah Buccellato]

Since youre still facing the issue, Id recommend opening a support case.