Supress multple values

[angel106]

I want to know how to supress fields based on a customer code in CR9.

I have the report grouped by location were there are 10 locations.

Next i have each name grouped for each location

Example:

Bank 1
Frank 100
Mike 50
Bill 0

Bank 2
Frank 0
Mike 0
Bill 0

Bank 3
Frank 0
Mike 0
Bill 0

Bank 4
Frank
Mike
Bill


Now each name is in each location however i want to supress a name if a quantity sold is met. And show the next name in squence.


Example:

Bank 1
Frank 100 //Frank's quantity is met show Frank in next
step
Mike 50 //Mike step has been entered so show his also
Bill 0

Bank 2
Frank 0// Frank;s quantity is met then i want to show
the next step
Mike 0// Next step after Bank 1 is complete


I tried suprressing names based on condition but this didn;t work does anyone have any suggestion?

 

[lupins46]

You are going to have to provide more detail about what you mean.
Personally, your example doesn't tell me anything.

You say ' i want to supress a name if a quantity sold is met'.
What does this mean? How do you tell from the data if the 'quantity sold is met'

I don't know what is meant by 'And show the next name in squence.'

And I don't know what is meant by 'next step' which is used at various points.

 

[angel106]

Ok want i want to start off with is all Name that have a value in te quantity sold field. My first group is based off locations (Bank 1 Bank 2 Bank 3 Bank 4 .....Bank for being the highest)
I have created a second grouping name which include (Frank Mike Bill)
GH#1 Locations
GH#2 Names

Each location (Bank 1 Bank 2 Bank 3 Bank 4) all the names associated with them. So GH#2 has every name under GH#1 (location).


Bank 1
Frank
Mike
Bill

Bank 2
Frank
Mike
Bill

and so on

Bank 4
Frank
Mike
Bill

All the names are visible under each Bank location.

what i want to do is supress the names if its doesn't have a sold amount (say null or 0) or if the sold amount equals the goal amount for each individual (every goal amount is $100)
Therefore in saying that:

Bank 1
Frank 100
Mike 50
Bill 0 or null

Bank 2
Frank null//No one has enter this step yet however it is the next successful step.

Mike //No one has enter this step yet however it is the next successful step.

//No Bill because bill has either not completed the previous step

Bank 3
//No one should appear in here because Frank has yet to complete Bank 2 and neither mike or Bill has completed Bank 1

Bank 4
//No one should appear in here because Frank has yet to complete Bank 2 and neither mike or Bill has completed Bank 1

 

[lupins46]

OK, I think I ubderstand the question.

A person appears in the group for Bank X if they had a Non-zero value in the previous group (Bank X-1). However if their value in the previous group was zero they should not appear.

Sounds tricky....needs some thought.....

 

[angel106]

Yeah but only the next group not any oter groups....

 

[angel106]

Can anyone feed me any information on how to supress based on if certain conditions are met?