<div>
CREATE a new report, then place the MILESTONE and DATE columns in the DETAILS section.<br />
<br />
then create a GROUP on MILESTONE.<br />
<br />
then right-click the DATE field and create a summaryin GROUP1 footer, ...and use MAX as the calc.<br />
<br />
then copy the MILESTONE field from the DETAILS SECTION...and paste it into the GROUP1 footer.<br />
<br />
then suppress the DETAILS SECTION and the GROUP1 HEADER...section<br />
<br />
I think that will at least get you started....<br />
<br />
LEMENO..<br />
<br />
M
</div>


CREATE a new report, then place the MILESTONE and DATE columns in the DETAILS section.

then create a GROUP on MILESTONE.

then right-click the DATE field and create a summaryin GROUP1 footer, ...and use MAX as the calc.

then copy the MILESTONE field from the DETAILS SECTION...and paste it into the GROUP1 footer.

then suppress the DETAILS SECTION and the GROUP1 HEADER...section

I think that will at least get you started....

LEMENO..

M

<div>
Create a formula on the milestone date field. &nbsp; maximum(dbo.milestone_date<wbr />)
</div>


Create a formula on the milestone date field.   maximum(dbo.milestone_date)

<div>
Sorry, I am looking for the last milestone for each project not all projects. Each project has seven milestone date fields. The milestones are separate date fields so I can't group by milestone. Any other way to find max date?
</div>


Sorry, I am looking for the last milestone for each project not all projects. Each project has seven milestone date fields. The milestones are separate date fields so I can't group by milestone. Any other way to find max date?

<div>
Thanks! &nbsp;That worked perfectly. 
</div>


<div>
 You're welcome. &nbsp;Glad I could help.<br />
<br />
&nbsp;James<br />

</div>


You're welcome.  Glad I could help.

 James


<div>
<div class="content wysiwyg-content">
I have a project report and only want to show &nbsp;the last milestone and date. There is no order or set sequence for the milestones. I have a list of 7 milestones and need to select the last milestone recorded. What is the best way to get this to show up per project. <br />
Milestone 1, Milestone 2, etc. Thanks.<br />

</div>
</div>


I have a project report and only want to show  the last milestone and date. There is no order or set sequence for the milestones. I have a list of 7 milestones and need to select the last milestone recorded. What is the best way to get this to show up per project. 
Milestone 1, Milestone 2, etc. Thanks.


Select the lates date

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.