how to get the newest order date

[dreman]

Using 8.5, I am trying to get the latest order dates for the customer. In another word last time ordered. How would I initialize a var and compare it to the dates and then print it in the subtotal section.
Please help
dré

 

[HowardHammerman]

One way is to simply sort by orderdate within the customerID group. Then simply put the info you want (eg.order date, amount, etc.) in the group footer. Since you sorted by date in assending order, the last record in the group will necesarily be the last order date.
This will work very well if you are suppressing the detail section.

If you must show the detail section and you cannot accept the idea of sorting by order date (perhaps you must show by amount, etc. ) then you can do the following:

Create a running total
- Use orderdate as the field to total
- pick maximum as the summary.
- pick your customer ID group.

Place the running total in the group footer.


Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[Guest_imported]

Thank you.
Yes I think Picking running total as a maximum would work. I was trying the hard way by creating a global var. I would still would like to know about the hard way if possible.
Much obliged.
dré

 

[HowardHammerman]

OK, here is the hard way.

You need to create three formulas.

@reset
whileprintingrecords;
shared numbervar biggest := 0;

@compare
whileprintingrecords;
shared numbervar biggest;
if {table.numberfield}>biggest then biggest := {table.numberfield}

@display
whileprintingrecords;
shared numbervar biggest;
biggest


Put @reset in the report header
put @compare in the details section
put @display in the report footer

enjoy. Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[dreman]

Howard:
Thank you.
dré