Number of Orders Raised within a 3 Month Period

[Fixles]

Hello,

I am trying to create a report in Crystal Report 7.0 Pro. The report shows a list of order numbers the date they were raised and are grouped by a work type filed.

Group Header [WORK TYPE]
Details [ORDER NUMBER] [DATE]
Group Footer

I run the report and it works fine. What i now need to do is identify any [WORK TYPES] have had 3 or more [ORDER NUMBER]'s raised in a 3 month period.

I have tried the following formula in the evaluation of a Running total field but it just counts everything.

Previous [DATE] > [DATE] - 3

Any help would be much appreciated.

Cheers James

 

[synapsevampire]

What does raising an order mean? I've been in MRP and Order Processing for over 20 years and never heard the term.

And how are these 3 month periods defined? Do you mean quarters?

Try adding another group under work_type based on the DATE (I assume that this is the "raised order" date), and select that they will be grouped for each quarter.

Now you can just right click any field in the details and select Insert->Summary->Count for the date group level to get counts.

You might also do something similar within a crosstab if you prefer that sort of layout.

-k

 

[Fixles]

By order raised i mean someone has inserted a new order into the database.

The 3 month period is not fixed. I need to see if 3 calls have been raised within 3 months of each other for a single work type.

Hope ive explained it a bit better.

Cheers James