JUAN ORTIZ Posted November 8, 2021 Share Posted November 8, 2021 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 ®ION.(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 ®ION.(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 Link to comment Share on other sites More sharing options...
VisuaLizeFOCUS . Posted November 9, 2021 Share Posted November 9, 2021 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. Link to comment Share on other sites More sharing options...
Martin Yergeau Posted November 9, 2021 Share Posted November 9, 2021 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:.; Link to comment Share on other sites More sharing options...
Sarah Buccellato Posted November 12, 2021 Share Posted November 12, 2021 Hi Juan, were Rajesh and Martins recommendations helpful, or are you still facing the same issue Link to comment Share on other sites More sharing options...
JUAN ORTIZ Posted November 12, 2021 Author Share Posted November 12, 2021 They were useful, but the issue remains. Maybe it is a limitation on our version of the software Link to comment Share on other sites More sharing options...
Sarah Buccellato Posted November 12, 2021 Share Posted November 12, 2021 Since youre still facing the issue, Id recommend opening a support case. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now