Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Minimum and counting Business days 1

Status
Not open for further replies.

kcsilentbob

Technical User
Dec 14, 2005
42
US
Good morning everyone!

I am needing some help. I created a report that returns several date entries for a given policy number. I am needing to install the business days/holiday table that I have seen posted on here. The problem that I am having is that I need to start counting business days from the minimum date on the policy number to the current date. However when I put minimum on the business days formula i get an error saying that the minimum function needs to take place later.

Is this possible using the business days formula?

I am using Crystal XI.

Thanks
silentbob
 
If you are using the formula from my site you can change the first line from "WhileReadingRecords" to "WhilePrintingRecords" which should allow you to use summary functions.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides for Formulas, Parameters, Subreports, VB, .NET, Tips and Tricks
 
I am using your formula.

Would I need to change the holiday table to before printing records as well?
 
Wouldn't hurt, but that one probably doesn't matter. As long as it is in the report header it should work either way.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides for Formulas, Parameters, Subreports, VB, .NET, Tips and Tricks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top