Collapse Table

[#1]

Hi Experts,

I have a table with Sales Order Positions, and i have a flag if the position is in Delay or not.

Order     Pos     Delay

991          10     1

991          20     0

991          30     0

888          10     0

888          20     0

888          30     0

I should have a chart with the Sales Order without Position, and,if at least one position is 1, all Order is 1.

if all order is 0 the Order Record is 0.

Order     Delay

991          1

888          0

Can you help me ?

[#2]

The solution is near.

every Order Can has several position in Delay.

Order     Pos     Delay

991          10     1

991          20     1

991          30     0

888          10     0

888          20     0

888          30     0

666          10     1

666          20     1

666          30     1   

But in my chart I want only e chart that gives me only a flag. For examble

Order     Delay

991          1

888          0

666          0

[#3]

Errata Corrige

But in my chart I want only e chart that gives me only a flag. For examble

Order     Delay

991          1

888          0

666          1

[whiteline]

Order     Pos     Delay

991          10     1

991          20     1

991          30     0

888          10     0

888          20     0

888          30     0

666          10     1

666          20     1

666          30     1

Hi.

Don't understand how have you got 1 for 991 'cause there are both 0 and 1.

You could create collapsed table in script with group by statement (look at help).

You could also just create a 'table box' with two fields  Order and Delay.