Latest figures

[slickp007]

Crystal XI

Hi, i have a report which shows the history of insurance risks grouped by client and by the the last 5 digits of the risk ref. Risk references have the same 5 last digits but are given a prefix at the beginning to show the year of the risk ie A0720904 would be for the 2007 risk. In the details i have each risk in year order. My report at the moment looks like this, i've taken an example client:

Client 12342

Risk Ref Rnl Date Net Premium
A0720904 01/04/2007 2000.45
A0820904 01/04/2008 2456.45

B0622546 01/04/2006 1111.45
B0722546 01/04/2007 1542.45
B0822546 01/04/2008 2254.45


What i would like to do is in the Risk Ref Group is show the latest renewal dates net premium. So for the above example the 20904 risk would show 2456.45 and the 22546 would show 2254.45. Does that make sense?

Any ideas?

 

[slickp007]

its ok i've worked it out myself, all i did was find the maximum renewal date and then do this formula:

if {@Rnl Date} < Maximum ({@Rnl Date}, {@risk prefix}) then 0 else {RISK.NetPrem}