Recent content by Csukardi151

LB, Thanks for your help and feedback.

Database is Pervasive 9.5 All tables used are the same: V_Order_Hist_Line V_Order_Hist_Line.Order_No V_Order_Hist_Line.Part V_Order_Hist_Line.Date_Shipped V_Order_Hist_Line.Order_Due @Late: if {V_ORDER_HIST_LINE.DATE_SHIPPED} <= {V_ORDER_HIST_LINE.DATE_ORDER_DUE} then 100 else 0

Ok my first grouping is {table.OrderNumber}. I also have the Average of @Late (See Below) in this Header. Now the order number can have multiple ship dates so I identify shipdate per part. In Details: {table.OrderNumber} {table.Part} {table.ShipDate} {table.DueDate} {@Late} This is my...

Thanks for the reply LB. The problem I see with a sort of the Average is that their will be multiple fields (ex. 100%, 88.5%, 50%... etc) I would like to aim for a group header, if possible, to just group by 2 categories. On-Time (100%) and Late (99% to 0%). ~Steve

Hello, I created a report that gives a shipping analysis of either On-Time or Late. Sometimes a single order will contain both "On-Time" parts and "Late" parts with multiple shipments. So I created a formula that says, if the part is late then mark the line as 0, if it is not late, mark it as...

THAT WAS IT! Thank you Thank you Thank you!! Looking at it now, it was just a simple formula.

Got the chance to try our your formula LB. "Current Range" shows up without problems. However, Previous Year Range does not show up at all. I'll try playing around with it and see if I can get it to show. Thanks, ~Steve

Sounds good, I will try this! I prob won't get around to this until Monday. But I will keep you posted. Thanks for the feedback everyone. ~Steve

I have start date and end date parameters. I enter the dates I want the data to be in. So I made the report (up to this point) where I can get results for the dates I enter. I know I can make formula's that can grab the dates of the same info of the same dates I choose minus a year by using...

Thanks for the replies, I do understand what Madawc is suggesting, however I am unsure how to properly do this. ~Steve

I'm sorry to be confused, I must not be as knowledged in the full potential of grouping. Crystal won't let me enter another group [Target.Name] I am assuming I am not changing a setting or perhaps I need to add a formula to this?

Thanks for the reply. Is it possible to make another group based on the same field? My GH2 is currently "Group Header #2: Target.Name". I've tried adding a second group header to GH2 but that splits the records. Instead of getting: GH2 CENTRAL EAST GF2 GH2 M1 CENT EAST I would...

Also.. Did I post this in the wrong forum?

If my question seems to be pretty hard to answer, I can do this another way. I just wanted to see if this way is actually possible. Information: I want to compare sales by date horizontally. What I have: (I have GF2 small so I don't get the spaces in the report) GH1 CENTRAL EAST...

Thanks for the help, LB.