Displaying the most recent date.

[zwieback89]

Hi,

I want to display the most recent date from the column test_date. Instead of displaying all the records, I want to display the record with the most recent test_date. How to do this ?

Padmaja.

 

[FoxG]

Hi,

sort the report on testdate descending
Create a running total based on the testdate field.
Select type of summary = count
Reset on group if required

Suppress detail section if running total > 1

Hope this helps,
Geoff

 

[zwieback89]

THanks for the response, but it sounded vague to me. Could you be more specific.

1. How do we sort the report on testdate descending ?

2. What do you mean by 'Create a running total based on the testdate field.' ? Is this total a formula that I enter in the new formula and give a name to that formula ?

3. Where am I supposed to 'Select type of summary = count' ? Is 'count' the name of the formula ?

4. What is meant by 'Reset on group if required' ?

5. I did understand this statement - 'Suppress detail section if running total > 1' I rightclick on the detail, and under the suppress formula button, I am supposed to type a formula. What formula am I supposed to type ?

For your information, I have the {web_HD_Orders.Order_date} in the details section. And I want to see only the most recent order_date.

Hoping to hear more from you. I really appreciate if you are patient with my questions as I am new to CR and since the two months, I have used it, it is still very new to me.

Thanks,
Padmaja

 

[zwieback89]

Hi Geoff,

I read the help files and did what ever you mentioned. I finally got to see the most recent date.

Thanks for the help.

Regards,
Padmaja.

 

[FoxG]

Hi
I am using CR version 7. If you are using 8 it will be somewhat different

Assuming you are in the design/preview screen of your report

1. Sort Records...

You should find this under the "Report" option at the top line of your crystal report screen. After File... Edit...
Select the field order_date from the list of fields

2. Running Total...

Select "Insert" from the top
Running Total... should be in there somewhere
Create new running total called REC_COUNT
Hopefully previous message will be meaningful now...

Once created !!

Drag the running total REC_COUNT onto you detail section
Hopefully it will go from 1,2,... in your report!


3. As you thought... suppress details using formula
{#REC_COUNT} > 1


Click Preview... and hey presto !!

Geoff





3. As you thought... suppress detail
{#REC_COUNT)
d the running total fiel
select the field Order_date from the list of field available

 

[FoxG]

Thanks for the update...

Your reply must have come while I was typing mine in !!!