how to get the quantity order in OE entry if the order type is ACTIVE

[CRdesigner]

Hi guys,

I'm using CRXI and i'm getting tables from accpac module OE(OE ENTRY).

my problem is i want to include the quantity ordered in the report if order type is "ACTIVE" but the only thing that crystal report shows is the order type "QUOTE"

scenario:
reference = parameter

balance ref:index1
item quantity(active) quantity(quote)
abcd = oeordd.qtyordered oeordd.qtyordered
(if {oeordh.type} = 1 then (if ref = {@index1}
oeordd.qtyordered) and{oeordh.type}=4 then
oeordd.qtyordered)

the result is :

item balance ref: january
abcd 0.00 100


i don't know why crystal report can't show the quantity ordered if the oeordh.type(order type) is equal to 1 or ACTIVE. it only shows the quantity ordered if the order type is QUOTE OR EQUAL TO 4

guys please help me on this.

any advice, suggestions or comments would be very much appreciated.

thank you

 

[lbass]

The formula results would appear in different rows. If your display is in a group section, you would only see one of the two values. Instead, place your conditional formulas in the detail section and insert a sum on them at the group level. Then suppress the detail section.

Note that you are in the wrong forum. This forum is for Business Objects Enterprise, an application for distributing reports. Try forum149 or forum767 for questions like this in the future.

-LB

 

[CRdesigner]

thanks for the reply, i appreciate it

i did add 3 groups namely

gh1: icitem.category(suppress)
gh2: oeordd.item(supress)
details: oeordd.desc recqty quantity for active, for quote


actually i already figure it out why the quantity for order type " active" shows zero values because the order type: quote and active can't be included in the main report at the same time so i created a subreport and it went well. now i'm working on it right now, i'm trying to finish the report within today.

i really appreciate the reply thanks.

offtopic:

i can't reply immediately 'cause our timezone here is GMT+8 harhar ^__^

and one more thing, am i in the forums section? hahaha what's the difference between the enterprise business object: application for distributing of reports in crystal report 4 and other topics?

many thanks and regards!