I hav a prob like this
Itemcasc and Itemcascaddition a are 2 sub reports
Itemcasc formula contains like this,
DIM str AS STRING
IF {ItemCASCProduct.CASCProductCode} <> "" THEN
str = str + "CASC Product Code : " + {ItemCASCProduct.CASCProductCode} + CHR(13)
END IF
Itemcascaddition formula contains like this,
DIM str AS STRING
IF {ItemCASCAddition.CASCCodeOne} <> "" THEN
str = str + "CASC Code One : " + {ItemCASCAddition.CASCCodeOne} + CHR (13)
END IF
IF {ItemCASCAddition.CASCCodeTwo} <> "" THEN
str = str + "CASC Code Two : " + {ItemCASCAddition.CASCCodeTwo} + CHR (13)
END IF
IF {ItemCASCAddition.CASCCodeThree} <> "" THEN
str = str + "CASC Code Three : " + {ItemCASCAddition.CASCCodeThree} + CHR (13)
END IF
FORMULA = str
i ll show my xml data.
cbc:ItemCASCProduct>
<cbc:CASCProductCode>VBA0BC</cbc:CASCProductCode>
<cbc:ItemNumber>01</cbc:ItemNumber>
<cbc:SequenceNumber>01</cbc:SequenceNumber>
</cbc:ItemCASCProduct>
- <cbc:ItemCASCAddition>
<cbc:CASCCodeOne>CODE1A</cbc:CASCCodeOne>
<cbc:CASCCodeTwo>CODE1A</cbc:CASCCodeTwo>
<cbc:CASCCodeThree>CODE1A</cbc:CASCCodeThree>
<cbc:ItemNumber>01</cbc:ItemNumber>
<cbc:SequenceNumber>01</cbc:SequenceNumber>
<cbc:AdditionalSequenceNumber>01</cbc:AdditionalSequenceNumber>
</cbc:ItemCASCAddition>
- <cbc:ItemCASCAddition>
<cbc:CASCCodeOne>CODE1B</cbc:CASCCodeOne>
<cbc:CASCCodeTwo>CODE1B</cbc:CASCCodeTwo>
<cbc:CASCCodeThree>CODE1B</cbc:CASCCodeThree>
<cbc:ItemNumber>01</cbc:ItemNumber>
<cbc:SequenceNumber>01</cbc:SequenceNumber>
<cbc:AdditionalSequenceNumber>02</cbc:AdditionalSequenceNumber>
</cbc:ItemCASCAddition>
- <cbc:ItemCASCProduct>
<cbc:CASCProductCode>VBAVBA</cbc:CASCProductCode>
<cbc:ItemNumber>01</cbc:ItemNumber>
<cbc:SequenceNumber>02</cbc:SequenceNumber>
</cbc:ItemCASCProduct>
- <cbc:ItemCASCAddition>
<cbc:CASCCodeOne>CODE1BA</cbc:CASCCodeOne>
<cbc:CASCCodeTwo>CODE1BA</cbc:CASCCodeTwo>
<cbc:CASCCodeThree>CODE1BA</cbc:CASCCodeThree>
<cbc:ItemNumber>01</cbc:ItemNumber>
<cbc:SequenceNumber>02</cbc:SequenceNumber>
<cbc:AdditionalSequenceNumber>01</cbc:AdditionalSequenceNumber>
</cbc:ItemCASCAddition>
- <cbc:ItemCASCAddition>
<cbc:CASCCodeOne>CODE1BB</cbc:CASCCodeOne>
<cbc:CASCCodeTwo>CODE1BB</cbc:CASCCodeTwo>
<cbc:CASCCodeThree>CODE1BB</cbc:CASCCodeThree>
<cbc:ItemNumber>01</cbc:ItemNumber>
<cbc:SequenceNumber>02</cbc:SequenceNumber>
<cbc:AdditionalSequenceNumber>02</cbc:AdditionalSequenceNumber>
</cbc:ItemCASCAddition>
i write inside section report inside Itemcascaddition suppress(no drill) x-2 like this
{ItemCASCAddition.SequenceNumber}=previous ({ItemCASCAddition.SequenceNumber})
but my output shows like this
CASC Product Code:VBAOBC
CASC Code One :CODE1A
CASC Code two :CODE1A
CASC Code three :CODE1A
CASC Code One :CODE1BA
CASC Code two :CODE1BA
CASC Code three :CODE1BA
CASC Product Code:VBAVBA
CASC Code One :CODE1A
CASC Code two :CODE1A
CASC Code three :CODE1A
CASC Code One :code1BA
CASC Code two :code1BA
CASC Code three :code1BA
BUT IT SHOLULD SHOW LIKE THIS
CASC Product Code:VBAOBC
CASC Code One :CODE1A
CASC Code two :CODE1A
CASC Code three :CODE1A
CASC Code One :CODE1B
CASC Code two :CODE1B
CASC Code three :CODE1B
CASC Product Code:VBAVBA
CASC Code One :CODE1BA
CASC Code two :CODE1BA
CASC Code three :CODE1BA
CASC Code One :CODE1BB
CASC Code two :CODE1BB
CASC Code three :CODE1BB
I KNOW ITZ COZ OF {ItemCASCAddition.SequenceNumber}=previous ({ItemCASCAddition.SequenceNumber}) FORMULA PROB INSIDE Itemcascaddition X-2
Cn u help me 2 rewrite err free formula?
thanx in advance
remo
