Capturing earliest date on report

I am working on an existing report, I did not create.  I am trying to capture certain dates within the database and am not being successful.  I have attached a word document with the formulas I am using a Calc/Display/Reset based on a unique employee # grouping, reporting fields are in the group footer.  What I am trying to capture is the first criteria of the Calc formula then followed by the other options.  I have tried to use the formula on the reset and it did not update as desired.  Can you assist?  If you need a simple report, let me know and I can create one.
Capturing-the-earliest-date.docx
GrapeladyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Your document doesn't specify the section location for each formula but, assuming they were placed logically, your next step should be to create a formula that simply displays the value of the date variable.
Place that formula in GH1, GF1, and in the detail section (unsuppress the section if needed).

Then, you should be able to visually follow what is happening to the value of the variable.  This should immediately provide clues as to where the problem is.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
James0628Commented:
As Ido said, you didn't specifically say where those formulas are located in the report, and where they're placed will determine the results that you get.  If the phrase "All information is on the Group Footer" in your document is saying that all of those formulas are in the group footer, that's definitely not going to work.

 FWIW, you might want to create a formula like the following and put it in the report header, to "initialize" the variable.  That seems to sometimes help with global variables like that, and it won't do any harm:

WhilePrintingRecords;
DateVar Temp_RegDate;
""

 The "" at the end is just so the formula doesn't produce any visible output on the report.  You could also suppress that formula, or suppress the section that it's in.

 James
GrapeladyAuthor Commented:
Thank you for your suggestions, I believe I have found the solution and your suggestions assisted me in finding it.  Sorry it took so long for me to give an answer.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.