CR9 Conditional Formula 1

[trafficstudent]

I have a conditional format to display a group header if a certain quality is below safety stock:
Sum ({InventoryLots.Quantity}, {POHeader.PONumber})>={PartMaster.SafetyStock}

my second group header i have it supress any purchase order that is closed:
{PODetail.ClosedFlag} or
{POHeader.ClosedFlag} or




hat i need help with is some of my second group header are showing and my first group headers aren;t showing, it confusing my users that they have an open purchase order under what looks like a wrong part, however this is displaying this way because, if my partnumber is greater than the safety stock then it will supress however sometimes order are ordered where we get ahead of ourselves and we may place a purchase order for some part numbers that aren't under safety stock and therefore it wont display correctly.

how can i still have my first group header display if the quantity is under the safety stock and there has been a Purchase irder active????

 

[synapsevampire]

Place a formula in the group header of:

whileprintingrecords;
booleanvar SumOver;
if Sum ({InventoryLots.Quantity}, {POHeader.PONumber})>={PartMaster.SafetyStock} then
SumOver := true

Then in your inner group formula add:

whileprintingrecords;
booleanvar SumOver;
Sumover or
{PODetail.ClosedFlag} or
{POHeader.ClosedFlag} or

Then in the group footer place:

whileprintingrecords;
booleanvar SumOver:= false;

-k

 

[trafficstudent]

Thanks for the feedback, however i tried to the above equation and it didn't change anything. I may need to explain it better because i might have confused everyone.

I have created a report in CR 9.0 that has 2 groups 1-Group is based off the {PODetail.PartNumber} and the group is based off the {PoHeader.PONumber} what i want to display is this:

Based on this equation:{@Inventory}>={PartMaster.SafetyStock}

i want to display PartNumber on the report if this equation is matched (I have the above equation in the Group Header Supress section)

I also want to display PartNumber if they have it has a filed correcponding to "Blanket" my logic is this

{@Inventory}>={PartMaster.SafetyStock} or {PODetail.UserDefined1}="Blanket"


I hope this helps.....

 

[trafficstudent]

Can anyone help me out on this issue?

I trying to paint a clear picture on what exactly im trying to do.

I want to display the partnumber based off whether a Purchase Order Number is created for the part.

My example is this:

Group Header 1: Part Number
Group Header 2: Purchase Order Number


What I would like to do is based on, if a pruchase Order is created for the Part Nubmer then display Group Header 1. If no purchase Order is displayed for the part number then supress Group Header 1.


Plese help this is urgent

 

[lbass]

Try using a suppression formula for group header#1:

isnull({table.po#})

-LB

 

[trafficstudent]

LB- I added the above formula however when i added it to the exsisting formula with an or it didn't change anything.
my formula is as follows in the Group 1 suppress section:

(@inventory)>(SafetyStock)or isnull(PODetails)


Can i even supress a section based whether or not a PartNumber has a lsited PO?

 

[lbass]

Yes, you should be able to do that. In file->report options, have you checked "convert nulls to default values"? What is the datatype of PODetails? Can it be null? Or does it always have some value, e.g., 0 or ""?

-LB

 

[trafficstudent]

LB - The PODetails is a string datatype, in saying that you could have PartNumber with no purchase order....Does that make any sense?...If not let me know.

 

[lbass]

Try:

isnull(PODetails) or
trim(maximum(PODetails,{table.group1field})) = "" or
@inventory)>(SafetyStock)

Please try to answer all questions in the future.

-LB