<div>
You can do in a variety of ways. How are you wanting to do it? Within Crystal itself? Using SQL?<br />
<br />
If within Crystal,...use the GROUP SELECT EXPERT and put your MAX logic there...or you can use RECORD SELECT EXPERT...and pull based on actual DATES....<br />
<br />
What exactly are you trying to accomplish?
</div>


You can do in a variety of ways. How are you wanting to do it? Within Crystal itself? Using SQL?

If within Crystal,...use the GROUP SELECT EXPERT and put your MAX logic there...or you can use RECORD SELECT EXPERT...and pull based on actual DATES....

What exactly are you trying to accomplish?

The-Power-and-Possibilities-of-S.pdf

<div>
I would just add that for &quot;efficiency sake&quot; I would recommend using SQL Expression as these are the fastest. If you don't know how to create SQL Logic in SQL Server you may need the help of your SQL Programmer.<br />
<br />
I've used &nbsp;Expressions on many occasions to extract a single data base object and the amount of LOGIC that can be placed within these Expressions is limitless....<br />
<br />
M
</div>


I would just add that for "efficiency sake" I would recommend using SQL Expression as these are the fastest. If you don't know how to create SQL Logic in SQL Server you may need the help of your SQL Programmer.

I've used  Expressions on many occasions to extract a single data base object and the amount of LOGIC that can be placed within these Expressions is limitless....

M

<div>
<div class="content wysiwyg-content">
need to retreive prices current date<br />

</div>
</div>


Most Current Date Max date

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

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.