Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

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


JUAN ORTIZ

Recommended Posts

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

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...