Report created before my time Help please :) 1

[luv2bike2nv]

Ok I have worked on minor Crystal Reports (version 8.5 -- i know it is an out of date version but well i won't go into that) modifications and need some help on this one. Hopefully some one can help me out.

The report has the following information:
Details Line:
Part Number
Order Date
Transaction Date
Total Days (@DaysSum)

Group Header:
Average Through-Put Days (@DisplayAverdays)

@DaysSum formula is as follows:
{Transaction_History.TNXDTE_15} - {Job_Progress.MOVDTE_14}
Which I understand.—this will give me the number of days
ie TNXDTE_15 == 1/15/2009
MOVDTE_14 == 1/29/2009
Which the number for Total Days will equal 14.

What this user wants to accomplish is:
Not to include the weekends (and holidays) in the total. So that the Total Days would = 10

How can I edit the formula to not include the weekend and holidays that might be included in the total days?
To throw a wrench in this:
Say the TNXDTE_15 is 6/12/09 (Friday)
and the MOVDTE_14 is 6/16/09 (Tuesday)

That is 5 days however there is a weekend there so the total number of working days is 3 (Friday, Monday and Tuesday).
How can I edit the formula to recognize the fact that the 13th and 14th is the weekend?

Our MRP system has a Calendar that is set up so that we can block out our holidays and weekends. i am looking into finding out what table it is so it might help out as well in figuring out what fields to put in the formula(s).

Any Help on this would be GREATLY appreciated and if more information is needed to help me out here, I will be happy to provide it.
Thanks in Advance!

Robin

 

[lbass]

Please see Ken Hamady's solution:

http://www.kenhamady.com/form01.shtml

-LB

 

[luv2bike2nv]

Thank you lbass. I will give this a try. it looks like it will work for me. I might have a couple of questions when i do try it, since i am still fairly new to doing Crystal Reports.

Thanks again

 

[luv2bike2nv]

Thank you for your help! I think I have the weekend and holidays working!

Now I have another question.
What I need to do now is get the Average Through-Put Days from the total number of days. There are (for this particular part number) 133 entries and I need to get the average through put days. the formula that is in the Group Footer is as followed: (the named of the formula is: @Display AverDays):

WhilePrintingRecords;
numbervar averdays;
averdays


I have no idea where "averdays" are, i looked in the formulas, functions, report fields, operations etc sections and I do not see averdays any where, there is no @ or # or any other symbol in front of averdays for me to think that is was something the creator of the report created.

How would I go about getting the average total number of days?

any help would is greatly appreciated!
Thanks,
Robin

 

[lbass]

Averdays" is the name the previous developer used to name a number variable. This is the final formula of a set of two or three formulas, which could be named anything. You need to open the formulas and look for "averdays"--one of them will assign a value to it, and another might reset it to 0.

-LB