<div>
I'm not sure how that formula will act on the last record of the report. &nbsp;If it doesn't behave correctly for the last record you can add a check for that to Pete's formula:<br />
<br />
If OnLastRecord or ({Mytable.mygroupfield} &lt;&gt;&nbsp;Next({Mytable.mygroupfield<wbr />})) then<br />
&quot;different&quot;<br />
//do something if different<br />
else<br />
// the same ; do nothing<br />
&quot;&quot;
</div>


I'm not sure how that formula will act on the last record of the report.  If it doesn't behave correctly for the last record you can add a check for that to Pete's formula:

If OnLastRecord or ({Mytable.mygroupfield} <> Next({Mytable.mygroupfield})) then
"different"
//do something if different
else
// the same ; do nothing
""

<div>
Good point. &nbsp;It won't work on the last record in the report so your mod is needed.<br />
<br />
Pete
</div>


Good point.  It won't work on the last record in the report so your mod is needed.

Pete

<div>
<div class="content wysiwyg-content">
Hi Experts<br />
<br />
i need a function in crystal report 11 that return true if group has last record and return false if not a last record of group just like onlastrecord function. tell me how can i do this?<br />
<br />
Thanks,<br />
Ahmad
</div>
</div>


Hi Experts

i need a function in crystal report 11 that return true if group has last record and return false if not a last record of group just like onlastrecord function. tell me how can i do this?

Thanks,
Ahmad

How to get last record of group

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.