Search results for query: *

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.

Thanks LB, Basically in GH2 I have 2 numbers listed as the sales target for the end of the year. Which are in regions. Example, region1 target is $300,000 and region2 target is $400,000. In GH1 I want the sum of both regions so it kinda looks like: $700,000 -$400,000 -$300,000 What I'm...

So I'm setting up a report that has a GH1 and GH2. GH2 hosts the actual WhilePrintingRecords counter and GH1 has the WhilePrintingRecords display. As you are probably guessing, this results in my first WhilePrintingRecords display to be a "0". While the counting is correct. It is starting in...

Simply amazing, works flawlessly. Thanks again LB!

Thank you very much for the reply! That is really close to what i'm looking for! I guess I did leave out a tiny bit of detail which was my fault. The count is working great as it adds up the amount per each one that is 2 or above, however, the companies are listed in group footer 2 and the...

Hello all, I'm gonna try my best to explain my situation. I have a report that lists companies and the number of orders they have had (within a certain date). The number of orders are listed as a distinct count. Let me show an example then explain what I am trying to accomplish. ---------...