Selecting Last Date

[sjc1956]

I want to only show the last date an entry was made in my report. There are multiple date entrys but only the last entry needs to be on my report.

 

[lupins46]

I suspect you want more than you are saying, but you will have to explain further in your next post.

To get the latest date in all the data just create a formula field which is:

maximum({mytable.Myfield})

 

[lbass]

You can use at least three methods to do this:

1-Sort your details by {table.date} descending and drag {table.date} and related fields into the group header and suppress the details. (Or sort ascending, and instead use the group footer). Or,

2-Go to report->edit selection formula->GROUP and enter:

{table.date} = maximum({table.date},{table.yourgroupfield})

This will return only the most recent record per group. Or,

3-Go to format->section->details->suppress->x+2 and enter:

{table.date} <> maximum({table.date},{table.yourgroupfield})

If you use group selection or section suppression, you will need to use running totals if you want calculations based only on displayed data. In the case of suppression, you would need to add the opposite of your suppression criteria into the evaluate based on formula section of the running total.

-LB