Grouping Dates 1

[TaylorTot]

Hello,

Crystal 8.5
Access DB

I might be trying to create something that isn't possible but here is my intent:

Report Setup:

GH1a - Trade Name (Collection letter over 90 days past due)
GH1b - Trade Name (Collection leter 30-89 days past due)
GH2 - Date Signed
Details a - Date signed, Contract Numer, Publication
Details b - Date Signed, Contract Number, Pub (for overdue balances)
GF2
GF1

In my collection letter it indicates when the contract was signed (date signed), how old it is (maximum(days old) and Balance due.

I have created 3 formulas for date signed:

GH1 - reset
whileprintingrecords;
shared DateVar datesigned := Date(0,0,0);

Details a - Date Signed
whileprintingrecords;
if {@Balance_Due} >10 then
Shared DateVar datesigned := DATE({Contracts.DateSigned});

GF 1 - Minimum Date Signed
WhilePrintingRecords;
If {@Balance_Due} <10 then
Shared DateVar datesigned;
datesigned;


This works fine but I need to show the Minimum Date Signed in the GH1a and GH1b which occurs before my details section so it gives me either a null value or the very first date. I need the minimum date for an overdue contract.

Any help would be greatly appreciated.

Thanks!

 

[lbass]

Please share the contents of {@balance_due} and explain why you are using > and < 10.

If {@balance due} doesn't contain any summaries or certain functions like previous or next, you might be able to create a formula like:

if {@balance due} > 10 then date({contracts.datesigned}) else date(9999,09,09)

Then you could right click on this formula, insert a minimum, drag the result to the group header, and then remove the formula from the detail section.

-LB

 

[TaylorTot]

LB-

That worked perfectly!! I'm amazed it was that easy and I have been working on this for a day now :-( Thanks for your help! Big Star!

-TT